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