ssms script trigger timeout
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.
精彩评论