Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 I don't want to see systems objects

Author  Topic 

dew_girl
Starting Member

1 Post

Posted - 2006-06-14 : 09:51:20
I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks


informatics

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-06-14 : 12:38:14
EM->SQL SERVER->EDIT SQL server registration properties-> DE-SELECT sysstem databases and system objects.

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-15 : 02:45:14
quote:
Originally posted by dew_girl

I don't wich choice should I made to avoid have to see the systems objects, for intance, when I open the tables of any Data Base I have like 50 that I haven´t create, so if any one can help me, I will be gratefull, it might sound like BOBO, but I jist don't know. Thanks


informatics


If you use SQL Server, then use query to exclude system objects

Select * from sysobjects where xtype<>'s'

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -