"Rick" <R***@discussions.microsoft.com> wrote in message news:4BE0F4BA-51BC-41B8-B4DD-E8EAC4172267@microsoft.com...
> How can I eliminates comments about the numers of rows affected
> from a stored procedure? (see below)
>
>
> (3719 rows afffected)
>
> (5 rows afffected)
>
> (100 rows afffected)
>
> CustomerId    Customer
> ----------------------------
> 1                  John
> 2                  Fred
> 3                  Mary
> ...
> ...
> ...
> --
>
> Thank you.
> Rick

"Arnie Rowland" wrote:

> use the NOCOUNT option.
>
> Add the following line at the top of your stored procedures.
>
> SET NOCOUNT ON
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "Rick" <R***@discussions.microsoft.com> wrote in message news:4BE0F4BA-51BC-41B8-B4DD-E8EAC4172267@microsoft.com...
> > How can I eliminates comments about the numers of rows affected
> > from a stored procedure? (see below)
> >
> >
> > (3719 rows afffected)
> >
> > (5 rows afffected)
> >
> > (100 rows afffected)
> >
> > CustomerId    Customer
> > ----------------------------
> > 1                  John
> > 2                  Fred
> > 3                  Mary
> > ...
> > ...
> > ...
> > --
> >
> > Thank you