There are two tools available on Codeplex that you may consider to use/test: SQL Server 2008 Extended Events Manager http://extendedeventmanager.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23813 and SQL Server Partition Management http://sqlpartitionmgmt.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23683
Read More...
