gurjer48 (3/30/2013)
I want to monitor a table continuously to see whether its updating or not if its updated i want too know how many rows it update and i wan to store them in a tabletime updated, no of rows
Do you want to store the actual data for the rows that are updated or do you just want to store the number of rows that got updated and when? Either way, the use of a well written, set-based trigger will do the job quite nicely.
--Jeff Moden
Change is inevitable... Change for the better is not.