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!

Register Log in
  • 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!

raise timout period on query analyzer

Status
Not open for further replies.
smsinger3

smsinger3

Programmer
Oct 5, 2000
192
US
Hello all.

Is there a way to raise the timeout period in SQL Analyzer? I am running a sql script that times out after 10 minutes. (The queries probably need tuning first, but I still would like to give it some more time)

Thanks,

SteveS
 
Sort by date Sort by votes
By default, Query Analyzer doesn't have a timeout for scripts.

However, you can change it by going to Tools - Options - Connections and changing the Query time-out setting. Set to 0 for infinite.

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
385
Chriss Miller
C
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
860
SashaBuilder3
SashaBuilder3
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
830
Andrzejek
Andrzejek
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
537
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
587
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top