SQL Server Query : Host name

Question

I have the exact Query Text and the exact time & date the Query was executed, how can I find the Host Name that executed this query?

I'm using SQL Server 2008.

Answer 1

Do you need @@SERVERNAME

SELECT @@SERVERNAME

will return the server name where the query was executed.

---

HOST_NAME will return the workstation name

SELECT HOST_NAME()