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 |
|
rohithmishra
Starting Member
1 Post |
 Posted - 2009-05-06 : 02:23:46
|
| Hi,Can anyone tell me how can we know if any updation is done in table such as insertion | Deletion | Modification of record in one or more table without peeping inside the table... say, finding the history records that are updated...To be more clear; say I have a button in an application, when clicked, some records are inserted or updated. It is tedious to peep into each table and find the record that is updated or inserted...Consider that I dont have admin rights...If any select query can help me out... any info, please share..Thanks a lot...Rohith Mishra |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-06 : 02:27:30
|
check the @@rowcount after the insert / update
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2009-05-06 : 05:04:38
|
| Trigger option helps you. Best optionOtherwise Sql profiler. But lacks in performanceIam a slow walker but i never walk back |
|
|
|
|
|
|
Getting information for any updation in table