Post reply

EventData function, 'alter login' statement not being captured

  • May 17, 2010 at 7:02 pm

    #221111

    Hi,

    I've created a server level DDL trigger which is supposed to log any security changes on the server. I've defined one of the columns as

    @TSQLCommand = EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand)[1]','nvarchar(max)')

    When I run a statement like this:

    ALTER LOGIN test WITH PASSWORD = 'asdf';

    My @TSQLCommand does not capture anything, while if I run any of these:

    DROP LOGIN [test2]

    DENY CONNECT SQL TO [test]

    GRANT CONNECT SQL TO [test]

    I get all of them captured in my log table.

    Any ideas?

    Thanks.

  • October 26, 2010 at 3:26 am

    #1242105

    This would be easier for everyone if you actually posted an example of the code that you are using to see why you might not be getting the ALTER LOGIN statements

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply