Using SQL Profiler to trace all SQL

[CylonLove4Life]

How do I use the SQL Profiler to see a trace of all SQL against the db?

I'm able to run the SQL Profiler, but I can't figure out how to use it to a log of all the SQL statements ran.

 

[mrdenny]

If you do with the default options then you should get all the commands that the users are running.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com