Skip to Content
0
May 30, 2016 at 09:21 AM

Identify system databases

137 Views

Hi There,

I would like to identify if a database is a system database or a tempdb (durability no_recovery)

At this moment I know the following methodes, but they are not 'waterproof' !

- use name of the databases (master, model, tempdb, sybsystemprocs, sybsecurity, dbccdb, sybmgmtdb)

- select name, id from master..sysdatabases where durability = 6 and dbid < 4 and dbid > 31500 (or something like this)

Are there other way's to identify them?

Regards,

Harry