# SQL Server Rule: SRD0035
| | |
|----|----|
| Assembly | SqlServer.Rules |
| Namespace | SqlServer.Rules.Design |
| Class | WaitForRule |
## Rule Information
| | |
|----|----|
| Id | SRD0035 |
| Friendly Name | Forced delay |
| Category | Design |
| Ignorable | false |
| Applicable Types | Dml Trigger |
| | Procedure |
| | Scalar Function |
| | Table Valued Function |
## Description
Do not use WAITFOR DELAY/TIME statement in stored procedures, functions, and triggers.
## Summary
Do not use WAITFOR DELAY/TIME statement in stored procedures, functions, and triggers.
### Remarks
The rule checks for WAITFOR statement with DELAY or TIME being used inside:
<list type="bullet">
<item>stored procedure</item>
<item>function</item>
<item>trigger</item>
</list>
The WAITFOR statement blocks the execution until a specified time or time interval is reached.
This is not typically wanted in a OLTP system unless for a very specific reason.
<sub><sup>Generated by a tool</sup></sub>
