System Table Diagram for SQL2005 - 12-19-2005 , 05:15 PM
Is there a resource online that shows the system table information for
SQL2005? I know that I should be using DMV's and not accessing the actual
tables. Perhaps I should be asking for a diagram of the DMV's.
Re: System Table Diagram for SQL2005 - 12-19-2005 , 05:57 PM
Actually what you want to start with are the Catalog views. This link in
2005 BOL will point you in the right direction.
They are the best way to access what you would think of as the system
tables. DMV's are really more for monitoring the state of the server and
Andrew J. Kelly SQL MVP
"Chris Wood" <anonymous (AT) discussions (DOT) microsoft.com> wrote