Post reply

using sp_execuresql corresponding trigger is not fired.

  • April 24, 2009 at 1:34 am

    #95474

    hii,

    i hav a proc in which i am using sp_execuresql to execute an update query on a table.

    This works perfectly fine, but the update triggers to the table i am updating is not fired.

    kindly help.

  • April 24, 2009 at 2:35 am

    #983414

    Can you post the update statement and the trigger code please?

    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 2 posts - 1 through 1 (of 1 total)

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