A bare THROW passes an error on untouched. A new THROW or a copied RAISERROR message does not. See the proof, plus one semicolon trap.
SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed
A JDBC user got ‘The TCP/IP connection to the host localhost, port 1433 has failed’ even after checking the firewall. Here is the sqljdbc_auth.dll fix.
SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name
Error 1505 says the CREATE UNIQUE INDEX statement terminated because a duplicate key was found. The word key confuses many developers, so I explain it simply.
SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors
New developers often hit Error 8111 when they try a PRIMARY KEY constraint on nullable column, followed by Error 1750. Here is why it happens and how to fix it.
SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)
Importing Excel data with the Import and Export Wizard failed with a potential loss of data error. Here is what causes it and how to fix it.
SQL SERVER – Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator
Error 402 says ntext and varchar are incompatible in the equal to operator. I recreate it with a small table and walk through the possible solutions.
SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ or Microsoft SQL Native Client error ‘80040e07’
Error 80040e07, syntax error converting datetime from character string, usually means a bad date value. In one case a reader had simply misspelled September.