October 3, 2003 at 7:06 am
I'm a developer - good at writing SQL statements and some T-SQL, but not so good at admin stuff, so I need some help please, on a sticky problem for me.
My web site has a bookmarking feature, and those bookmarks are stored in a SQL DB. Peridocially, some rogue code is running, and changing some of the values on one specific column of the bookmark table. I just can't find it.
Is there some way that I can trace, or be notified, whenever a change is made to a specific column in a table? It might help me to track the code down?
Thanks!
-Todd
October 3, 2003 at 11:53 am
You have several options. The first one is to use SQL Profiler. Create a new trace, set appropriate filters (including ObjectName to the name of the table desired). The second possibility is to put a trigger on that table that would record the information you need somewhere else. Do not forget to get rid of that trigger as soon as your task is accomplished.
Hope it helps.
Michael
Edited by - mromm on 10/03/2003 11:54:20 AM
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply