Quick sysobjects Question

Hi,
How do I distinguish user objects from system objects in the sysobjects
table (other than user tables and system tables)?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgWHERE OBJECTPROPERTY(id, 'IsMsShipped') = 0
However, there are some gotchas, such as sysdiagrams, dtproperties, and
maybe some replication objects...
A
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||Hi,
Take a look into INFORMATION_SCHEMA views.
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23aw9FX3BHHA.1220@.TK2MSFTNGP04.phx.gbl...
> Hi,
> How do I distinguish user objects from system objects in the sysobjects
> table (other than user tables and system tables)?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>