How do Increase the time out time in Enterprise Manager?

  • Thanks for any info.

     

    Steve

  • 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

  • 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



    Umesh Chaphekar

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

  • 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')

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

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