Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » error log » error   (RSS)
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 Read More...
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 Read More...
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\MSSQL.1\MSSQL\Data Read More...
SQL Server Errors: could not spawn FRunCM thread and TDSSNIClient initialization failed with error 0xd, status code 0x36.
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 Read More...
"Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>' is invalid
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>' Read More...
SSIS Error: Text was truncated or one or more characters had no match in the target code page
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. Read More...