How do Increase the time out time in Enterprise Manager?

Question

Post reply

How do Increase the time out time in Enterprise Manager?

lindss01

SSCrazy

Points: 2264
More actions
January 17, 2005 at 11:53 am

#87442

Thanks for any info.

Steve

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

JR-104739 SSC Veteran Points: 295 More actions · Answer 1

Hi

Can you elaborate a little more the question ?? time out for what kind of querys, connection, etc ??

Here some info., right click on the server name, select properties, tab connection, in the second square exist an option for change time out..

But there´s differents time outs.. in QA run sp_configure and check..

JR

Umesh Chaphekar SSC Veteran Points: 237 More actions · Answer 2

Hi,

You can also use Tools --> Option --> Advance tab to set the connection settings. This setting will apply for all the servers registered in your Enterprise Manager.

You can set the Login timeout and connection time out.

Hope this helps.

Regards

Umesh Chaphekar

--Every minute you waste someone gains on you ---

lindss01 SSCrazy Points: 2264 More actions · Answer 3

It is a select with a sum and group by.

Tools-> Options are set to 4, 0, 0

'right click on the server name, select properties, tab connection, in the second square exist an option for change time out.. is set to 600 changed it to 0 and still getting the timeout.

This query runs in Query Analyzer

Here is the query...

SELECT dbo.tblWeeklyExtract.Supplier, dbo.tblWeeklyExtract.PlanCode, dbo.tblBridgeSwitchLookup.BridgeDesc, dbo.tblWeeklyExtract.State,

SUM(dbo.tblWeeklyExtract.RXS) AS RXS

FROM dbo.tblWeeklyExtract LEFT OUTER JOIN

dbo.tblBridgeSwitchLookup ON dbo.tblWeeklyExtract.BridgeSwitch = dbo.tblBridgeSwitchLookup.BridgedSwitch

GROUP BY dbo.tblWeeklyExtract.Supplier, dbo.tblWeeklyExtract.PlanCode, dbo.tblBridgeSwitchLookup.BridgeDesc, dbo.tblWeeklyExtract.State

HAVING (dbo.tblBridgeSwitchLookup.BridgeDesc = N'Plan Code')