SQL Server Profiler

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Paula

You need to look up BOL and try it yourself. Then if you come up with issues come back to us.

"Keep Trying"

iceberg SSC Enthusiast Points: 100 More actions · Answer 2

1.) Open Profiler, create a new trace (the default trace template should be fine for what you are doing)

2.) Then filter for the database that you are going to query, used the db_id

3.) Start the trace

4.) Execute the command through your application

5.) Stop the trace and review the code

If it is a stored procedure you may have to do some more digging to see the actual SELECT/INSERT/UPDATE statement. Hope this helps a little

iceberg SSC Enthusiast Points: 100 More actions · Answer 3

You can also add a filter based on Application Name to limit the results futher

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

If you are more comfortable learning using videos you can check out the Mastering SQL Server Profiler Video Series[/url].

There is also a series of short videos on Profiler on JumstartTV.