Welcome to SSQA.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 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

Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"
The following pages were recently modified.

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

Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"
http://support.microsoft.com/kb/952734/en-US

 

Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2
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  X64Edition
Notification Contents: New

Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2
http://support.microsoft.com/kb/953118/en-US
New 5/29/2008 4:45:00 PM GMT

A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Reporting Services
Notification Contents: New, All Modifications and Delete

A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services
http://support.microsoft.com/kb/842423/en-US

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
The following pages were recently modified.

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

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
http://support.microsoft.com/kb/949075/en-US

A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL Server 2005 native Web service
The following pages were recently modified.

Source: Knowledge Base
Product: Microsoft SQL Server 2005 Standard Edition
Notification Contents: New and All Modifications

A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL Server 2005 native Web service
http://support.microsoft.com/kb/907886/en-US

KBA - UPDATE Statements May be Replicated as DELETE/INSERT Pairs & Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations
The following pages were recently modified.

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

UPDATE Statements May be Replicated as DELETE/INSERT Pairs
http://support.microsoft.com/kb/238254/en-US

Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations
http://support.microsoft.com/kb/897284/en-US

More Posts Next page »