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

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

SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Published 16 January 8 1:40 AM | SSQA.net

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual...

Filed under: sql server, microsoft, error, kba, 2000, error log, 2005, stored procedure, linked server, aspfaq, issues

Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"

Published 21 November 7 4:25 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 Error message when you try to replicate...

Filed under: sql server, replication, error, kba, hresult, mobile edition

You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard

Published 18 November 7 3:15 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 and Major Modifications...

Filed under: sql server, error, kba, import, table, x64, wizard, export

Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified"

Published 16 November 7 12:18 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 and Major Modifications Error message when you connect to a named...

Filed under: sql server, error, kba, longhorn, vista, named instance, server not found, windows server 2008

FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server

Published 15 November 7 3:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual...

Filed under: sql server, error, kba, view, oledb, visual foxpro

FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: "Data conversion failed" and "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR&

Published 31 October 7 9:7 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition,SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX...

Filed under: sql server, ssis, error, kba, integration services, SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR

FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs

Published 31 October 7 2:11 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: SQL Server 2005 may send error information for the same problem many times...

Filed under: sql server, error, kba, processor, information, fatal error

You receive an error message when you try to uninstall the second named instance of SQL Server 2005

Published 31 October 7 9:4 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 You receive an error message when you try to uninstall the second named instance of...

Filed under: sql server, error, kba, installation, uninstall, named instance

FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"

Published 27 October 7 9:45 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, error, kba, function, bcp, native client, length-prefix, terminator

FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0"

Published 23 October 7 6:17 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 run a DML statement...

Filed under: sql server, ssis, error, kba, fuzzy, lookup, reporting services, sp_FuzzyLookupTableMaintenanceInvoke, error 6549

Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: "ERROR Selected writer 'Microsoft Writer (Service State)' is in failed state"

Published 21 October 7 12:57 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message when you create a snapshot backup...

Filed under: sql server, database, error, kba, snapshot, service state, writer

FIX: You receive a time-out error message when you try to send a message to the target service of a Service Broker application that you create in SQL Server 2005

Published 15 October 7 2:23 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, error, kba, service broker, timeout, target service

FIX: Error message when you set up a snapshot publication on a database in SQL Server 2005: "Error 137, Must declare the scalar variable <VariableName>"

Published 12 October 7 6:5 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, error, kba, variable, snapshot, publication, 137, scalar, declare

FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged"

Published 5 October 7 7:32 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, error, kba, xml, collation, column, data type, damaged

FIX: Error message when you run the CREATE ASSEMBLY statement to register a CLR assembly in SQL Server 2005: "An error occurred while gathering metadata from assembly '<AssemblyName>' with HRESULT 0x80131"

Published 2 October 7 6:18 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, error, kba, assembly, create, registry, hresult

A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2

Published 1 October 7 4:40 AM | SSQA.net

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package...

Filed under: sql server, performance, ssis, trace, update, error, kba, installation, instances, 4014, netmon

FIX: The Report Designer or the Report Manager stops responding when you try to export a SQL Server 2005 Reporting Services report to a PDF file or a TIFF file

Published 19 September 7 11:55 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 FIX: The Report Designer or the Report Manager stops responding when you...

Filed under: sql server, error, kba, reporting services, report viewer, pdf, tiff, responding, designer