Re: which statement fire the trigger ?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 08:37:16 -0500

What I meant was you can see the events leading up to the trigger and then
the trigger execution so you should be able to deduce what caused it. Sorry
for the confusion. 

-- 
Andrew J. Kelly  SQL MVP
"Vinod Kumar" <vinodk_sct@NO_SPAM_hotmail.com> wrote in message 
news:cs2cu1$pet$1@news01.intel.com...
> In 2000? Is this possible? What are the Events I need to include?
>
> -- 
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:eIoDvtD%23EHA.1296@TK2MSFTNGP10.phx.gbl...
>> You can use profiler.
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "TLV" <tlv@cassava.net> wrote in message
>> news:%23FFtfRD%23EHA.2112@TK2MSFTNGP10.phx.gbl...
>> > Hi ,
>> >
>> > Is there any way to get the sql statement that fire a trigger  ?
>> >
>> > Thank you in advance ,
>> > TLV
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: lastmodified
    ... Andrew J. Kelly SQL MVP ... >> UPDATE YourTable SET = GETDATE ... >> Andrew J. Kelly SQL MVP ... >>> Can someone provide me a simple trigger where it updates a lastmodified ...
    (microsoft.public.sqlserver.security)
  • Re: Best Practice - xp_cmdshell question
    ... If so, this would not> work, because users cannot be asked to wait for 1+ minutes before a tag> prints. ... >>> Why not have the trigger insert the data into a table and then have a>> scheduled job routinely poll the table for items to be printed. ... >> Andrew J. Kelly SQL MVP ... >>>> locks) wait on a batch file is really suicide. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie Question - Creating Triggers within Stored Procedures
    ... Aaahhhh...thank you, Andrew. ... > You can't have a GO in the stored procedure code. ... > pieces (table creation and trigger etc) in Dynamic sql though. ... > Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: TRANSACTION QUESTION
    ... a trigger you always have the deleted virtual table. ... Andrew J. Kelly SQL MVP ... > (Just like ORACLE does). ...
    (microsoft.public.sqlserver.programming)
  • Re: Triggers and Data Driven Query
    ... I figured it was some kind of audit trail but I couldn't determine how this: ... You state you can see the trigger firing but you still don't say ... Andrew J. Kelly SQL MVP "David Fuller" wrote in message ...
    (microsoft.public.sqlserver.dts)
Quantcast