Update to trigger recompile problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Update to trigger recompile problem

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
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.