If you look at messages for the last day or 2, someone else had the exact same question. There's a more complete discussion over there.
PF
>Thanks Perry. @@RowCount does work. But tell me
>1. how could I actually get this done through a stored procedure.
>2. I was doing some testing with my app and when I removed the network cable from my machine while stepping through the app I was unable to reconnect to the SQL Server database or any other databases using ODBC after putting back the cable. Why ? is there anyway to re-connect without re-starting the machine ?
>
>
>Chris
(On an infant's shirt): Already smarter than Bush