阅读背景:

SQL Server数据库在触发器执行时挂起

来源:互联网 

We have implemented 6-7 trigger on a table and there are 4 update trigger out of these. All of the 4 triggers require long processing because of data manipulation and conditions. But whenever trigger executes then all the pages on the website stop responding and hangs for every other user from different systems also. Even when we execute update statement in SQL Server Management Studio on the trigger holding table then it also hangs. Can we resolve this hanging issue by shifting this trigger code into the stored procedure and call this stored procedures after update statement of the table?We have implemented 6-7 trigger on a table and




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: