March 1, 2011 at 7:29 am
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.
March 1, 2011 at 7:42 am
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
March 2, 2011 at 7:56 am
Thank you Lowell. I'll take this approach.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy