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 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-11-23 : 10:24:26
|
| I was wondering how I would go about capturing the query for a report that is run against the database. I was told I can use Viewing and Analyzing Traces to do this, but I'm not sure how to go about doing that.Anyone that has done this can explain in detail or steps how to get this?Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-23 : 10:41:38
|
| Easiest is to use the profiler.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-11-23 : 11:26:56
|
| Thanks that works. |
|
|
|
|
|
|
Capture query? -- Analyzing traces