| Posted by Erland Sommarskog on 06/19/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
  Navigation: [Reply to this message] |