Returning the name of the database

• JulieW

  Say Hey Kid

  Points: 680

  More actions

  November 18, 2003 at 3:28 am

  #162695

  Hello,

  Can anyone tell me the best way to return the name of the database that I am currently working in ?

  I am attempting to write SP that capture batch update errors in various Databases.

  Thanks

  J

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  November 18, 2003 at 3:38 am

  #482389

  select db_name()

• JulieW

  Say Hey Kid

  Points: 680

  More actions

  November 18, 2003 at 3:40 am

  #482390

  Thanks Ian

  J