How to cause a timeout

Question

We are investigating a timeout issue and would like to replicate it as part of initial testing.

I am new to Devart, Borland C++ Builder 6 and SQL Server and unsure of the syntax required. I am looking for example code to execute a query or series of queries to generate an indefinite delay which will time out.

Did you ge solution ? not answer marked ? – Kiquenet Feb 05 '21 at 08:01 — Kiquenet, Feb 05 '21 at 08:01

score 2 · Accepted Answer · answered May 02 '12 at 08:00

2

Assuming you want a database command timeout, you can execute the SQL command:

WAITFOR DELAY 'hh:mm:ss'

setting hh:mm:ss to some time period longer than your application's command timeout

answered May 02 '12 at 08:00

Ed Harper

21,127
4
54
80

How to cause a timeout

1 Answers1