| Assembly | SqlServer.Rules.dll |
| Namespace | SqlServer.Rules.Design |
| Class | AvoidSetRowcountRule |
| Id | SRD0036 |
| Friendly Name | Do not use SET ROWCOUNT |
| Category | Design |
| Ignorable | true |
| Applicable Types | Procedure |
| Scalar Function | |
| Table Valued Function |
Do not use SET ROWCOUNT to restrict the number of rows.
Do not use SET ROWCOUNT to restrict the number of rows. Use the TOP clause instead.