UNABLE TO SEE SYSTEM TABLE IM NY ENTERPRIsE MANAGER

microsoft.public.sqlserver.programming

18 Mar 2006 11:43 AM

Savas Ates

When i choose my database in enterprise manager i cant see my system table ?
What is the setting to see them ?

18 Mar 2006 11:51 AM

markc600

In Enterprise Manager, right click on the SQL Server Instance

Select "Edit SQL Server Registration Properties"

Tick "Show system databases and system objects"

18 Mar 2006 11:52 AM

Tom Moreau

Right-click on the server, click Edit SQL Server Registration Properties,
then check Show system databases and system objects.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..

"Savas Ates" <in da club> wrote in message
news:ueT6oEoSGHA.1236@TK2MSFTNGP11.phx.gbl...

When i choose my database in enterprise manager i cant see my system table ?
What is the setting to see them ?

18 Mar 2006 11:55 AM

Savas Ates

thanks both of you.