June 19, 2008 at 8:14 am
Hi there,
How do u unhide system tables in SQL 2005?
I know how to do this in 2000 but how in 2005.
Regards
Imke
June 19, 2008 at 9:39 am
There really are no more system tables in SQL 2005. They are views that look at tables that users cannot see. Look under the Systems Views of the Master database
Andrew SQLDBA
June 19, 2008 at 10:16 am
Use will have to use DAC to login to SQL Server instance and then try Querying the system tables and View.
specially to get a list of all system Views select * from sys.all_views
But Unhide.. Hmmm how did you do that in SQL 2000.
Arent they already visible in master and other DB's.
If there is another way, Pl ignore my ignorance and I would surely like to know, since that will help me update my knowledge....
Maninder
www.dbanation.com
June 19, 2008 at 10:23 am
If you're trying to get information out of them - you really want to stick to the DMV's. the views simply took over for the tables, so they really should serve your purposes.
Playing in the system tables has always a dangerous proposition, so SQL Server 2005 makes it just about impossible to directly query and/or update the system tables (Paul Randal recently talked about a method where you COULD modify the system tables).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply