That data does not exist in SQL Server. The connection string is how the caller connects to SQL Server.
What exactly are you looking for?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Fellow SQLers,
I am trying to see if I can capture the actual connection string used when a user connects to SQL.
I know I can capture their options (Set ….. etc) but cannot find an event that give me the actual connection string.
Is it doable with Ext Events?
Thx
MG
That data does not exist in SQL Server. The connection string is how the caller connects to SQL Server.
What exactly are you looking for?
As Tom says, this is not possible. The connection server is the client's business, and not SQL Servers. You can deduce some of the contents down in SQL Server, for instance by looking at functions such APP_NAME() or HOST_NAME(). But things like passwords, connection timeout, or configuration of the connection pool never makes it to SQL Server.
Thanks Guys.
I can take it from here.
mg