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 2005 default instance may not start when there is a SQL Server 2000 named instance and both instances are configured to listen on named pipes
The following pages were recently modified.

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

Product: Microsoft SQL Server 2005 Standard Edition
Notification Contents: New

SQL Server 2005 default instance may not start when there is a SQL Server 2000 named instance and both instances are configured to listen on named pipes
http://support.microsoft.com/kb/2000255/en-US
New 6/26/2009 4:55:00 PM GMT

How to fix permission issues when moving MSDB database between different instances
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Standard
Notification Contents: New and Major Modifications

How to fix permission issues when moving MSDB database between different instances
http://support.microsoft.com/kb/2000274/en-US
New 6/26/2009 5:00:00 PM GMT

The cluster setup fails without a clear error message when you install a SQL Server 2008 failover cluster and you select a drive that does not have a drive letter assigned
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Enterprise
Notification Contents: New and Major Modifications

The cluster setup fails without a clear error message when you install a SQL Server 2008 failover cluster and you select a drive that does not have a drive letter assigned
http://support.microsoft.com/kb/955722/en-US

SQL Server 2008 Cluster environment based KBAs
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Standard
Notification Contents: New and Major Modifications

How to change SQL Server parameters in a clustered environment when SQL Server is not online
http://support.microsoft.com/kb/953504/en-US

The cluster setup fails without a clear error message when you install a SQL Server 2008 failover cluster and you select a drive that does not have a drive letter assigned
http://support.microsoft.com/kb/955722/en-US

SQL Server 2005 Enterprise & Standard Editions Knowledge Base Notifications

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition
Notification Contents: New

FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in SQL Server 2005
http://support.microsoft.com/kb/958555/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: Log Reader Agent fails with error code 18834 in SQL Server 2005
http://support.microsoft.com/kb/958684/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: If you enter many rows into the Fuzzy Grouping transformation, you may obtain an incorrect result in SQL Server 2005 Integration Services
http://support.microsoft.com/kb/959030/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: An access violation occurs when you display the execution plan for a query that selects a computed column from a remote table in SQL Server 2005
http://support.microsoft.com/kb/957756/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: Error message when you restore a transaction log for a database by using the STANDBY option in SQL Server 2005: "The transaction log for database '<DatabaseName>' is full"
http://support.microsoft.com/kb/958554/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: A memory leak occurs when you repeatedly invoke a trigger that contains the RAISERROR statement in SQL Server 2005
http://support.microsoft.com/kb/958573/en-US
New 10/20/2008 8:16:00 PM GMT

FIX: Error message when you run a query in SQL Server 2005 by using a linked server to SQL Server 2000 after you change the login password: "Communication link failure"
http://support.microsoft.com/kb/955971/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: Error message when you run a full-text search query in SQL Server 2005: "Insufficient system resources exist to complete the requested service"
http://support.microsoft.com/kb/948452/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: A time-out setting is not available for the Web Service task in a Microsoft SQL Server 2005 Integration Services (SSIS) package
http://support.microsoft.com/kb/956911/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: When you run a query that contains a JOIN operation in SQL Server 2005, and the ON clause of the JOIN operator contains a LIKE predicate, the query runs slower than in SQL Server 2000
http://support.microsoft.com/kb/956686/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005
http://support.microsoft.com/kb/958004/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: A peer-to-peer transactional replication does not replicate rows if you rebuild the index for a published table at the same time as you insert data in the published table in SQL Server 2005
http://support.microsoft.com/kb/959032/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: Error message when you run the snapshot agent on a replication of a stored procedure in SQL Server 2005: "The Name property cannot have a value of @param_name for this version of SQL Server"
http://support.microsoft.com/kb/956889/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: The values of the datetime column are not same for the rows that are copied when you copy data to a table by using the GETDATE() function in Microsoft SQL Server 2005
http://support.microsoft.com/kb/958547/en-US
New 10/20/2008 8:18:00 PM GMT

FIX: The size of the SQL Server 2005 error log file grows very quickly when query notifications are created and destroyed in a high ratio
http://support.microsoft.com/kb/958006/en-US
New 10/20/2008 8:18:00 PM GMT

FIX: A query that performs multiple Clustered Index Seek operations or RID Lookup operations fails with an assertion in SQL Server 2005
http://support.microsoft.com/kb/958548/en-US
New 10/20/2008 8:18:00 PM GMT

FIX: Error message when you parse a query after you run the SET XACT_ABORT ON statement in SQL Server 2005: ".Net SqlClient Data Provider: A severe error occurred on the current command"
http://support.microsoft.com/kb/959028/en-US
New 10/20/2008 8:22:00 PM GMT

FIX: Data results are inconsistent when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute
http://support.microsoft.com/kb/956574/en-US
New 10/20/2008 8:22:00 PM GMT

FIX: Error message when you try to expand the Catalogs node for a linked server that links to a Teradata Database in SQL Server 2005: "Cannot obtain the schema rowset DBSCHEMA_CATALOGS for OLE DB provider SQL Server for linked server (null)"
http://support.microsoft.com/kb/959031/en-US
New 10/20/2008 8:32:00 PM GMT

FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect results in SQL Server 2008

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Standard
Notification Contents: New and Major Modifications

FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect results in SQL Server 2008
http://support.microsoft.com/kb/958208/en-US

SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Enterprise
Notification Contents: New and Major Modifications

SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages
http://support.microsoft.com/kb/955628/en-US

How to troubleshoot SQL Server 2008 Setup issues
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Enterprise
Notification Contents: New and Major Modifications

How to troubleshoot SQL Server 2008 Setup issues
http://support.microsoft.com/kb/955396/en-US

SQL Server 2008 knowledge base articles.
Source: Knowledge Base

Product: Microsoft SQL Server 2008 Enterprise
Notification Contents: New and Major Modifications

Error message when you try to run the SQL Server 2008 Setup program: "Setup was unable to open the file"
http://support.microsoft.com/kb/955760/en-US

 
Source: Knowledge Base
Product: Microsoft SQL Server 2008 Standard
Notification Contents: New and Major Modifications

Error message when you try to run the SQL Server 2008 Setup program: "Setup was unable to open the file"
http://support.microsoft.com/kb/955760/en-US

 

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Enterprise
Notification Contents: New and Major Modifications

The Shared Memory protocol for an instance of SQL Server 2008 is always enabled and the VIA protocol for the instance is always disabled after you repair the instance
http://support.microsoft.com/kb/955769/en-US

 

Source: Knowledge Base
Product: Microsoft SQL Server 2008 Enterprise
Notification Contents: New and Major Modifications

Error message when you try to install SQL Server 2008 if the path of the SQL Server 2008 installation media contains a number sign (#) character: "Could not load file or assembly '<Path>\Microsoft.SQL.Chainer.PackageData.dll' or one of its dependencies"
http://support.microsoft.com/kb/955666/en-US

 

You may receive errors when you perform tests that are documented in the Windows Server 2008 Software Logo Test Framework document for SQL Server 2008
http://support.microsoft.com/kb/955492/en-US

FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition
Notification Contents: New

FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"
http://support.microsoft.com/kb/954734/en-US

You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication in SQL Server 2005
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition
Notification Contents: New

You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication in SQL Server 2005
http://support.microsoft.com/kb/953201/en-US

FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query"

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition
Notification Contents: New

FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query"
http://support.microsoft.com/kb/934246/en-US

FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition
Notification Contents: New

FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"
http://support.microsoft.com/kb/953854/en-US

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition
Notification Contents: New

SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled state
http://support.microsoft.com/kb/953739/en-US

SQL Server 2000 and MSDE 2000 installers stop dependent services
http://support.microsoft.com/kb/953742/en-US

SQL Server 2005 installers stop dependent services
http://support.microsoft.com/kb/953741/en-US

A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition
Notification Contents: New

A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000
http://support.microsoft.com/kb/953122/en-US
New 6/10/2008 11:47:00 PM GMT

More Posts Next page »