Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 032
“I want to program against and/or use table and database configuration information. Is there a way to access the metadata associated with those? Could I add my own metadata or comments into that area?”
This gentleman was looking for manipulating and using hidden information. He suggested that if it wasn’t available, it should be, perhaps in the form of a hidden column of data for each table.
I don’t know the answer to how programmable Metadata information is. (If someone else knows, please add it as a comment to this blog posting!)
However, you do have visibility to object metadata in SQL Server 2005 – although in fact, it’s much more tightly secured now. You won’t have the ability to access metadata about objects to which you haven’t been given permissions on.
For a description of Metadata Visibility, see the SQL Server 2005 Books Online “Metadata Visibility Configuration”
(NOTE: You’ll need to have SQL Server 2005 Books Online installed for that link to work. I highly recommend it! It’s FREE!)
Got an IT question? Give me a comment, or contact me.