March 30, 2013 at 5:33 am
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 table
time updated, no of rows
March 30, 2013 at 12:47 pm
Sounds like you need a history table.
Check this out
http://database-programmer.blogspot.com/2008/07/history-tables.html
March 30, 2013 at 1:25 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy