November - Technical Rollup Mail - SQL

News

 

Follow up to the SQL Server Fireside Chats after the 24
Hours of PASS Sessions

https://blogs.technet.com/b/dataplatforminsider/archive/2011/10/27/follow-up-to-the-sql-server-fireside-chats-after-the-24-hours-of-pass-sessions.aspx

 

A closer look at the HADR capabilities of the HP
Enterprise Database Consolidation Appliance

https://blogs.technet.com/b/dataplatforminsider/archive/2011/10/25/a-closer-look-at-the-hadr-capabilities-of-the-hp-enterprise-database-consolidation-appliance.aspx

 

Dell Parallel Data Warehouse Appliance Announced @PASS
Summit!

https://blogs.technet.com/b/dataplatforminsider/archive/2011/10/21/dell-parallel-data-warehouse-appliance-release.aspx

 

Microsoft SQL Server 2008 SP3 Now Available

https://blogs.technet.com/b/dataplatforminsider/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx

Other

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

 

 

Events

 

SQL PASS Summit 2011

https://www.sqlpass.org/summit/2011/Registration.aspx

 

 

Documents

SQL Server 2012 Product Guide V2

https://go.microsoft.com/fwlink/?LinkID=2258142

 

 

New KB Articles

 

SQL 7.0

 

Microsoft SQL Server 7.0
Standard Edition

PRB: ARCserveIT Open File Manager
(Ofant.sys) May Affect SQL Server 7.0 Disk IO Performance

https://premier.microsoft.com/kb/275555

 

SQL 2000

 

Microsoft SQL Server 2000
Developer Edition

FIX: Error messages when you try
to update table rows or insert table rows into a table in SQL Server 2000:
"644" or "2511"

https://support.microsoft.com/kb/929440

 

Microsoft SQL Server 2000
Developer Edition

FIX: A memory leak may occur when
a client application uses the Dbmslpcn.dll shared memory network library
version 2000.80.828.0 and connects to a local computer that is running SQL
Server 2000

https://support.microsoft.com/kb/900961

 

Microsoft SQL Server 2000
Enterprise Edition

BUG: IsAlive check does not run
under the context of the BUILTIN\Administrators account in SQL Server 2000
Enterprise Edition

https://support.microsoft.com/kb/291255

 

Microsoft SQL Server 2000
Personal Edition

FIX: You may receive an access
violation error message when you run a linked server query that includes a
subquery

https://support.microsoft.com/kb/911569

 

Microsoft SQL Server 2000
Standard Edition

Query performance may decrease
when you try to run a query in a parallel plan in SQL Server 2000

https://support.microsoft.com/kb/919638

 

Microsoft SQL Server 2000
Standard Edition

FIX: The synchronization process
may take a long time when you synchronize merge replication publications in SQL
Server 2000

https://support.microsoft.com/kb/914439

 

Microsoft SQL Server 2000
Standard Edition

Considerations for the
"autogrow" and "autoshrink" settings in SQL Server

https://support.microsoft.com/kb/315512

 

Microsoft SQL Server 2000
Standard Edition

Application errors occur after you
run Xmlinst.exe on production servers

https://support.microsoft.com/kb/278636

 

Microsoft SQL Server 2000
Standard Edition

How to enable SSL encryption for
SQL Server 2000 if you have a valid Certificate Server

https://support.microsoft.com/kb/276553

 

Microsoft SQL Server 2000
Standard Edition

How to use Kerberos authentication
in SQL Server

https://support.microsoft.com/kb/319723

 

Microsoft SQL Server 2000
Windows CE Edition

How to upgrade an Internet
Information Services server after applying SQL Server 2000 Service Pack 3 or
SQL Server 2000 Service Pack SP3a

https://support.microsoft.com/kb/330014

 

 

SQL 2005

 

Microsoft SQL Server 2005
Analysis Services

FIX: The sum total of a column
contains incorrect data when you browse or query a cube in SQL Server 2005
Analysis Services

https://support.microsoft.com/kb/926775

 

Microsoft SQL Server 2005
Analysis Services

FIX: You may receive unexpected
results when you run an MDX query in SQL Server 2005 Analysis Services

https://support.microsoft.com/kb/926515

 

Microsoft SQL Server 2005
Analysis Services

FIX: In SQL Server 2005 Analysis
Services, the query may not return all the expected rows when you use the
TopCount function in an MDX query

https://support.microsoft.com/kb/926235

 

Microsoft SQL Server 2005
Analysis Services

FIX: Error message when you run a
query against a cube that contains linked objects in SQL Server 2005 Analysis
Services: "Internal error An unexpected error occurred"

https://support.microsoft.com/kb/925566

 

Microsoft SQL Server 2005
Analysis Services

An update is available for SQL
Server 2005 Analysis Services that adds partition information to the existing
schema that is returned by the DISCOVER_PARTITION_INFO rowset

https://support.microsoft.com/kb/924939

 

Microsoft SQL Server 2005
Analysis Services

FIX: Unfiltered results may be
generated when you use a drillthrough action on a dimension that is stored in
the ROLAP storage mode in SQL Server 2005 Analysis Services

https://support.microsoft.com/kb/923477

 

Microsoft SQL Server 2005
Analysis Services

FIX: An MDX query may never finish
when you run the MDX query against a parent/child dimension in SQL Server 2005
Analysis Services

https://support.microsoft.com/kb/923476

 

Microsoft SQL Server 2005
Analysis Services

FIX: A member property is returned
in an unexpected data type when you call the
"IMDDataset::GetAxisRowset" interface in SQL Server 2005 Analysis
Services

https://support.microsoft.com/kb/922798

 

Microsoft SQL Server 2005
Analysis Services

FIX: A query may return incorrect
results when you run the query against a SQL Server 2005 Analysis Services cube

https://support.microsoft.com/kb/920340

 

Microsoft SQL Server 2005
Analysis Services

FIX: You may receive incorrect
results when you run a Multidimensional Expressions (MDX) query that involves a
calculated member and the autoexist functionality in SQL Server 2005 Analysis
Services

https://support.microsoft.com/kb/919955

 

Microsoft SQL Server 2005
Analysis Services

FIX: SQL Server Analysis Services
2005 system performance may be slow after you use the ADOMD.NET data provider
to run an MDX query that returns a large result set from a cube

https://support.microsoft.com/kb/919731

 

Microsoft SQL Server 2005
Analysis Services

FIX: You may receive unexpected
results when you query data from a set that uses the MDX Crossjoin function in
SQL Server 2005 Analysis Services

https://support.microsoft.com/kb/915796

 

Microsoft SQL Server 2005
Analysis Services

FIX: An MDX query that uses the
unique name property returns incorrect results when you use a client tool to
run the query in SQL Server 2005 Analysis Services

https://support.microsoft.com/kb/914597

 

Microsoft SQL Server 2005
Analysis Services

FIX: You cannot connect to SQL
Server 2000 Analysis Services when you configure the Office Web Components data
source connection string to use OLE DB Provider for Analysis Services 9.0 to
connect to SQL Server 2005 Analysis Services

https://support.microsoft.com/kb/912631

 

Microsoft SQL Server 2005
Developer Edition

Error message when you try to
install SQL Server 2005 on a volume mount point: "There is not enough
space on the destination disk for the current SQL Server installation"

https://support.microsoft.com/kb/934012

 

Microsoft SQL Server 2005
Developer Edition

You cannot connect to a local
instance of SQL Server on a Windows XP-based computer or on a Windows
2000-based computer when you use "localhost" in the pipe name

https://support.microsoft.com/kb/929152

 

Microsoft SQL Server 2005
Developer Edition

How do I open the firewall port
for SQL Server on Windows Server 2008?

https://support.microsoft.com/kb/968872

 

Microsoft SQL Server 2005
Enterprise Edition

FIX: You receive error 1456 when
you try to add a witness to a DBM session in SQL Server 2005

https://support.microsoft.com/kb/930284

 

Microsoft SQL Server 2005
Express Edition

Error message when you try to
uninstall a SQL Server 2005 Express Edition hotfix package: "1731 The
source installation package for the product [2] is out of sync with the client
package"

https://support.microsoft.com/kb/955250

 

Microsoft SQL Server 2005
Reporting Services

FIX: Error message when you open a
report in Report Manager in SQL Server 2005 Reporting Services: "An error
has occurred during report processing. There is already an open DataReader
associated with this Command which must be closed first"

https://support.microsoft.com/kb/927290

 

Microsoft SQL Server 2005
Reporting Services

FIX: Error message when you use
Report Builder after you install SQL Server 2005 Reporting Services SP1:
"Short time pattern does not include hours and minutes"

https://support.microsoft.com/kb/923623

 

Microsoft SQL Server 2005
Reporting Services

FIX: Error message when you use
Report Builder after you install SQL Server 2005 Reporting Services SP1:
"Short time pattern does not include hours and minutes"

https://support.microsoft.com/kb/923623

 

Microsoft SQL Server 2005
Standard Edition

The remote instance of SQL Server
2000 does not stop when you use SQL Server Management Studio on the server that
is running SQL Server 2005

https://support.microsoft.com/kb/930878

 

Microsoft SQL Server 2005
Standard Edition

FIX: A script task or a script
component is executed multiple times in duplicate when you run packages that
contain script tasks or script components in parallel in SSIS

https://support.microsoft.com/kb/928323

 

Microsoft SQL Server 2005
Standard Edition

FIX: You may receive an error
message when you run a CLR stored procedure or CLR function that uses a context
connection in SQL Server 2005

https://support.microsoft.com/kb/928083

 

Microsoft SQL Server 2005
Standard Edition

FIX: You may experience very large
growth increments of a principal database after you manually fail over a
database mirroring session in SQL Server 2005

https://support.microsoft.com/kb/925277

 

Microsoft SQL Server 2005
Standard Edition

BUG: You may receive an access
violation error message when you try to run an SSIS package in SQL Server 2005

https://support.microsoft.com/kb/924016

 

Microsoft SQL Server 2005
Standard Edition

FIX: SQL Server 2005 may
overestimate the cardinality of the JOIN operator when a SQL Server 2005 query
contains a join predicate that is a multicolumn predicate

https://support.microsoft.com/kb/920346

 

Microsoft SQL Server 2005
Standard Edition

FIX: System performance may be
slow when an application submits many queries against a SQL Server 2005
database that uses simple parameterization

https://support.microsoft.com/kb/920206

 

Microsoft SQL Server 2005
Standard Edition

FIX: A query plan is not cached in
SQL Server 2005 when the text of the hint is a large object

https://support.microsoft.com/kb/918882

 

Microsoft SQL Server 2005
Standard Edition

FIX: You cannot restore the log
backups on the mirror server after you remove database mirroring for the mirror
database in SQL Server 2005

https://support.microsoft.com/kb/915793

 

Microsoft SQL Server 2005
Standard Edition

On a computer that has a multicore
processor, you may be unable to install SQL Server 2005

https://support.microsoft.com/kb/954835

 

Microsoft SQL Server 2005
Standard Edition

Error message when you execute a
CLR routine or use an assembly in SQL Server 2005: "Assembly in host store
has a different signature than assembly in GAC. (Exception from HRESULT:
0x80131050)"

https://support.microsoft.com/kb/949080

 

Microsoft SQL Server 2005
Standard Edition

FIX: The synchronization operation
of a merge replication times out in Microsoft SQL Server 2005

https://support.microsoft.com/kb/953568

 

 

SQL 2008

 

Microsoft SQL Server 2008
Developer Edition

The Full Text Search component
installation fails when you try to install the SQL Server 2008 database engine
from an installation DVD on a computer that has SQL Server 2008 Express edition
installed

https://support.microsoft.com/kb/967103

 

 

Microsoft SQL Server 2008
Developer

FIX: "Unexpected error from
SE OLEDB interface" error when you run a full-text search query in SQL
Server 2008

https://support.microsoft.com/kb/2606301

 

 

Microsoft SQL Server 2008
Developer

FIX: XML data loss when a merge
replication encounters a foreign key violation error in SQL Server 2005, in SQL
Server 2008, or in SQL Server 2008 R2

https://support.microsoft.com/kb/2591902

Microsoft SQL Server 2008
Developer

FIX: "Server: Msg 7359"
error when you run a distributed query in SQL Server 2008 or in SQL Server 2008
R2 if a schema version is updated more than five times

https://support.microsoft.com/kb/2588970

 

 

Microsoft SQL Server 2008 Developer

SQL Server Replication Agents may
exhibit blocking when applying snapshot

https://support.microsoft.com/kb/2615479

 

 

Microsoft SQL Server 2008
Enterprise Edition

FIX: SSIS Checkpoint restores an incorrect
variable value for an Execute SQL Task item of a For Loop Container item in
SSIS 2008 if an SSIS package executes again after it fails or stops

https://support.microsoft.com/kb/2583994

 

 

Microsoft SQL Server 2008
Enterprise Edition

FIX: Size of a data file that is
committed by online page compression is larger than that is committed by
offline page compression in SQL Server 2008 or in SQL Server 2008 R2

https://support.microsoft.com/kb/2574973

 

 

Microsoft SQL Server 2008
Enterprise Edition

FIX: Assertion failure or other
issues occur when you run a DML query against a table or a view that has two
indexes in SQL Server 2008

https://support.microsoft.com/kb/2542225

 

 

Microsoft SQL Server 2008
Integration Services

FIX: Incorrect results when you
commit the Unpivot transformation to a SSIS package in SSIS 2008 or in SSIS 2008
R2

https://support.microsoft.com/kb/2580224

 

 

Microsoft SQL Server 2008 R2
Analysis Services

FIX: Internal error when you run a
MDX query that uses the Descendants function after you upgrade from SSAS 2005
to SSAS 2008 or to SSAS 2008 R2

https://support.microsoft.com/kb/2605756

 

 

Microsoft SQL Server 2008 R2
Analysis Services

FIX: SSAS 2008 or SSAS 2008 R2
crashes when you perform synchronization in TFS 2010 after you rebuild a cube

https://support.microsoft.com/kb/2591295

 

 

Microsoft SQL Server 2008 R2
Analysis Services

Analysis Services SharePoint
integration Dll is not updated with SP1 for SQL Server 2008 R2

https://support.microsoft.com/kb/2619924

 

 

Microsoft SQL Server 2008
Reporting Services

FIX: Me.Value is evaluated
incorrectly when it is used to access the Value property of a text box in a
SSRS 2008 report if the report has a page header or a page footer

https://support.microsoft.com/kb/2608108

 

 

Microsoft SQL Server 2008
Service Pack 1

Cumulative update package 16 for
SQL Server 2008 Service Pack 1

https://support.microsoft.com/kb/2582282