SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : kba

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

Fri, 21 Aug 2009 14:23:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: You receive error messages or data is damaged after you run an SSIS package that contains...(read more)

Microsoft Advisory Services Engagement Scenario - SQL Server Performance

Thu, 20 Aug 2009 14:19:00 GMT

Attaining SQL Server performance is not a black magic, you need to asses and implement the scenarios effectively. The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Edition & SQL Server...(read more)

SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

Mon, 17 Aug 2009 06:20:00 GMT

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...(read more)

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

SqlServer-QA.net — Wed, 05 Nov 2008 10:58:00 GMT

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...(read more)

SQL Server 2005 Enterprise & Standard Editions Knowledge Base Notifications

SqlServer-QA.net — Tue, 21 Oct 2008 16:40:00 GMT

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...(read more)

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

SqlServer-QA.net — Tue, 21 Oct 2008 14:38:00 GMT

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...(read more)

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

SSQA.net — Thu, 31 Jul 2008 08:10:00 GMT

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...(read more)

SQL Server 2005 supportability on virtual environment

SSQA.net — Wed, 30 Jul 2008 08:39:00 GMT

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...(read more)

How to troubleshoot SQL Server 2008 Setup issues

SSQA.net — Wed, 30 Jul 2008 08:09:00 GMT

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...(read more)

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"

SSQA.net — Thu, 03 Jul 2008 21:46:00 GMT

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...(read more)

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

SSQA.net — Fri, 27 Jun 2008 09:10:00 GMT

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...(read more)

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"

SSQA.net — Tue, 24 Jun 2008 13:33:00 GMT

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...(read more)

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"

SSQA.net — Tue, 24 Jun 2008 01:30:00 GMT

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

SSQA.net — Fri, 13 Jun 2008 03:02:00 GMT

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

SSQA.net — Thu, 12 Jun 2008 07:01:00 GMT

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...(read more)

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"

SSQA.net — Mon, 02 Jun 2008 09:01:00 GMT

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...(read more)

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

SSQA.net — Thu, 29 May 2008 18:29:00 GMT

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...(read more)

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

SSQA.net — Wed, 28 May 2008 08:10:00 GMT

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...(read more)

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

SSQA.net — Tue, 20 May 2008 07:54:00 GMT

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...(read more)

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

SSQA.net — Thu, 15 May 2008 08:14:00 GMT

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...(read more)