March 10, 2009 at 12:12 pm
I have one table which contains application admin related settings. this table gets updated by the application on very frequent bases. i was wondering, is there a way, i just monitor the changes against this table from profiler? Is this possible? If yes, can someone please share how? if not, then what other alternatives do i have to monitor this table?
Many thanks in advance.
March 10, 2009 at 12:26 pm
You can monitor the table on the profiler. You can use the Table name as Text with Wild card. Or if it is SP, you can use the name of the SP.
Alternate method would be triggers (I dont recommend it) maybe someothers have other ideas as well
-Roy
March 10, 2009 at 12:39 pm
in Profiler select the "Audit Shema Object Access Event" and filter it to look for your database name and object name (this should match the name of the table)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 12:47 pm
Perrys option is far better than mine.... Use his please and discard mine..:D
-Roy
March 10, 2009 at 5:20 pm
Perry/Roy,
You guys are awesome. Thanks a million. now i am able to monitor the specific table.
Thanks again. owe both of you a lunch 🙂
March 11, 2009 at 2:17 am
hey, your welcome buddy 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply