Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pclapis
Starting Member
1 Post |
 Posted - 2003-08-05 : 19:47:20
|
| I want to click through a Windows application and capture a log of SQL activity syncronized with my actions. I know how to use the SQL trace utility (I'm using Microsoft SQL Server 2000) but I recall seeing one or two commercial tools that made it easier to correlate the trace log to my mouse clicks. Can anyone point me in the right direction? TIA. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-05 : 19:54:47
|
| Well SQL Trace is the tool for SQL Server 6.5. The tool for SQL Server 7.0 and 2000 is called SQL Profiler. This tool can be filtered so that it only traces a specific spid so that you don't see any data from other users.Tara |
 |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2003-08-05 : 19:59:23
|
| if you want to do it for itself (I cannot understand the reason), take a look on BOL about sp_trace* stored procedures. It will be helpeful in this case, just because these are the proces used by SQL Profiler and commercial tools.regards,Sérgio MonteiroTrust in no Oracle |
|
|
|
|
|
|
SQL Trace tools?