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 |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2004-01-28 : 11:12:25
|
| I'm looking for some people that are using scripted traces to generate .trc files. I've written a little utility to automatically import those files into SQL Server and then archive the files. It supports multiple traces from multiple SQL Servers that can each go into different tables on different servers. If you're interested in testing it, send me an email and we'll get you going.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2004-01-28 : 16:35:17
|
| I use scripts for server side tracing the production system. fn_trace_gettable() is my friend for loading the .trc files into SQL Server tables.What features does your utility offer?--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-01-28 : 16:51:03
|
| It monitors multiple source directories for files matching specific naming filters and then automatically imports those into SQL Server tables. As soon as the trace utility rolls to a new file, it pulls the old file and imports it. It does use fn_trace_gettable() under the hood.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2004-01-28 : 16:58:03
|
| I'll be interested in using/testing it, as long as it is a script (T-SQL/VBS etc.). Don't like installing applications :-)--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
Anyone using scripted traces?