Browse by Tags

SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages

Published 31 July 8 3:10 AM | SSQA.net

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

Filed under: sql server, error, kba, 2008, configuration, setup, crash

SQL Server 2005 supportability on virtual environment

Published 30 July 8 3:39 AM | SSQA.net

Virtualization and Consolidation is still a hot topic and revising SQL Server consolidation and virtualization - hot topic in the industry related post here that you can easily manage the resources by using virtual machine technology that enables multiple...

Filed under: sql server, kba, virtual, support, environment

How to troubleshoot SQL Server 2008 Setup issues

Published 30 July 8 3:9 AM | SSQA.net

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

Filed under: sql server, kba, 2008, setup

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"

Published 3 July 8 4:46 PM | SSQA.net

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

Filed under: sql server, kba, tsql, clustered index, dbcc dbreindex, 2511, unique

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

Published 27 June 8 4:10 AM | SSQA.net

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

Filed under: sql server, kba, partition, publication, merge replication

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"

Published 24 June 8 8:33 AM | SSQA.net

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

Filed under: sql server, error, kba, stored procedure, overflow, stack, compilation

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"

Published 23 June 8 8:30 PM | SSQA.net

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

Filed under: sql server, query, kba, processor, delete, query plan, statement, internal

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

Published 12 June 8 10:2 PM | SSQA.net

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

Filed under: sql server, instance, kba, installation, 2000, 2005, msde

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

Published 12 June 8 2:1 AM | SSQA.net

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

Filed under: sql server, kba, management studio, backups, enterprise manager, tape

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"

Published 2 June 8 4:1 AM | SSQA.net

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

Filed under: sql server, kba, stored procedure, bcp, dynamic query, error message, dsql

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

Published 29 May 8 1:29 PM | SSQA.net

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

Filed under: sql server, maintenance plan, kba, service pack2, subplan

SQL Server Cumulative Update uninstallation fiasco. Dude, can I remove SQL Server setup files?

Published 28 May 8 3:10 AM | SSQA.net

We have been struggling to uninstall the Cumulative Update package 7 on a development SQL Server! As it is an important aspect of installation to rollback or to have a backout plan tested if you are performing any kind of installation against your Production...

Filed under: sql server, kba, best practices, setup, cumulative update, installallation

A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services

Published 20 May 8 2:54 AM | SSQA.net

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

Filed under: sql server, kba, reporting services, api, email, subscription, call

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

Published 15 May 8 3:14 AM | SSQA.net

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

Filed under: sql server, kba, transaction, 2005, msdtc, issues

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

Published 15 May 8 1:9 AM | SSQA.net

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

Filed under: sql server, kba, .NET, 2003, visual studio, native web services

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

Published 13 May 8 1:45 PM | SSQA.net

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

Filed under: sql server, update, i/o, kba, insert, delete, statement, sp4

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000

Published 12 May 8 1:43 PM | SSQA.net

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 A query that references a nondeterministic...

Filed under: sql server, performance, query, kba, 2000, 2005, slow

New and Modified Knowledge Base article for SQL Server 2005 Reporting Services

Published 8 May 8 3:31 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server...

Filed under: sql server, report builder, kba, object, .NET, reporting services, sap, business intelligence, character, data provider, null, parentNode

FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered"

Published 7 May 8 3:28 PM | SSQA.net

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 FIX: Error message when you use the BULK...

Filed under: sql server, error, kba, bulk insert, data type, timestamp

The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005

Published 6 May 8 10:7 AM | SSQA.net

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 and Major Modifications...

Filed under: sql server, ssms, kba, import, management studio, export, identity key