We are fast approaching the end of support for SQL Server 7.0. It has been in "extended support" for a while, meaning you could call for help but no non-security hotfixes would be created. But after January 11, 2011 extended support for SQL Server 7.0 ends and you will no longer be able to contact Microsoft for help with SQL Server 7.0. See more details here: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/09/29/end-of-support-for-sql-server-7-0.aspx
But everything is not ending! Indeed we have a new service pack for SQL Server 2008! SQL Server 2008 SP2 is now available for download! SP2 includes all hotfixes from SP1 CU1 to CU8. You can also get the updated feature pack.
• SQL Server 2008 SP2: http://go.microsoft.com/fwlink/?LinkId=196550
• SQL Server 2008 SP2 Express: http://go.microsoft.com/fwlink/?LinkId=196551
• SQL Server 2008 SP2 Feature Packs: : http://go.microsoft.com/fwlink/?LinkId=202815
Key improvements in Microsoft SQL Server 2008 Service Pack 2 are:
o Data-tier Application (DAC) Support. Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.