Post reply

Question regarding TimeOut when for example updating table

  • April 18, 2007 at 2:59 am

    #68610

    Hi,

    We have a trigger on a table and when a Table.column is updated from 'N' to 'Y' runs a cmdshell command.

    Question: Is there a parameter that one can control when a time out will occur ? (For example that a timeout will occur after 5 Minutes instead of 30 seconds )

    See attached fileTimeOut Error

     

     

  • April 18, 2007 at 9:02 am

    #701147

    Hi cmt,

    I can't see you error message but I suspect that your time-out is caused by the client and not SQL Server. SQL Server actually doesn't have a query timeout setting, because with huge databases you never know how long a query might take.

    If I remember right the default timeout for .Net applications is 30 sec. So that's most likely your problem.

    You can test your trigger by executing the command in Query Analyzer. In QA under Tools\Options on the tab connection you can set a query time-out. The default is 0 which means no timeout. Leave it like that and execute your query.

    Markus

    [font="Verdana"]Markus Bohse[/font]

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

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