SQL Server 2005 Service Pack 2 (SP2) CTP has been released. You can provide feedback on the CTP release via http://connect.microsoft.com/sqlserver. The link for the various downloads is:


SQL Server 2005 SP2 CTP contains some new features in the database engine (vardecimal data types, object_name function enhancement, logon triggers, Common Criteria Compliance, sys.dm_exec_text_query_plan DMV, plan cache improvements among others). The list of bugs fixed in the release can be found at:


Please let me know if you have questions regarding the new features. For any issues with setup or bugs in the CTP release please use the connect feedback mechanism or post in the SQL Server MSDN forums.


Read full article…