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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 dtproperties system table and enterprise manager..

Author  Topic 

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2001-08-23 : 09:11:59
I noticed that the dtproperties table shows up as a system table in EM, but in the sysobjects table it is classifed as a user table. Is there something else besides the type and xtype column in the sysobjects table that I should be looking at to exclude all the system objects in my queries?

Daniel
SQL Server DBA
   

- Advertisement -