SQL Profiler 1

[AlbertKim247]

I'm currently in the process of using SQL Profiler to see how an application interacts with it's SQL Server 2000 database. Does anyone have any knowledge they can share in creating a trace file with specific Events, Data Columns, and Filters to trace only the SELECT, INSERT, and UPDATE statements that the application uses to interact with it's DB?

 

[mrdenny]

Use the SP:StmtStarting and/or SP:StmtCompleted to get the data you are looking for. You may also want to filter by the TextData column where the value contains SELECT, INSERT,or UPDATE.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com