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.org
WHERE 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
>