SSMS - Database Properties Page

Question

SSMS - Database Properties Page

Brandie Tarvin

SSC Guru

Points: 173108
More actions
September 14, 2007 at 5:29 am

#178348

My BOL entry is a stub that points to ALTER DATABASE ... GRRR.
Can anyone tell me what the Extended Properties page is for under Database Properties in SSMS? I can enter any text I want to in NAME and then I click on the elipses for Value and I just get a pop-up box with no definitions and no explanation. It just waits for me to enter something in there.
Thanks in advance!
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

You can add extended properties to the whole database, i.e. not to schema, objects, or columns. These have the level0type (as well as level1type and level2type) set to null.

You can read more about this on ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/af4ec14e-637d-4f60-9008-317230354cb0.htm

in the Database section.

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 2

I can't reach that URL. IE keeps complaining about a bad gateway.

Is there a KB # or a search term I could use to find it?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 3

You can paste the link to Microsoft document explorer (BOL)

Alternatively the same is available on:

http://technet.microsoft.com/en-us/library/ms190243.aspx

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 4

Andras,

Thanks for clarifying my link issues. I thought you were talking TechNet, not BOL. @=)

You know, I already knew all this extended property stuff. I guess I just didn't realize this window was a way of shortcutting the extended procs. DUH! I feel silly now. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.