SQL Server Performance

Update to trigger recompile problem

Discussion in 'T-SQL Performance Tuning for Developers' started by dazzamand, May 22, 2005.

  1. dazzamand New Member

    Hi all, I have a link below to an article which I would like some feedback
    from, the article talks about difficulties regarding recompiles of trigger
    objects. We experience that exact problem that causes some of our electronic
    transactions to time out. I was wondering if someone could answer the
    following questions for me.


    1. Is this really by design, and is there anyway around it in SQL server 2000
    2. Does this behaviour still occur in SQL 2005.

    Darryl. S

  2. satya Moderator

    Take help of Profiler to check the recompile events, make sure removing the WITH RECOMPILE option from the definition.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page