July 8, 2002 at 1:35 pm
Is there a way to capture all the Dynamic SQL through Profiler or any other tool?
July 8, 2002 at 1:39 pm
Profiler will work.
Not aware of anything else that is "select" based. Log Explorer will capture the INSERT, UPDATE, DELETE stuff.
Steve Jones
July 8, 2002 at 2:25 pm
Profiler will capture all dynamic sql?
July 8, 2002 at 5:06 pm
It will capture all statements run against the server.
Steve Jones
July 9, 2002 at 6:09 am
In fact you just have to set either SQLStmt:Begin or Complete to get the sql statements that are run. You can also setup traces with profiler output by using xp_trace... procedures in SQL 7 or sp_trace... and fn_trace... in SQL 2000. This way the gui (which takes up a lot of memory displaying on the machine and should be run from elsewhere) is not needed.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply