SET ROWCOUNT will not be supported in future version of SQL Server

Things are changing very rapidly in SQL Server future versions. Some of the features which were once treated as standard solutions to some typical scenarios of TSQL are now scheduled to be deprecated in future versions of SQL Server. One of these feature was the SET ROWCOUNT statement. This statement is also scheduled for being deprecated in future versions of SQL Server. The only way to limit your results will be by using the TOP keyword.

Similarly some other SET options will no longer be supported like

SET ANSI_NULLS
SET ANSI_PADDING
SET CONCAT_NULL_YIELDS_NULL

I will suggest you to study the complete list of deprecated database features here
and make sure you are not relying too much on these features, if you want to make sure that your database is compatible with future versions of SQL Server.