Post reply

setting query timeout value for a single statement

  • June 20, 2003 at 2:59 pm

    #81074

    Hellooo...

    I'm working on a stored proc which executes a remote procedure call. I want to specify a timeout value so that the remote proc call fails if it doesn't return data in 30 seconds or less.

    I know there's a way to set timeout values on the server as a whole...

    But is there a way to set this for a single statement in one stored proc, without affecting anything else on the server??

    Thanks,

    -Skip

  • June 20, 2003 at 3:41 pm

    #462481

    Not that I'm aware of.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • June 20, 2003 at 4:10 pm

    #462485

    Use:

    SET QUERY_GOVERNOR_COST_LIMIT

    and check in BOL for more info

  • June 23, 2003 at 8:38 am

    #462633

    thanks...

    does SET QUERY_GOVERNOR_COST_LIMIT take SECONDS as the supplied value?

    Just to make sure I'm understanding this correction...

    does this statement mean "kill the query (i.e. timeout) if the statement takes more than 30 seconds to complete"???:

    SET QUERY_GOVERNOR_COST_LIMIT 30

    thanks,

    -skip

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

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