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

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)

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

Thu, 20 Aug 2009 14:21:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...(read more)

SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

Mon, 27 Jul 2009 07:07:00 GMT

Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...(read more)

SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

Sat, 23 May 2009 08:42:00 GMT

The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For...(read more)

Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)

Wed, 11 Feb 2009 13:38:00 GMT

The error message text (partial) on the subject will be familiar for the DTS/SSIS users in SQL Server. On the background of the issue is that when you attempt of open a DTS package for editing from SQL Server 2008 Client machine, I have seen questions...(read more)

The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)

Wed, 11 Feb 2009 07:32:00 GMT

The above error clearly specifies the connectivity issues between 2 instance, to give more information I have been dealing with this problem at a client's place. The setup that was configured and deployed was a very complicated replication between...(read more)

SQL Server 2005 .NET Framework execution was aborted by escalation policy because of out of memory on 32 bit system

SqlServer-QA.net — Fri, 05 Dec 2008 13:23:00 GMT

The above error was returned on a SQL Server 32 bit system that is used for an inventory application, the initial though on out of memory was to see what is the resource usage at that moment as the SQL Server memory settings are set to DYNAMIC and all...(read more)

SQL Server 2008 Cluster environment based KBAs

SqlServer-QA.net — Tue, 04 Nov 2008 07:55:00 GMT

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

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)

Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?

SSQA.net — Tue, 24 Jun 2008 08:02:00 GMT

The following error is a frequent-faced issue by any SQL Server user : SQL Server is unavailable or does not exist or SQL Server does not exist or access denied In this regard we have already relevant post PotentialCauses_Resolution here, but still I...(read more)

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"

SSQA.net — Wed, 07 May 2008 20:28: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 and Major Modifications FIX: Error message when you use the BULK...(read more)

Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?

SSQA.net — Fri, 28 Mar 2008 09:31:00 GMT

Have you ever observed the error specified above? Do you need to worry for this issue, yes! First task to check what are the memory settings on SQL Server, by default they will be DYNAMIC and quite common that they might have set with MIN & MAX settings...(read more)

SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”

SSQA.net — Tue, 26 Feb 2008 08:33:00 GMT

One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the...(read more)

SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

SSQA.net — Wed, 13 Feb 2008 11:02:00 GMT

One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout...(read more)

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

SSQA.net — Wed, 16 Jan 2008 07:40:00 GMT

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

Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

SSQA.net — Tue, 15 Jan 2008 08:09:00 GMT

Very confusing error when trying to connect to a Database Engine (SQL Server 2008) using 'usual' windows authentication getting the following error: A connection was successfully established with the server, but then an error occurred during the...(read more)

Unable to install SQL Server 2008 fails with error code 1603

SSQA.net — Fri, 11 Jan 2008 14:32:00 GMT

SQL Server 2008 CTP5 is failed to install on Windows Server 2008 core, have no problem in Windows Server 2003. So whenever you have a problem in installing any edition of SQL Server it is better to refer to the log file that is used to log all the activities...(read more)

How to find subscriber is not getting upto date data?

SSQA.net — Sat, 15 Dec 2007 01:18:00 GMT

Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select agent_id from msdistribution_status group by agent_id having sum(undelivCmdsInDistDB) >1000 order by sum(undelivCmdsInDistDB) desc...( read more...(read more)

SQL Server Error 4616 - You cannot perform this operation for the restore database

SSQA.net — Tue, 11 Dec 2007 08:47:00 GMT

You may be aware default 4 SQL Server system databases master, model, msdb & tempdb are created automatically when the SQL Server is installed. Those databases files can be located under default directory assuming C:\Program Files\Microsoft SQL Server...(read more)