Post reply

FOR AFTER DELETE trigger

  • May 27, 2008 at 3:47 am

    #99143

    Hi

    How do i get the event details in a "FOR AFTER DELETE" trigger - the user who executed the query, the command / sp the user passed, the ip / network address of the user?

    Txs

    Alwyn

  • May 27, 2008 at 10:17 am

    #820661

    [font="Verdana"]Run SQL Profiler, through which you can get all the information you desired.

    Mahesh[/font]

    MH-09-AM-8694

  • May 27, 2008 at 10:21 am

    #820665

    Keep in mind that you need to track the SQL:stmtCompleted event (not one of the default options) to catch the trigger firing.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • May 27, 2008 at 11:22 am

    #820709

    duplicate post

    http://www.sqlservercentral.com/Forums/Topic506818-338-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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