Find user databases in SQL 2005

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  March 16, 2006 at 3:16 pm

  #116643

  What is the easiest way to tell if a database is not a system database in SQL 2005. What would be a select that would give me this info for a script, I have looked at sys.databases and can not see a column that states this, may be missing it though?

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  March 17, 2006 at 2:32 am

  #627210

  Hi,

  U can check two views sys.databases and sys.sysdatabases then u can easly notice that there 6 sysdatabases given id as 1 to 6 and else are userdefined databases.

  So can use 1 to 6 db_id as system databases.

  HTH

   

  from

  Killer

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  March 17, 2006 at 8:49 am

  #627360

  Thanks, I will take a look.