Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Increasing the Timeout on Views In EnterPrise Manager

Status
Not open for further replies.

freewilly

Programmer
Joined
Feb 19, 2001
Messages
43
Location
AU
Hi Team

I have some views that take a while to run in enterprise manager and they time out before they are finished. How do I set the timeout?

Thanks FW
 

How are you running the views in Enterprise Manager? Are you opening them and returning all rows? Try selecting from the views in Query Analyzer. EM has some problems when opening tables and views. Which version of SQL Server do you have? SQL 7 Enterprise Manager seemed to have more problems with this than SQL 2000. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top