"SET ROWCOUNT" is a global setting. Not to be used unless you want to limit every single query executed.

Use TOP:

UPDATE TOP (10000) ...