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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-05 : 10:21:50
|
| J Teb writes "I have just completed implementing a new site/DB solution. Because this system is new, there are some bugs I need to work. Every once in a while a record in one of my tables will change unexpectedly. I am unsure of the source of this update and need to find out what is causing it. To do this I need more information. I am going to add a trigger to let me know when the record becomes updated, but I also want to try to capture the source of the update call whether it be a asp page, stored proc etc. Is there any way I can do this through server or SQL variables or something of this sort. I am kind of out of my league on this stuff and could use some help. thanks" |
|
|
|
|
|
Tracking Updates in a Trigger