Thursday, March 29, 2012

determine system database...

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.
cannot get it to work.
smo throws exception when I create the database object.
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:%23pkyNj%23OIHA.3816@.TK2MSFTNGP04.phx.gbl...
> 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
> [http://www.potasinski.pl]
>
> Uytkownik "Mark B" <nospam@.nospam.com> napisa w wiadomoci
> news:eEvpWO%23OIHA.4808@.TK2MSFTNGP05.phx.gbl...
>
|||cannot get smo property to work!
"Pawel Potasinski" <pawel.potasinski@.gmail.com> wrote in message
news:%23pkyNj%23OIHA.3816@.TK2MSFTNGP04.phx.gbl...
> 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
> [http://www.potasinski.pl]
>
> Uytkownik "Mark B" <nospam@.nospam.com> napisa w wiadomoci
> news:eEvpWO%23OIHA.4808@.TK2MSFTNGP05.phx.gbl...
>

No comments:

Post a Comment