Is there anything equivalent for SQL Server?
I also posted this here, but got no response so thought I'd check in the security forum.
I'm not sure that there is a property which is exactly suited for passing custom user data, but there is a property which you might modify without affecting pretty much anything else.
The property is "Application Name" (SSPROP_INIT_APPNAME).
|||I see where you're going with that, but is there a SQL function to detect the application name from the connection string of the currently connected person?
|||Hi,
What you can do to get the application name provided in the property is to run a statement like this:
select program_name from master..sysprocesses where spid=@.@.spid
HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment