extracting current database name

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  September 3, 2002 at 12:29 pm

  #158304

  Can anyone tell me how to extract the current name (or id) of the database through a t-sql statement?

  Thanks

  
  "Keep Your Stick On the Ice" ..Red Green

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736193

  More actions

  September 3, 2002 at 12:54 pm

  #435870

  select db_name()

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  September 3, 2002 at 1:21 pm

  #435872

  Thanks Steve. I was playing with that and it is just amazing what the paranthesis can do 🙂

  Today, I feel like a rock!!!

  Thanks!

  
  "Keep Your Stick On the Ice" ..Red Green