rowcount not available? [NC]

Hi,

Me again, anybody have any clues? When I execute select @@ROWCOUNT I get
the correct count that is to say. Why would the rowcount not be available ?

a++ Cedric
__________________

Hi guys,

I have come across an interesting behaviour with SQL Server 2008, when you
use the instruction: "set rowcount nn" such as "set rowcount 10" then
DBCOUNT(dbproc) returns -1.

Anyone have any ideas???

Thanks,

Cedric


*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************