Hi,

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.

Thanks

Chris

Chris,

Actually what you want to start with are the Catalog views. This link in
2005 BOL will point you in the right direction.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/13bccc2f-ed3c-4b58-abd0-ca8bf34a66b8.htm

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
the objects.

--
Andrew J. Kelly SQL MVP


"Chris Wood" <anonymous (AT) discussions (DOT) microsoft.com> wrote