How to use SQL 2000 Profiler to create a trace for MSDE?

I have access to a SQL Server 2000 install, and need to write a trace
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
MarcoYou should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.