Thursday, August 24, 2006
Connection String Values # 2
At here http://aim48.blogspot.com/2006/06/suggestion-sql-c... I was wodering if the SQL team could add connection scope variables to the connection string to allow web app level user logging - it seems that there already is one that you can use. In your connection string you can hijack the "application name" setting and pass in the user id and then in TSQL you can retreive that value using the APP_NAME() function.
Application name isn't really ever used anymore (in fact by default .net applications send "SQL Native client etc....." So I don't think there would be a major problem using it