MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Browse by Tags

Blogs

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

Syndication

News

Blog Archive List

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

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

Published Fri, Aug 21 2009 9:23 by SqlServer-QA.net

Filed under: sql server, package, ssis, error, kba, agent, data flow, fix, low memory
SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

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

Published Thu, Aug 20 2009 9:21 by SqlServer-QA.net

Filed under: sql server, performance, error, 2008, 2005, reports, 701, batch size
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

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

Published Mon, Jul 27 2009 2:07 by SqlServer-QA.net

Filed under: sql server, dmv, error, best practices, spid, connections, code, msdtc, kill, rollback, orphan, distributed transactions
SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

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

Published Sat, May 23 2009 3:42 by SqlServer-QA.net

Filed under: sql server, restore, tech-ed, mvp, error, BOL, best practices, backups, corrupted, system databases, resource databases
Error: SQL Server 2000 DTS Designer components are required to edit DTS packages. (Microsoft.SqlServer.DtsObjectExplorerUI)

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

Published Wed, Feb 11 2009 7:38 by SqlServer-QA.net

Filed under: sql server, ssis, tools, error, component, dts, best practices, code, setup, integration services, migration, backward compatibility
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)

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

Published Wed, Feb 11 2009 1:32 by SqlServer-QA.net

Filed under: sql server, services, replication, error, cluster, msdtc, distributor, subscriptions, linked server, error 7391
SQL Server 2005 .NET Framework execution was aborted by escalation policy because of out of memory on 32 bit system

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

Published Fri, Dec 5 2008 7:23 by SqlServer-QA.net

Filed under: sql server, performance, memory, clr, error, component, .NET, out of memory
SQL Server 2008 Cluster environment based KBAs

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

Published Tue, Nov 4 2008 1:55 by SqlServer-QA.net

Filed under: sql server, error, cluster, environment, parameter, failover
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...

Published Thu, Jul 31 2008 3:10 by SSQA.net

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"

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

Published Tue, Jun 24 2008 8:33 by SSQA.net

Filed under: sql server, error, kba, stored procedure, overflow, stack, compilation
Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?

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

Published Tue, Jun 24 2008 3:02 by SSQA.net

Filed under: sql server, trace, error, access denied, netmon, general network error, timeout expired
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"

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

Published Wed, May 7 2008 15:28 by SSQA.net

Filed under: sql server, error, kba, bulk insert, data type, timestamp
Error: 'There is insufficient system memory to run this query' and 'Downgrading backup buffers from 960K to 64K"?

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

Published Fri, Mar 28 2008 4:31 by SSQA.net

Filed under: sql server, memory, error, update statistics, buffers, memtoleave, downgrade, insufficient
SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”

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

Published Tue, Feb 26 2008 2:33 by SSQA.net

Filed under: sql server, ado.net, users, error, best practices, images, 80004005, upload, web page, asp page
SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

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

Published Wed, Feb 13 2008 5:02 by SSQA.net

Filed under: sql server, tools, upgrade, replication, error, error log, timeout, servers
SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

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

Published Wed, Jan 16 2008 1:40 by SSQA.net

Filed under: sql server, microsoft, error, kba, 2000, error log, 2005, stored procedure, linked server, aspfaq, issues
Tabular Data Stream (TDS) version 0x73090003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

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

Published Tue, Jan 15 2008 2:09 by SSQA.net

Filed under: sql server, microsoft, download, error, 2008, ctp, .NET, visual studio, system state, protocol, connection, framework
Unable to install SQL Server 2008 fails with error code 1603

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

Published Fri, Jan 11 2008 8:32 by SSQA.net

Filed under: sql server, microsoft, community, error, 2008, connect, error log, install, unable, network share
How to find subscriber is not getting upto date data?

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

Published Fri, Dec 14 2007 19:18 by SSQA.net

Filed under: sql server, data, replication, error, subscriptions
SQL Server Error 4616 - You cannot perform this operation for the restore database

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

Published Tue, Dec 11 2007 2:47 by SSQA.net

Filed under: sql server, database, error, error log, resource, attach, .mdf, 4616

1 2 3 4 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

Browse by Tags

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

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

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

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

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

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

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)

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

SQL Server 2008 Cluster environment based KBAs

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

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"

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

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"

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

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

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

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

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

Unable to install SQL Server 2008 fails with error code 1603

How to find subscriber is not getting upto date data?

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