What is my db name?

• John Nolan

  Mr or Mrs. 500

  Points: 581

  More actions

  February 19, 2007 at 9:16 am

  #172137

  Hi,

  I am just writing a simple procedure to backup a database through my application but I don't know what the db will be called until i install the application. I can get to this information through other means but I'm sure that there must be a method within SQL. Is there

  anyway I can tell which of the datbases listed in sys.databases my stored procedure is being called from?

  Thanks

  John

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  February 19, 2007 at 9:19 am

  #690509

  Try the db_name() function?

• John Nolan

  Mr or Mrs. 500

  Points: 581

  More actions

  February 19, 2007 at 9:30 am

  #690513

  ahem... I swear to the almighty that I scanned BOL and google for that.

  **feeling rather sheepish**

  thank you