Opinions on SQL 2005 systems views

[daglugub37]

Hi All,

we are on slow migration to SQL 2005. I am studying some of the changes. One being the further shielding of Administrators to work directly with system and or database catalog tables.

In 2000, there were a few views and hundreds of system procedures reduced the need to ever query the tables directly.

Just for sake of argument does anyone have, or heard of any negative aspects of inaccessible catalog tables?

 

[mrdenny]

I have found no negatives. The system views have all the information available before, you just need to know where to look.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[daglugub37]

you wouldn't happen to have come across a document that breaks down the mapping. Something that may list the 2000 system tables and their new view names and location.

 

[daglugub37]

nevermind I think I found it.

http://msdn2.microsoft.com/en-us/library/ms187997.aspx