Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: SQL Server Timeouts

    Is there a way to increase the SQL server timeouts? I have a SQL server backend with an Access front end. The transaction table currently contains 800,000 records.

    For example if i run a

    SELECT Min(MyDate) FROM tblTransaction;

    it times out after a few seconds.

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I know that ADO has a parameter on Command object called CommandTimeout that you can use to increase command execution time. I don't know what you are using.
    MCDBA

  3. #3
    Join Date
    Jul 2002
    Location
    Bucharest - Romania
    Posts
    6
    If you are executing your queries directly from ent.manager you can change the query time out in the 'connections' tab from the properties window of your server.

  4. #4
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    43

    Timeouts

    I'm not sure this is entirely relevant to your problem but...
    certain sp's allow to set a "timeout" parameter as for example when using replication. in this case you can "force" the merge replication agent to use longer timeout periods by simply adding the parameter -QueryTimeOut nnn (where timeout nnn sequence is specified in seconds)
    after the name and other parameters of the sp.
    This can also be set for example with the BCP routine in Mssql although i can't recall how the parameter is called in the case of bcp.
    Greetings, VincentJS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •