Archives des SQL Server errors

Full-Text Search is not installed or a full-text component cannot be loaded

18 March 2024

Using SQL Server, you just encountered the error “Full-Text Search is not installed, or a full-text component cannot be loaded.” In my case I was creating a Full Text on a table. It simply means that this specific feature …

Arithmetic overflow error converting expression to data type int

10 July 2023

SQL Server tutorial with workaround to avoid the “Arithmetic overflow error converting expression to data type int” error. With SQL Server, how to avoid this error : “Arithmetic overflow error converting expression to data type int”. Let’s insert some …

SQL Server error login timeout expired with code 0x80004005

21 December 2022

The SQL Server error code 0x80004005 login timeout expired is a common error that occurs when trying to connect to a SQL Server instance. This error is usually caused by a problem with the connection settings or a problem …

Arithmetic overflow error converting IDENTITY to data type

6 December 2022

How to avoid the arithmetic overflow error when converting IDENTITY to INT data type with SQL Server? In T-SQL, the arithmetic overflow error when converting IDENTITY to INT data type is an error message that appears when attempting to …

Cannot find the object because it does not exist SQL Server error

10 May 2022

How to avoid the SQL Server Truncate Table Error Cannot find the object because it does not exist or you do not have permissions? In SQL Server, to clear the full content of a table, the fastest way is …

Database does not exist error in sp_MSforeachdb

11 April 2022

How to fix the database does not exist error in sp_MSforeachdb ? With MS SQL Server, when using the sp_MSforeachdb system stored procedure, the system displays this error : Database does not exist. Make sure that the name is …

Invalid object name SQL Server CTE Error

24 February 2022

How to avoid the Invalid object name SQL Server CTE Error ? Or how to execute multiple SELECT queries on the same CTE ? As a reminder, a CTE is a temporary object that only exists between its creation …

Violation of unique key constraint cannot insert duplicate SQL Server error

21 February 2022

2 solutions to fix the SQL Server error : violation of unique key constraint cannot insert duplicate key. How to avoid and fix the Violation of unique key constraint, cannot insert duplicate key error during SQL Server development? Insert …