Welcome to

SqlServer-QA.net

Sign in | Join | 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 Standard Edition: List of Knowledge Base Articles (KBA) that are updated

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications. (You may find majority of KBA numbers similar to the earlier blog post).

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

 

SQL Server 2008 failover cluster installation can take a long time on Windows Server 2008
http://support.microsoft.com/kb/2000219/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

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

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

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

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: 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: 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: 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: 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: 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

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

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: 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

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 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: 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: 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

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

Cumulative update package 3 for SQL Server 2008 Service Pack 1
http://support.microsoft.com/kb/971491/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: 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: 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 Drillthrough action inside table groups passes incorrect parameter values in SQL Server 2008 Reporting Services
http://support.microsoft.com/kb/971985/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 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 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: 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 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: 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: 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: 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: 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 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: 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: 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

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 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: 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

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

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: 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

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

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

Anonymous comments are disabled