determining what are "system" objects in sp_help or system tables

Hi,

I have a few things on my databases which seem to be neither true system
objects or user objects - notably a table called 'dtproperties' (created
by Enterprise manager as I understand, relating to relationship graphing
or something) and some stored procs begining with "dt_" (some kind of
source control stuff, possible visual studio related). These show up when
I use

"exec sp_help 'databaseName'"

but not in Ent. Mgr. or in Query Analyzer's object browser, and also not
in a third party tool I use called AdeptSQL. I am wondering how those
tools know to differentiate between these types of quasi-system objects,
and my real user data. (This is for the purpose of a customized schema
generator I am writing). I'd prefer to determine this info with system
stored procs (ie sp_help, sp_helptex, sp_...etc) but will dip into the
system tables if needed.

Thanks,
DaveDave C. (spam@.spam.spam) writes:
> I have a few things on my databases which seem to be neither true system
> objects or user objects - notably a table called 'dtproperties' (created
> by Enterprise manager as I understand, relating to relationship graphing
> or something) and some stored procs begining with "dt_" (some kind of
> source control stuff, possible visual studio related). These show up when
> I use
> "exec sp_help 'databaseName'"
> but not in Ent. Mgr. or in Query Analyzer's object browser, and also not
> in a third party tool I use called AdeptSQL. I am wondering how those
> tools know to differentiate between these types of quasi-system objects,
> and my real user data. (This is for the purpose of a customized schema
> generator I am writing). I'd prefer to determine this info with system
> stored procs (ie sp_help, sp_helptex, sp_...etc) but will dip into the
> system tables if needed.

select objectproperty(object_id('tbl'), 'IsMSShipped') reveals these
funny tables.

An answer by the way, that probably can be retrieved by spying on the
various tools with the SQL Profiler.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp