Is this the case as well for SQL 2008?

Gail,

Thanks for pointing out that distinction. For tracking/gathering blocking information what method would you suggest? We seem to have minor blockages, more in the afternoon, that generally clear...

SSC,

Thanks for the suggestions. We've since moved the instance to another VM with Windows Server Enterprise, 8 GB of memory. The avg page live expectancy went from 30...

Good, thanks Lowell.

You don't have to detach the database to delete the log file, just shut down the sql server service. Then the log file is like any other file, as...

Rudy,

your message of Jan 15 stated "Just wanted to mention that this ability is available in SQL 2008 but does not work against older versions of SQL server".

I was unclear...

Rudy,

When you say 'this ability' what are you referring to? I ask because your description of the original script says it works in earlier versions of sql.

Glen

Hi Rudy,

I scanned the article, looks intriguing. I have about 80 instances, with more to add, that I have to monitor, and have had thoughts along the same lines....