Another thing one must take into account is the influence of SET / SELECT on the servers variables. SET does not affect the @@ROWCOUNT while SELECT (without the NOCOUNT...