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.

    http://www.msusenet.com/history/topic.php/3230545-1.html


    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.

    Thanks
    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page