March 22, 2009 at 7:48 pm
Good Day to all
In our sql 2000 database we have a table called tbsystem wherein current date and time is stored. About 2 weeks ago users start to complain that even before finishing their transactions the date value on the tbsystem automatically changes. I am task to run the profiler (for 30 min to 1.5 hours) to check on whats causing the problem.
Here is the scenario..
4:00 pm I'll start the profiler
4:45 pm the user will call saying that the tbsystem automatically changes
but when viewing the generated data in the profiler (data saved in a table) there are no update statements in the said table. Just for checking I enabled all the options and parameters in setting the profiler but to no avail. What did i missed in running the profiler? any advice....
"-=Still Learning=-"
Lester Policarpio
March 24, 2009 at 10:01 am
I would check for triggers. You to have either sp:stmtstarting or sp:stmtcompleted in order to see that those have run, so it is quite possible you do not have either of those set. Give that a shot.
March 24, 2009 at 7:47 pm
Ok Noted Thanks 🙂
"-=Still Learning=-"
Lester Policarpio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply