Help to Resolve the Problem

[sammy]

I am facing a problem with system objects. My requirement is that I do not want the system objects to be displayed when I make a query on sysobjects table. Is there any way for achieving this? Kindly suggest me.

[manujaidka]

Please try this query

select * from sysobjects where status not like '-%'

[cyrus]

There is surely various ways of avoiding system objects from being displayed when you make a query on sysobjects table. One of the ways of achieving the above is as below:
Select * from sysobjects where xtype<>'s'
The above would avoid the system objects from being displayed.

[a.karrabi]

there is a field that show you object type "TYPE" .
type of object that you create it if 'u'.
select * from sys.objects where type = 'u'