Other SQL Server Blogs around the Web

SQL Server: Creating BlackBox kind of trace with TSQL

Here is the kind of scripts defined within TEchnet articles about running black-box kind of traces against your SQL Server instance, then also you can take advantage of the blackbox trace if you are facing intermittent problems, you want to make sure that it is always running when your server is running—including after either a planned or unplanned restart. To accomplish this, you can set the blackbox trace to start automatically when SQL Server starts. First, wrap the trace definition in a stored...(read more)

Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2008/05/28/4340.aspx

This Blog

Syndication



© 2000 - 2007 vDerivatives Limited All Rights Reserved.