January 2011 - Technical Rollup Mail - SQL
News
SQL Server 2005 SP4 RTM Now Available for Download
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
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