>Thanks for the reply. Is it also considdered good practice to set if back off (SET NOCOUNT OFF) before exiting my SPs?

You can but I don't see a reason to do that.

>Just so I can understand it a little better. Lets say I have a SP with 3 UPDATE statements and SET NOCOUNT is OFF. Will the server "chat" with the client after each UPDATE statement?

Yes. In QA you will see them as "nn rows affected".