>After a client application has connected to SQL Server 2005 via ODBC, using SQL Server Authentication, and the client application has passed the work station ID (WSID) in the connection string, is there a function or property inside of SQL Server that will refer to that WSID?
>
>I would like to use the WSID value as a default in some tables when a new record is added.
>
>Thanks for your help,
>
>Tom A.
Check
HOST_Name() and
HOST_ID()
If it's not broken, fix it until it is.
My Blog