The sp_showpendingchanges stored procedure was updated with a new parameter, This parameter helps identify the pending changes of subscribers. This release of the SQL Server 2005 Notification Services components provides support for running SQL Server 2005 Notification Services against either an instance of the SQL Server 2005 Database Engine or the SQL Server 2008 Database Engine. 
In earlier versions of SQL Server, only the first 200 error messages for each object are displayed if you do not specify ALL_ERRORMSGS. If you specify or omit the ALL_ERRORMSGS option, it has no effect.
By default, when you use the DBCC CHECKDB, DBCC CHECKALLOC, DBCC CHECKTABLE, or DBCC CHECKFILEGROUP commands on a server that is running SQL Server 2005 SP3, all error messages are displayed. Additionally, the following components have new or improved features. These include supportability enhancements and issues that have been reported through Windows Error Reporting. Microsoft SQL Server 2005 Service Pack 3 (SP3) contains all the cumulative updates for SQL Server 2005, and fixes to issues that have been reported through our customer feedback platforms. Voor meer informatie van alle veranderingen zal je de volgende lijst met aanpassingen moeten doornemen: What's new Dit derde service pack bevat alle voorgaande patches, security updates en updates die tot nu toe zijn uitgebracht voor SQL Server 2005 en kan zoals gewoonlijk binnengehaald worden voor de 32bit-, 圆4- en IA-64-edities van Windows 2000, Windows XP, Windows Vista, Windows Server 2003 en Windows Server 2008. 
Microsoft heeft een nieuw service pack voor zijn SQL server 2005 uitgebracht.
0 kommentar(er)
