May 1, 2009 at 6:25 am
Hi,
I'm trying for the first time to create a trace using the sql profiler that monitors 1 table in 1 database. I need a trace file written if anyone accessess the table (its a security table) in anyway.
Could someone give me any pointers to the criteria i select in the trace template dialog in order to create this.
Or alternatively an example would be better.
Many Thanks
May 1, 2009 at 3:54 pm
Are you looking to script this for use on other servers?
Here's an article on setting things up: http://www.sqlservercentral.com/articles/Profiler/63097/
You probably want to grab the login name of the user, you'll filter on the table, and then look for all SQL that accesses this table.
May 4, 2009 at 8:53 am
In addition to reading the article provided by Steve you should also read the BOL section on server-side tracing. This sounds like something you want to have running all the time and you don't want to use the Profiler GUI in this situation.
You can also check out JumpstartTV and search for Profiler as there is a series of videos on Profiler available there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply