Browse by Tags

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

Published 13 February 8 5:2 AM | SSQA.net

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

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?

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

Unable to install SQL Server 2008 fails with error code 1603

Published 11 January 8 8:32 AM | SSQA.net

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

Filed under: sql server, microsoft, community, error, 2008, connect, error log, install, unable, network share

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

Published 11 December 7 2:47 AM | SSQA.net

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

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

SQL Server Errors: could not spawn FRunCM thread and TDSSNIClient initialization failed with error 0xd, status code 0x36.

Published 25 September 7 4:53 AM | SSQA.net

On one of the SQL Server instance recently we have been getting the following error: SQL Server could not spawn FRunCM thread. Error: 17182, Severity: 16, State: 1. 2005-10-30 15:35:44.79 Server TDSSNIClient initialization failed with error 0xd, status...

Filed under: sql server, sp2, error, error log, client, VIA, FRUNCM, TDS, protocols

"Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>' is invalid

Published 17 September 7 4:44 AM | SSQA.net

Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ""Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>'...

Filed under: sql server, error, error log, hardware, log file, detach, attach, data files, 9003, mdf

SSIS Error: Text was truncated or one or more characters had no match in the target code page

Published 29 August 7 2:54 AM | SSQA.net

This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format...

Filed under: sql server, ssis, error, jobs, scheduled, error log, file, truncated, destination, source

FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPart

Published 19 August 7 4:37 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a query that is...

Filed under: sql server, error, kba, error log, x64, assertion