my goal is to send ,in side the connection string the "pc name" for Audit

I have a connection开发者_如何学Python string (SQL Server):

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

My goal is to send inside the connection string the "pc name".

This is so I can later Audit it, or to later see the information in log file from which computer the user has been connected to the SQL Server.

---

You can have Workstation ID in the connection string. Whatever you put in there is shown in SQL Server Profiler in column HostName.

In my testing I found that if you do not specify Workstation ID in the connection string you will still get the the name of the client computer automatically.

---

Data Source=myServerAddress;Initial Catalog=myDataBase;
User Id=myUsername;Password=myPassword;Application Name=yourpcname

If "yourpcname" is the name of your PC. In SQL profiler or login audit - capture the Application Name for a specific SQL user ID.

Note: It is recommended to use Windows authentication whenever possible.