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?