Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78

    Unanswered: Timeout on the rs utility

    The following webpage desribes the rs utility:-
    http://msdn2.microsoft.com/en-us/library/ms162839.aspx

    And it says that rs supports the optional parameter, -ltimeout

    Can someone tell me what this timeout does/means?

    We are passing in a VB.NET script file that reads an XML file that executes a series of reports. Does the timeout apply to the whole VB.NET script file, or to the individual execution of each report?

    Can you also tell me, what happens if it times-out? Does SQL Server kill the SQL job generating the report? Or does it just disconnect the client from the server leaving the job to continue generating the report?

    Thanks

  2. #2
    Join Date
    Aug 2007
    Posts
    17
    There are two types of sql server timeout :connection-timeout,execute-timeout.please test the db connection firstly to firm network available.if it is connection-timeout,your script can't run,nothing serious.

    if it is execute-timeout,it means that execute process is abort.it doesn't affect the connection between client and server.if the script is a transaction,it will be rollback,nothing serious.If not ,it would had executed for a period of time .the result perhaps is wrong if your reports refers data calculation.

    sudden disconnction to db also results execute-timeout.but you must confirm which type it is,then you can resolve it.

Posting Permissions

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