Monday, August 1, 2011

How to get the current user and Machine from which a query is executed in SQL server?

You can use select host_name() for getting the name of the machine from which the querry has been excecuted and for getting the windows user which excecute the querry tou can use the caommand select SYSTEM_USER

No comments:

Post a Comment