Hello

I need some help to create a login trigger for setting a trace flag.
I have an issue that will be resolved by setting this trace flag but I
only want it set for 1 specific login id. I have found examples of
other login triggers but I am having a hard time figuring out how to
create one to set a dbcc traceflag. Any help would be appreciated.

Trace Flag 15393

Sandra

On Wednesday, 2 May 2012 13:36:12 UTC+12, Sandra wrote:
What version are you on?
It should be as simple as creating a stored proc in the login's default database that has the code "set switch on 15393" and then setting that as the "login script" for the login. Pretty simple in my experience...

On May 2, 8:34*pm, Antony <albion26.... (AT) gmail (DOT) com> wrote:
Thank you for your reply. I guess I am making it more complicated
then it needs to be. The example I saw was creating a lookup table
and then inputting data into that. It was just confusing to me. I
will go the route of creating a stored procedure and using that as the
login script.

BTW my version is ASE 15.0.3 ESD #4

Sandra

On Friday, 4 May 2012 03:14:03 UTC+12, Sandra wrote:
I'd avoid doing anything in the login trigger that could cause problems or fail... Inserting into a table could be subject to deadlocks, blocking, space issues etc.

Keep It Simple.