Set RowCount may not work in 2008...

From http://msdn.microsoft.com/en-us/library/ms188774.aspx

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in the next release of SQL Server. Avoid using SET ROWCOUNT...