Posted by Erland Sommarskog on 07/06/07 08:55

Aaron Bertrand [SQL Server MVP] (ten.xoc@dnartreb.noraa) writes:
> I think Mohit may be onto something here. Erland, are you trying on the
> local server connection, or a remote query?

Bingo! When I connect to a remote server and run the WAITFOR, I get the
timeout error. And if I then switch connection back to the local server,
I now get the timeout error there as well. I can open new windows to the
local server, I can stop and restart SSMS again, and the timeout error
keeps on coming for the local server.

An absolutely baffling bug!

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=286298


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Learn Oracle Database Administration in 10 Minutes
• Prev in forum: Re: Connect using different Windows user name...?!?!
• Thread view: Re: SSMS - getting timeout terminated even with Execution time-out of 0?

[Reply to this message]