Query Timeout

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Thanks for the quick response, however timeout value for the server in Enterprise Manager is 0. That's what actually confuses me with the timeout messages.

-- Anonymous, June 22, 2000



Well... There is a knowledge base article, Q247070, at http://support.microsoft.com/support/kb/articles/q247/0/70.ASP that explains that if you open a view which executes a long running query, SQL Enterprise Manager will get an ODBC timeout error after 30 seconds and there is nothing you can do to change the timeout value.

Perhaps service pack 2 will have a fix, but I cannot confirm that.

Good Luck,


-- Anonymous, June 22, 2000

Moderation questions? read the FAQ