currently connect to which instance????

• iain lastname

  SSC Eights!

  Points: 912

  More actions

  August 31, 2007 at 8:31 am

  #176370

  Hi,

  I want to confirm the instance I'm currently connected to via SQLCMD - does anyone know how I get this info?

  i.e. SELECT @@INSTANCE_NAME

  or something of that ilk.

  Any help is much appreciated

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 31, 2007 at 8:40 am

  #730802

  SELECT @@SERVERNAME should do it.

  John

• iain lastname

  SSC Eights!

  Points: 912

  More actions

  August 31, 2007 at 9:10 am

  #730809

  thanks, that worked. Much appreciated.