Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

SQL Server Knowledge Base articles (SSQA.net)

Microsoft support engineers regularly document the solutions to problems that customers call in with, they are Knowledge Base articles or we call them as KBA.
SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated

There hasn't been much changes to the KBAs and here is complete list of items/pages that were were recently modified:

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Enterprise Edition

FIX: You receive an incorrect result when you run a full-text query against a table that uses the Chinese word breaker in SQL Server 2008
http://support.microsoft.com/kb/967315/en-US

FIX: Error message when you capture a SQL Server trace file in SQL Server 2008: "Non-yielding Scheduler"
http://support.microsoft.com/kb/973302/en-US

FIX: The removal of a transaction log file of the database on the principal server breaks a database mirroring session in SQL Server 2008
http://support.microsoft.com/kb/972681/en-US

FIX: Error message when you press F1 to open the Device Contents help during a restore operation in SQL Server 2008: "Object reference not set to an instance of an object. (DqlManagerUI)"
http://support.microsoft.com/kb/972203/en-US

FIX: An INSERT INTO <table name> EXEC <stored procedure name> statement generates error messages even if you set the ANSI_WARNINGS option to "OFF" in SQL Server 2008
http://support.microsoft.com/kb/971057/en-US

FIX: When you query the DataSpaceUsed property or the IndexSpaceUsed property of a database that contains many tables in SQL Server 2008, the query takes a long time to finish
http://support.microsoft.com/kb/972197/en-US

FIX: Error message when you synchronize a database or manually run sp_replcmds after you perform partial updates on a varbinary(max) column in SQL Server 2008: "The rowset does not contain any column with offset -1."
http://support.microsoft.com/kb/971136/en-US

FIX: Error message when you try to add a filter for an included column index in SQL Server 2008: "Add object to collection failed for IndexedColumnCollection of Index '<IndexName>'"
http://support.microsoft.com/kb/972198/en-US

FIX: Error message when you run a MERGE statement on a table that has a unique clustered index and a nonclustered index in SQL Server 2008: "Cannot insert duplicate key row in object '<TableName>' with unique index '<IndexName>'"
http://support.microsoft.com/kb/972261/en-US

FIX: You receive an incorrect result when you run a full-text query that combines the NEAR operator together with the AND operator in SQL Server 2008
http://support.microsoft.com/kb/970909/en-US

FIX: Error message when you install SQL Server 2008 or SQL Server 2008 Service Pack 1 on a Windows XP-based computer that has SQL Server 2000 installed: "Object reference not set to an instance of an object."
http://support.microsoft.com/kb/973301/en-US

Cumulative update package 3 for SQL Server 2008 Service Pack 1
http://support.microsoft.com/kb/971491/en-US

SQL Reporting services always passes string parameters as Unicode
http://support.microsoft.com/kb/2000524/en-US

FIX: The CPU usage of the resource monitor is very high when the virtual memory is running low in SQL Server 2008
http://support.microsoft.com/kb/968722/en-US

FIX: When you create a compressed backup for a database in SQL Server 2008, you cannot stop the backup operation if the backup operation stops responding
http://support.microsoft.com/kb/970133/en-US

SQL Server 2008 failover cluster installation can take a long time on Windows Server 2008
http://support.microsoft.com/kb/2000219/en-US

FIX: You receive an incorrect result when you run a query that uses the LIKE predicate against a table that uses the "Latin1_General_100_CI_AS" or the "Latin1_General_CI_AS" collation in SQL Server 2008
http://support.microsoft.com/kb/971780/en-US

FIX: The value of the Size property of the Smo.Server(<serverName>).Databases collection is incorrect after you install Microsoft SQL Server 2008 Service Pack 1
http://support.microsoft.com/kb/972207/en-US

FIX: The MAXDOP option for a running query or the max degree of parallelism option for the sp_configure stored procedure does not work in SQL Server 2008
http://support.microsoft.com/kb/970399/en-US

The Full-Text Search component is not completely rolled back to the Service Pack 1 version after you uninstall Cumulative Update 3 for SQL Server 2008 Service Pack 1 that is applied by using a slipstream installation
http://support.microsoft.com/kb/973888/en-US

FIX: Error message when you run the sp_add_alert stored procedure in SQL Server 2008 on a computer that is running Windows Server 2008 or Windows Vista: "SQLServerAgent Error: WMI error: 0x80041003"
http://support.microsoft.com/kb/973303/en-US

You may not be able to make a remote connection to SQL Server from a CLR trigger
http://support.microsoft.com/kb/2000373/en-US

SQL Server 2008 installation will fail if the setup account does not have certain user rights
http://support.microsoft.com/kb/2000257/en-US

FIX: A change to the Maximum File Size property on a large database takes a long time to finish in SQL Server 2008 Management Studio
http://support.microsoft.com/kb/973204/en-US

FIX: A Drillthrough action inside table groups passes incorrect parameter values in SQL Server 2008 Reporting Services
http://support.microsoft.com/kb/971985/en-US

You may notice a continuous growth in tempdb data file size with a corresponding increase in mixed_extent_page_count after upgrading SQL server
http://support.microsoft.com/kb/2000471/en-US

FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: "Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)"
http://support.microsoft.com/kb/972687/en-US

FIX: Error message when you run a full-text query in SQL Server 2008 after you register an IFilter: "No appropriate filter was found during full-text index population for table or indexed view"
http://support.microsoft.com/kb/972650/en-US

FIX: Error message when you run a multithreaded application that uses SQL Server Management Objects (SMO) version 10.00: "An item with the same key has already been added"
http://support.microsoft.com/kb/971914/en-US

FIX: A policy is evaluated against an incorrect target when you run the policy category in evaluation mode on a remote server that is running SQL Server 2008
http://support.microsoft.com/kb/970713/en-US

Cumulative update package 6 for SQL Server 2008
http://support.microsoft.com/kb/971490/en-US

FIX: A specified collation is displayed incorrectly when you use the Advanced/Enterprise installation mode to install a SQL Server 2008 failover cluster through the GUI
http://support.microsoft.com/kb/973250/en-US

FIX: Some columns are missing when you run a query against a table that is located on a linked server if the column names contain a period character in SQL Server 2008 Service Pack 1
http://support.microsoft.com/kb/972856/en-US

The default setting is used instead of the setting that is specified in the "Prepare Failover Cluster" stage when you perform an advanced cluster installation of a Microsoft SQL Server 2008 failover cluster
http://support.microsoft.com/kb/973992/en-US

FIX: Error message when you try to break database mirroring between two servers that are running SQL Server 2008: "Non-yielding Scheduler"
http://support.microsoft.com/kb/970044/en-US

FIX: Error message when you run a SQL Server 2008 Integration Services package that contains an Execute SQL Task that runs a stored procedure: "The type of the value being assigned to variable "<Variable>" differs from the current variable type"
http://support.microsoft.com/kb/969050/en-US

FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint '<PrimaryKey>'. Cannot insert duplicate key in object '<TableName>'"
http://support.microsoft.com/kb/970507/en-US

FIX: The “Copy Only Backup” option is still available even though you select the “Differential” option in the “Back Up Database” dialog box in SQL Server 2008 Management Studio
http://support.microsoft.com/kb/972201/en-US

FIX: Error message when you try to disable Resource Governor by using the UI in SQL Server 2008 Management Studio after you drop a Resource Governor workload group: "Alter failed for ResourceGovernor 'Microsoft.SqlServer.Management.Smo.ObjectKeyBase'"
http://support.microsoft.com/kb/972200/en-US

FIX: You cannot set up Data Collector on a SQL Server 2008 server if the server has a database that cannot be accessed or only allows restricted access
http://support.microsoft.com/kb/971640/en-US

FIX: Installing SQL Server 2008 Service Pack 1 may reset the "max_worker_threads" column value for a SQL Server Agent subsystem
http://support.microsoft.com/kb/972759/en-US

FIX: Error message when you run a SQL Server 2008-based application that calls the SQLBindParameter function: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"
http://support.microsoft.com/kb/971051/en-US

FIX: The Management Data Warehouse database grows very large after you enable the Data Collector feature in SQL Server 2008
http://support.microsoft.com/kb/970014/en-US

FIX: The SQL:BatchCompleted event and the RPC:Completed event displays an incorrect row count when you use SQL Server Profiler to monitor a sp_executesql stored procedure call in Microsoft SQL Server 2008
http://support.microsoft.com/kb/973257/en-US

 

Comments

Other SQL Server Blogs around the Web said:

There hasn&#39;t been much changes to the KBAs and here is complete list of items/pages that were were

# August 13, 2009 11:25 PM
Anonymous comments are disabled