Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rprakash
Starting Member
1 Post |
 Posted - 2008-08-08 : 06:06:49
|
| I need to know the numbers of updates, delete and insert per day in the database. I am using SQL Server 2000.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-08 : 08:17:45
|
| You need Triggers for that. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-08 : 23:53:00
|
| Trace them in profiler. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-09 : 02:55:01
|
| 1.Do you have an audit column like datecreated in your table?2.Do you have a audit/history table for your master table? |
|
|
|
|
|
|
Number of Updates, delete, insert into database