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 |
|
chulheekim
Starting Member
46 Posts |
 Posted - 2009-09-18 : 18:16:44
|
| one specific table field keep changing back to 'C' from 'P'. I have to find out what sproc update the table field.Is there a way to find out which program did that using Trigger? |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2009-09-25 : 15:03:14
|
| Don't think Trigger can catch the program name.Make a trace file catch the app/program name.You can also create a trigger whenever the field changed.Catch the changing time from the trigger. Based on the time find the program name from the trace. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-25 : 15:19:01
|
| i too think you need to use profiler trace. |
|
|
|
|
|
|
Can Trigger do this?