Re: executing long stored proc throuh ado having multile update and delete and final select statemen

[Judah Reeves]

Better yet, insert a "set nocount on" for all sprocs. Most of the time you
are not even going to need to use the count of the rows affected. This,
by the way, also gives you a slight performance boost and reduced network
traffic.