Microsoft has announce the availability of Service Pack 2 for SQL Server 2008. Both the Service Pack as the Feature Pack are available for download from the Microsoft Download Center. Service Pack 2 for SQL Server 2008 includes new features for compatibility with SQL Server 2008 R2, product enhancements based on requests from the SQL Server community as well as solutions hotfix provided in SQL Server 2008 SP1 Cumulative 1 to 8.
Key enhancements in Microsoft SQL Server 2008 Service Pack 2 are:
Key enhancements in Microsoft SQL Server 2008 Service Pack 2 are:
- Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for integration services between SSRS and SharePoint products. The SSRS of SQL Server 2008 SP2 can be integrated with SharePoint 2010 products. SQL Server 2008 SP2 also provides additional support for grant support in the integration of SQL Servers Report Server 2008 R2 SharePoint 2007 products. This now enables SharePoint 2007 to use with the Report Servers in SQL Server 2008 R2. For additional information on the new integration of SSRS and SharePoint click on the link below What's New (Reporting Services).
- Instance Management SQL Server 2008 with SP2 applied, a database instance of SQL Server 2008 can be included in the utility control SQL Server 2008 R2 as an instance managed by SQL Server. SQL Server 2008 SP2 allows organizations to extend the utility value of the control of SQL Server instances without upgrading those servers to SQL Server 2008 R2. For additional information click on the link below Overview of SQL Server Utility.
- Data-tier Application (DAC) Support. Instances Database SQL Server 2008 supports all operations DAC distributed SQL Server 2008 R2 after SP2 has been installed. You can distribute, update, search, extract and delete DAC's SP2 does not update the client tools to provide support for DAC's. You must use the SQL Client Tools Server 2008 R2 and SQL Server Management Studio, to perform DAC's. A CAD application is an entity that contains all the objects in a database and instantiated objects used by any application. DAC provides a single unit to approve, distribute and manage objects DAC. For additional information click on the link below Designing and Implementing Data-tier Applications.
- SQL Server 2008 SP2: http://go.microsoft.com/fwlink/?LinkId=196550
- SQL Server 2008 SP2 Express: http://go.microsoft.com/fwlink/?LinkId=196551
- SP2 SQL Server 2008 Feature Packs: http://go.microsoft.com/fwlink/?LinkId=202815
- SQL Server 2008 SP2: http://go.microsoft.com/fwlink/?LinkId=196550
- SQL Server 2008 SP2 Express: http://go.microsoft.com/fwlink/?LinkId=196551
- SP2 SQL Server 2008 Feature Packs: http://go.microsoft.com/fwlink/?LinkId=202815
- SQL Server 2008 SP1 CU's Released: http://support.microsoft.com/kb/970365
- KB of Microsoft SQL Server 2008 SP2: http://support.microsoft.com/kb/2285068
- Overview of SQL Server Utility
- Designing and Implementing Data-tier Applications
- What's New (Reporting Services)
1 comment:
Resourceful post.
Microsoft's new SQL server 2008 web edition has been specially made for small business that need to economize in cost.
Thanks.
Hanry
Post a Comment