We are using a statement "set nocount on" in Stored Procedures to avoid the display texts "1 row updated" , "2 rows deleted" something like that. (Programmers say that they make use of this is to avoid unnecessary network traffic)
Will these messages "1 row updated" , "2 rows deleted" really come to client. If so then how can we get those messeges..Is there any method or property in ADO to fetch these messeages.

Balakumar V.

__________________
Balakumar Vijayan
Sr. S/W Engr.
Trivandrum

If you do not use "set nocount on" in a stored procedure, the "nn rows ..." message is returned to the provider as a resultset. The provider (i.e. ADO) then inspects and parses this resultset and returns the value in it via the "recordsaffected" parameter on the execute methods of the command and/or connection objects.

Doing this requires some overhead on both the client and the server, as well as some network traffic to transmit the resultset.

If you need the value in your client application, don't use set nocount, and provide a variable that the command or connection execute method can deposit the value into.

If you never care about the "recordsaffected" value, it is wise (IMO) to use 'set nocount on' to avoid the needless extra overhead.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com