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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-11-10 : 04:14:52
|
| I know I got this from this forum but I can't find iti have a trace saved -- how do i insert it into a table so that I can analyze it - I know there was a stored procedure someone wrote here but I can't find it. |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-10 : 04:23:02
|
| fn_tracegettable() |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 09:18:23
|
| You are after this one:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105302 |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-11-10 : 12:36:16
|
| thanks sodeep - that's exactly what i was looking for. i used it but it got overwritten and i lost the queries. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 14:05:44
|
| What got overridden? Did you use rmaio's approach? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-11-11 : 01:22:37
|
| no i just meant i had saved the sql but accidentally overwrote it with other quries - thanks - i found this helpful in analyzing what is tying down the server |
|
|
|
|
|
|
analyze a trace