Current database name

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  November 11, 2009 at 9:57 am

  #142985

  I know you can return which server you are on with

  select @@servername

  Is there something for current database?

• Mark Cowne

  One Orange Chip

  Points: 26976

  More actions

  November 11, 2009 at 10:03 am

  #1077911

  SELECT DB_NAME()

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  November 11, 2009 at 10:05 am

  #1077913

  thanks