SQL Server errors

Tutorials on how to avoid SQL Server common errors like objects that do not exists, or invalid names and arithmetic overflows when converting data from one data type to another one.

SQL Server errors

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 with the SQL Server instance itself. There are several reasons why this error may occur. 1. Incorrect SQL Server connection string One of the most …

SQL Server errors

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 insert a new row into a table with an IDENTITY column and the value being assigned to the IDENTITY column exceeds the maximum value that …

SQL Server errors

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 to run a truncate Table query. The Truncate is different from the Delete From query. Because it empties all the lines in the table without …

SQL Server errors

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 entered correctly. But only in specific cases and for certain databases. The stored procedure displays the error because the database tries to access a database …

SQL Server errors

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 and the first time it’s used. It means it’s deleted right after the first query ran against the CTE. Indeed when querying the second time …

SQL Server errors

Arithmetic overflow error converting expression

20 February 2022

With SQL Server, how to avoid this error : “Arithmetic overflow error converting expression to data type int”. Let’s insert some data into a table using a stored procedure for example. Facing this SQL Server error message can be disturbing. Even if SQL conversion errors are classical ones, finding the solution and apply the industry best practices to avoid them is very useful. In …