November - Technical Rollup Mail - SQL
News
Follow up to the SQL Server Fireside Chats after the 24
Hours of PASS Sessions
A closer look at the HADR capabilities of the HP
Enterprise Database Consolidation Appliance
Dell Parallel Data Warehouse Appliance Announced @PASS
Summit!
Microsoft SQL Server 2008 SP3 Now Available
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