SET ROWCOUNT option is deprecated

SET ROWCOUNT option was replaced by the TOP(N) syntax of the SELECT statement.

SET ROWCOUNT sets the limit to the number of rows returned for the rest of the batch, whereas TOP(n) within the SELECT statement sets the number of rows to return from the query. The latter is much safer and easier to control.

Available in

 SQL Monitor

SQL Prompt

 SQL Code Guard