Home Forums SQL Server 2005 Administering Securty Trigger stroed procedure RE: Securty Trigger stroed procedure

  • July 31, 2013 at 8:40 am

    #1637411

    not sure if that's an issue or not. on my test server, i did exactly this code, and see the command text for both;

    regardless of whether the command text is visible int he grid or not, the event does show up int eh DDL as CREATE LOGIN, and the object name is the name of the login too.

    so i don't see an error, just a situation where you are nto seeing an expected value.what is it that is not working.

    we saved the xml event data itself, right there in the audit table, so you can see what raw data we processed anyway.

    select that xml value, copy it and paste it into notepad or something.is the command text empty, or does it have a bunch of Carriage returns or something so it's hiding it in the grid?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!