Posted by Erland Sommarskog on 10/01/76 11:25

GeoSynch (SpamSlayed@Casablanca.com) writes:
> Try removing
> SET NOCOUNT ON
> from the stored procedure.

@@rowcount should always return a value even if NOCOUNT is on. This
option controls whether rowcount information is passed to the client.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]