determine system database...

Mark B

what is the best way to determine if a database is actually a system
database through tsql?

The only tangible thing that I can see is dbid. however I would far rather a
database property to check in t-sql.

Thanks in advance,

M.

Pawel Potasinski

Here is some idea.

Check how Microsoft guys are doing that. Build a simple application that
uses Microsoft.SqlServer.Management.Smo.Database.IsSyst emObject property
for each database. Run Profiler and see how SMO is checking if the database
is a system database or not.

--
Regards
Pawel Potasinski
[


U¿ytkownik "Mark B" <> napisa³ w wiadomo¶ci
news:.gbl...
> what is the best way to determine if a database is actually a system
> database through tsql?
>
> The only tangible thing that I can see is dbid. however I would far rather
> a database property to check in t-sql.
>
> Thanks in advance,
>
> M.
>