• "BOL suggests that TOP should be used:"

    "It is recommended that DELETE, INSERT, and UPDATE statements currently using SET ROWCOUNT be rewritten to use the TOP syntax. For more information, see DELETE, INSERT, or UPDATE."

    SELECT is not there So, it is safe to use rowcount for read only operations.

     

     


    * Noel