View Full Version : SQL Server 2000 - how do I hide system tables


bobtail
11-05-2005, 14:41
Hi,

The database I have been steadily growing. I understand that it is possible to hide the system tables - i.e. syscolumns, sysfiles etc.

I have completely forgotten how to do this. Can anyone offer some advice?

Thanks in advance

AaronD
11-05-2005, 14:49
Hi,
Right click the SQL server in the SQL server group and click edit SQL server registration properties. There should be a tick box in there called show system databases and objects. Simply untick and that should be it.

At least that's with SQL Server 2k

Aaron

bobtail
11-05-2005, 14:51
Fantastic.

You are a star.

Many thanks.

:clap: :clap: :clap: :clap: :clap: :clap: