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.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Trace?

Author  Topic 

sbt1
Yak Posting Veteran

89 Posts

Posted - 2005-05-12 : 09:20:45
Is there any way to get a trace from MSDE, like you can with SQL Server?

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-05-19 : 21:27:37
I don't really ever read the MSDE section of the forum, so it took me a while to find this one.

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx
http://www.novicksoftware.com/Articles/scripting-traces-for-performance-monitoring-on-sql-server-page1.htm

Those should help you get started. You will need to find what each of the trace ids and filter parameters are though. Have fun. Investing in the Developer's Edition of SQL Server ($49.00) to help you with this would alone pay for it.


MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -