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

  • July 22, 2013 at 6:19 am

    #1634435

    srimkumarp-720356 (7/22/2013)

    Thanks for the information.

    We are using only Server level audit trigger.

    For example :- I created the login on one server and later drop the same login. Now I want to capture the SQL command scripts and how did it with their login ids.

    Here problem is for us Create login SQL script is not capturing using Server level trigger ,other Tasks I am able to.

    This is mainly to find the audit levels on Sql server end.

    well, the absolute best way to get instant help is to post your trigger definition here; then we can see what you are refering to , and offer suggestions.

    For example, what events is your server trigger capturing at this time? CREATE_LOGIN,ALTER_LOGIN,DROP_LOGIN?

    do you have ,AUDIT_LOGIN_CHANGE_PROPERTY_EVENT,AUDIT_LOGIN_CHANGE_PASSWORD_EVENT,ADD_LOGIN_TO_SERVER_ROLE_EVENT?

    Have you considered switching to Event Notifications, so you can capture other items with a lighter server footprint?

    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!