SQL Server Errors or Failures Error: 185 to Error: 205


Below are some of the SQL Server Errors from Error: 185 to Error: 205

Error: 185, Severity: 15,
Data stream is invalid for WRITETEXT statement in bulk form.

Error: 186, Severity: 15,
Data stream missing from WRITETEXT statement.

Error: 187, Severity: 15,
The valid range for MAX_QUEUE_READERS is 0 to 32767.

Error: 188, Severity: 16,
Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file.

Error: 189, Severity: 15,
The %ls function requires %d to %d arguments.

Error: 190, Severity: 15,
An invalid date or time was specified in the statement.

Error: 191, Severity: 15,
Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

Error: 192, Severity: 15,
The scale must be less than or equal to the precision.

Error: 193, Severity: 16,
The object or column name starting with ‘%.*ls’ is too long. The maximum length is %d characters.

Error: 194, Severity: 15,
A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.

Error: 195, Severity: 15,
‘%.*ls’ is not a recognized %S_MSG.

Error: 196, Severity: 15,
SELECT INTO must be the first query in a statement containing a UNION, INTERSECT or EXCEPT operator.

Error: 197, Severity: 15,
EXECUTE cannot be used as a source when inserting into a table variable.

Error: 198, Severity: 15,
Browse mode is invalid for statements containing a UNION, INTERSECT or EXCEPT operator.

Error: 199, Severity: 15,
An INSERT statement cannot contain a SELECT statement that assigns values to a variable.

Error: 201, Severity: 15,
Procedure or function ‘%.*ls’ expects parameter ‘%.*ls’, which was not supplied.

Error: 202, Severity: 16,
Invalid type ‘%s’ for WAIT FOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAIT FOR DELAY supports the INT and SMALLINT data types.

Error: 203, Severity: 16,
The name ‘%.*ls’ is not a valid identifier.

Error: 204, Severity: 16,
Normalization error in node %ls.

Error: 205, Severity: 20,
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *