When you connect to SQL Server using SQLConnection, how to set client machine name(or IP address) so that you can monitor the process on Server side using Enterprise Manager?
Whatever IP address you provided in the connection string can be used to monitor along with the user id of sql in case mixed mode authentication is there.
Please post more details..
Satya
|||In your connection string, you can add a name/value pair like
workstation id=MYCOMPUTERNAME
and now when you runsp_who you will see MYCOMPUTERNAME for the value in thehostname column.
You can also set a value for you application like
Application Name=Your Application
within your connection string.
No comments:
Post a Comment