Should I create the support objects required to use database diagramming?
sql-server, sql-server-2008-r2
Solution
Based on the comments, it adds [dbo].[sysdiagrams] to the database's system tables node. The objects below are also added to the database (source).
Please weigh the consequences. Is this a development or a production database? If you add these objects, with your current deployment model, do they get deployed to higher environments? Is the database in a secure location? Does the database contain sensitive information?
Objects:
sp_upgraddiagrams
sp_helpdiagrams
sp_helpdiagramdefinition
sp_creatediagram
sp_renamediagram
sp_alterdiagram
sp_dropdiagram
fn_diagramobjects (in question)
sysdiagrams dt_properties (?)
Problem
When I click on database diagrams in SQL Server Management Studio 2008 R2, some databases tell me the following message: This database does not have one or more of the support objects required to use database diagramming. Do you wish to create them? Are there any concerns (i.e. security?) in doing so? The databases aren't mine