How to get the name of user machines connected to one sql server instance in a clustered environment ?

• SQL Kidu

  Ten Centuries

  Points: 1296

  More actions

  July 15, 2009 at 3:05 am

  #132964

  I have a sql server clustered environment. I am using host_name() function to retrieve the user's machine name.

  But it is giving only the server name in return. Is it because it is a clustered environment ? Any solution for this ?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 15, 2009 at 6:40 am

  #1024971

  Very strange...

  Have you tried this:

  select hostname from master.dbo.sysprocesses where spid = @@spid

  Does it return the same?

  -- Gianluca Sartori