April 2011 - Technical Rollup Mail - SQL Server - Technical RollUp - Site Home

Talk TechNet is all about discussing topics and trends in the world of IT Professionals. In this show we’ll have guest Edwin Sarmiento. Edwin is a Microsoft SQL MVP. Call in and join us for what promises to be a lively 60 minute session. Get some burning questions answered on SQL Server DBA tasks.

New KB's

SQL 2005

Microsoft SQL Server 2005 Enterprise Edition: FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005

http://support.microsoft.com/kb/2515286

Microsoft SQL Server 2005 Standard Edition: FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"

http://support.microsoft.com/kb/969142

SQL 2008

Microsoft SQL Server 2008 Analysis Services: Cumulative update package 3 for SQL Server 2008 Service Pack 2

http://support.microsoft.com/kb/2498535

Microsoft SQL Server 2008 Developer Edition: FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005 or SQL Server 2008

http://support.microsoft.com/kb/2498818

Microsoft SQL Server 2008 Developer Edition: FIX: "The integer value is out of range" error when you pass a bigint value as the last_sync_version argument of the CHANGETABLE function in SQL Server 2008

http://support.microsoft.com/kb/2519358

Microsoft SQL Server 2008 Developer Edition: FIX:A query that has a CONTAINS predicate in a WHERE clause takes a long time to compile in SQL Server 2008

http://support.microsoft.com/kb/2491510

Microsoft SQL Server 2008 Developer Edition: FIX: "Insufficient data for an Image" error when you open a .pdf file that is exported from a SQL Server 2008 Reporting Services environment

http://support.microsoft.com/kb/2506795

Microsoft SQL Server 2008 Developer Edition: FIX: The dbo schema is preappended when you use a custom stored procedure in the sp_addarticle stored procedure

http://support.microsoft.com/kb/2509659

Microsoft SQL Server 2008 Developer Edition: FIX: "The merge process could not access row data" error occurs when the Merge Agent stops, and rows are set to 4 in the genstatus column in the msmerge_genhistory system table

http://support.microsoft.com/kb/2478514

Microsoft SQL Server 2008 Integration Services: You can now use Package Installation Wizard (Dtsinstall.exe) to run the deployment manifest file of an SSIS package when SSIS 2008 is not installed

http://support.microsoft.com/kb/2510668

Microsoft SQL Server 2008 Reporting Services: FIX: Incorrect newsletter-style report when a text box value extends from one column to another in SSRS 2008 if you use hard-page-break renderer format

http://support.microsoft.com/kb/2497585

Microsoft SQL Server 2008 Service Pack 1: FIX: A common table expression-based query that uses the CHANGETABLE function runs very slowly in SQL Server 2008 Service Pack 1

http://support.microsoft.com/kb/2476322

Microsoft SQL Server 2008 Standard Edition: FIX: Error message when you try to bulk insert data into a table that contains a DATE type column that uses a US date format in SQL Server 2008: "Bulk load data conversion error"

http://support.microsoft.com/kb/968215

Microsoft SQL Server 2008 Standard Edition: FIX: You receive error messages when you perform a population for a large full-text index in SQL Server 2008

http://support.microsoft.com/kb/963659