I need to capture the logon event and set some options (SET DEFAULTS, SET ANSI_NULLS, etc) and those options should be set that way during all the user's session. I thought a server trigger for logon would do it, but I found out it runs
BEFORE the user's session begins, so it does not do the job. I need to set the options
only for certain users of an application I don't have the code for.
I also read it could be done using alerts and auditing, but I'm not sure how. I would appreciate any suggestion.
View Complete Post