Adding Extended Properties to a SQL Server Instance (2005+)

• echoScout

  SSC Veteran

  Points: 263

  More actions

  March 1, 2011 at 7:29 am

  #235252

  Is there a way to add Extended Properties to a SQL Server (2005+) instance? This is part of an effort to document the purpose and context of individual database servers.

• Lowell

  SSC Guru

  Points: 323527

  More actions

  March 1, 2011 at 7:42 am

  #1292929

  extended properties are stored in a database; so to make any sense i guess you'd store instance information in master, right? that's where i'd add them;

  this worked on my master database in SQL2008:

  EXEC sys.sp_addextendedproperty

  @name = N'Version',

  @value = N'9.0.154.90'

  EXEC sys.sp_addextendedproperty

  @name = N'InstanceName',

  @value = N'LOWELL\SQL2008'

  SELECT *

  FROM fn_listextendedproperty (NULL, NULL, NULL, NULL, NULL, NULL, NULL);

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• echoScout

  SSC Veteran

  Points: 263

  More actions

  March 2, 2011 at 7:56 am

  #1293519

  Thank you Lowell. I'll take this approach.