Write custom trace files in TSQL

 

SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace files in TSQL to catch events on your database machine.

Check out these additional developer resources

• How do I... Set up replication between Microsoft SQL Server 2000 and MySQL (blog)
• Is there an online portal where I can practice SQL? (question)
• How can we save Word documents for 2,000+ customers into SQL Server? (question)
• How do you export SQL 2000 databases into Access and Dbase by using Visual Basic .NET and C# programs? (question)
• How copyright and licensing issues affect programming work (blog)

Solutions to today's problems today
TechRepublic Pro is an exclusive subscription service that offers unique downloadable solutions designed to help solve the tough IT management problems you face every day. Quick Reference: Cisco Administration Pak is an example of the hundreds of time-saving solutions and tools you can download as a TechRepublic Pro member.

Join TechRepublic Pro to get the downloads you need to get the job done.

TechRepublic Today

Maxthon 2.0 Web browser: The Right Tool for the Job? A few years ago I stumbled upon a plug-in for Internet explorer called MyIE2 that added Firefox-like functionality such as such as tabs, ad blocking and autofill. Maxthon 2.0, from the same developers, seems intended to replace the older product and hopefully add maturity that the plug-in lacked. Is it the Right Tool for the Job? Get more from TechRepublic Sanity check: Is IT still a profession worth recommending to the next generation? Geekend: Looking back at Microsoft PowerPoint Easter Eggs How do I. . . Set up replication between Microsoft SQL Server 2000 and MySQL? 10 things you can do to make sure your data doesn't walk out the door