How to hide system tables 4

[Waynest]

(SQL Server 7)

Hello

When using Enterprise Manager to view a list of tables contained in a database, the list contains a series of system tables (sysindexes etc).

These have not always appeared in the list and I would rather hide them if possible so that only tables I have created are listed. Not sure what I did to make them appear. How do I hide them?

Thanks

 

[ecobb]

Here you go, it's a FAQ I wrote on how to do this.

faq183-3092

 

[JohnDTampaBay]

In Enterprise Manager, right-click on the server name and choose Edit SQL Server Registration properties. A properties dialog box is displayed. At the bottom uncheck the Show system databases and system objects check box. Click OK and you should be good to go.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.