Getting the Computer Name from T-SQL

[shanegarcia]

Hi,

I'm writing a trigger that logs updates to the database as part of audit requirements. I can get the SQL Login name of the user who made the changes but I'm also being asked to log the workstation used to perform the update. Is there a way to do this in SQL?

I'm using Windows 2000 and SQL 2000.

Any help would be greatly appreciated.

Thanks!

 

[gavinhuet]

Look at the SQL function HOST_NAME()...

SELECT HOST_NAME()

-- gavin