Testing SQL Timeout 1

[RileyCat]

Is there such a thing as forcing a timeout in a stored procedure? If so, what is the syntax for doing so?

Stay Cool Ya'll!

-- Kristin

 

[gmmastros]

You can cause SQL Server to wait for a specified period time. Like this...

Waitfor Delay '0:00:30'

If you run this, it will take exactly 30 seconds to execute.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[memdiscount]

Hi;

I don't think so, it is not possible in stored procedure. However, timeout actually deals with connections, so if you are calling stored procedure then there is a connection timeout property of command object in VB.NET or C# , you can increase your connection timeout when you call that stored procedure useing command object.

Thanks

 

[RileyCat]

The "Waitfor Delay" call worked beautifully.

Thank you.

Stay Cool Ya'll!

-- Kristin

 

[TysonLPrice]

You might also look into:

SET QUERY_GOVERNOR_COST_LIMIT nn