finding the database name

• krishna reddy-267698

  Old Hand

  Points: 380

  More actions

  October 19, 2005 at 1:08 pm

  #188129

  Hi,

   

  May i know the query i need to use to list the database name as well as other databases present in my server.

   

  thank you

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 19, 2005 at 1:10 pm

  #598445

  Select * from master.dbo.SysDatabases

  Select db_name()

• Kory Becker

  Hall of Fame

  Points: 3585

  More actions

  October 19, 2005 at 4:33 pm

  #598522

  While your at it:

  Select db_name(dbid) From master.dbo.sysdatabases

  Select db_id('databasename')

  sp_helpdb

  sp_helpdb 'databasename'

  These are nice to get use to when resolving system problems.