Resources – Migration from SQL 2000/SQL2005 to SQL 2008

I will keep on adding the resources which I would find useful to help customer upgrading from SQL Server 2000/SQL Server 2005 to SQL Server 2008 White paper written by experts SQL Server 2008 Upgrade Technical Reference Guide SQLCAT Team Blog http://blogs.msdn.com/sqlcat/archive/2008/12/08/ultimate-guide-to-upgrading-to-sql-server-2008.aspx MSDN Link Resources for Upgrading to SQL Server 2008 SQL Server UE team…

3

How do I define a policy in SQL Server 2008 to evaluate if a Trace Flag is enabled ?

Someone posted this question in one of the internal forums and I found this interesting so thought of posting the solution. We are not allowed to add new facets in Policy Based Management and I could not find any facet which checks for trace flags. While researching I found Blogs from Dan Jones (PBM Program…

0