开发者

ssms script trigger timeout

开发者 https://www.devze.com 2022-12-15 07:02 出处:网络
Using the SSMS (Sql server management studio) 2008 ide, I frequently get timeouts asking it to script a trigger (or table) to a new query editor window.

Using the SSMS (Sql server management studio) 2008 ide, I frequently get timeouts asking it to script a trigger (or table) to a new query editor window.

This particular time, the error message is Script failed for Trigger 'spbldrom_update'. Additional information: - An exception occurred while executing a Trasact-SQL statement or batch. - Timeout expired. The timeout period elapsed prior to completion of the operatio开发者_StackOverflown or the server is not responding. (Microsoft SQL Server)

It takes about 5 minutes for the timeout to occur.

It happened on my prior computer. It happens on my new Windows XP computer, and my new Windows 7 computer.

I have searched for other people reporting this, but have not found many reports, and no answers, other than increasing the timeout. But since it takes about 5 minutes to get the timeout, I don't think increasing the timeout will help.

0

精彩评论

暂无评论...
验证码 换一张
取 消