[dba-SQLServer]Number of rows affected by update, insert etc

Create an "after insert, update, delete trigger" on the table you want to 
monitor that will count the number of records in the "inserted" or "deleted" 
table and insert that number into a new log table.

Look up "CREATE TRIGGER" in BOL for more info.

HTH
Billy

>From: <paul.hartland at fsmail.net>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: accessd at databaseadvisors.com
>CC: dba-vb at databaseadvisors.com, dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer]Number of rows affected by update, insert etc
>Date: Wed, 23 Jul 2003 15:57:22 +0000
>
>To all,
>
>I have a VB6 application which uses the dataenvironment to link to a 
>Access2002 database, and I use command objects connnected to the 
>dataenvironment which update, delete & insert records.....
>
>Is there anyway I can get the count of how many rows have been affected
>
>Thanks in advance for you help
>
>Paul Hartland
>
>__________________________________________________________________________
>Join Freeserve http://www.freeserve.com/time/
>
>Winner of the 2003 Internet Service Providers' Association awards for Best 
>Unmetered ISP and Best Consumer Application.
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus