Share via


January 2011 - Technical Rollup Mail - SQL

News

SQL Server 2005 SP4 RTM Now Available for Download

https://blogs.technet.com/b/dataplatforminsider/archive/2010/12/20/sql-server-2005-sp4-rtm-now-available-for-download.aspx

The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download, and includes SQL Server 2005 SP3 cumulative updates 1 to 11, customer requested fixes and the SQL Server 2005 SP4 database engine support for DAC operations.

All about the SQL Server JumpIn! camp

https://blogs.technet.com/b/dataplatforminsider/archive/2010/12/02/all-about-the-sql-server-jumpin-camp.aspx

The SQL Server JumpIn! Camp, was scheduled from Nov 16th thru 19th at an excellent facility not too far from Microsoft's main campus with the purpose of bringing key PHP developers and SQL Server engineers together with the goal of supporting SQL Server and SQL Azure, with the last day reserved for Windows Azure and IIS. We extended our invitations to several projects/communities and were very happy and honored that most of them accepted.

https://blogs.technet.com/trm/default.aspx

Downloads

SQL 2005

SQL Server Management Studio Express SP4

Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

https://www.microsoft.com/downloads/en/details.aspx?familyid=76ea83da-4797-4f11-a834-456ee9dc3764

SQL Server Reporting Services Add-in for SharePoint Technologies

he Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

https://www.microsoft.com/downloads/en/details.aspx?familyid=773dffa6-6cd7-4894-b920-2726869f8700

Feature Pack for SQL Server 2005 SP4

Download the Feature Pack for Microsoft SQL Server 2005 SP4, a collection of standalone install packages that provide additional value for SQL Server 2005.

https://www.microsoft.com/downloads/en/details.aspx?familyid=7768393b-71fa-4281-83eb-cab08be4fb76

SQL Server 2005 SP4 Data Mining Add-ins

Download SQL Server 2005 Data Mining Add-ins for Office 2007. This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).

https://www.microsoft.com/downloads/en/details.aspx?familyid=527f476e-2630-4529-881a-f4b7cdd70edd

SQL Server 2005 Express Edition SP4

Microsoft SQL Server 2005 Express Edition is a free, easy-to-use, lightweight version of SQL Server 2005. It is fast and easy to learn, allowing you to quickly develop and deploy dynamic data-driven applications.

https://www.microsoft.com/downloads/en/details.aspx?familyid=26435597-b28e-4568-9d16-017bdf47abdc

New KB's

Other

Microsoft SQL Server 7.0 Standard Edition: Description of SQL Server blocking caused by compile locks

https://support.microsoft.com/kb/263889/en-US

SQL 2000

Microsoft SQL Server 2000 Standard Edition: The NET SEND command may not work correctly on a computer that is running Windows XP Service Pack 2

https://support.microsoft.com/kb/839018/en-US

SQL 2005

Microsoft SQL Server 2005 Developer Edition: Rebuilding an index can result in fragmented index when ALLOW_PAGE_LOCKS option is not enabled

https://support.microsoft.com/kb/2292737/en-US

Microsoft SQL Server 2005 Developer Edition: PRB:You are not able to change the default location for Full-Text Catalogs

https://support.microsoft.com/kb/2450864/en-US

Microsoft SQL Server 2005 Standard Edition: You may get an error message when trying to load or save a SSIS package

https://support.microsoft.com/kb/2416767/en-US

Microsoft SQL Server 2005 Standard Edition: SQL Server support for mounted volumes

https://support.microsoft.com/kb/819546/en-US

Microsoft SQL Server 2005 Standard Edition: FIX: A full backup with snapshot may cause SQL Server 2005 or SQL Server 2008 to stop responding

https://support.microsoft.com/kb/975860/en-US

SQL 2008

Microsoft SQL Server 2008 Reporting Services: FIX: Wrong email subscription is deleted when you use the SharePoint Integrated mode in SSRS 2008 if you sort the email subscriptions

https://support.microsoft.com/kb/2454175/en-US

Microsoft SQL Server 2008 Workgroup: FIX: You receive an incorrect result when you run a query that uses the row_number function in SQL Server 2008

https://support.microsoft.com/kb/970198/en-US

SQL 2008 R2

Microsoft SQL Server 2008 R2 Datacenter: How to create a trace log that helps troubleshoot MDS database creation issues

https://support.microsoft.com/kb/2423467/en-US

Microsoft SQL Server 2008 R2 Datacenter: [SDP 3][5da7d6cb-35c7-4eec-b453-04cceaa24307] SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2

https://support.microsoft.com/kb/2483962/en-US