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