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

    Unanswered: Stored Procedure Timeouts

    I have a stored procedure as listed below.

    CREATE PROCEDURE spTest AS
    Drop table tblTest;

    SELECT top 50000 [dtm].[dbo].[SOP30300].* INTO tblTest
    FROM [dtm].[dbo].[SOP30300];
    GO

    It basically copies everything from table "SOP30300" in the "dtm" database into the database in which this stored procedure is saved.

    Because there are over 300,000 records in the source table, I'm finding that the stored procedure will time out when I call it from access. Does anyone know how i can set the timeouts?

  2. #2
    Join Date
    Jun 2002
    Location
    USA
    Posts
    21
    Hi,

    1. In Sp_configure, you will see "REMOTE QUERY TIMEOUTS" , by defualt is 600 , which is 10 minutes. You can increase this if needed. But if you increase to more time, that may allow lot of long running queries and affect performance.

    2. If you are querying a Remote Server, then in Linked Server, in "Server Option", there are 2 settings "Connection Timeout" and "Query Timeout" . By default they are set to "0" which means no timeout for any queries. I hope you didnt change this to any value.

    Hope this helps.

    Have Fun.

    Varad01

Posting Permissions

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