SQL Server Errors or Failures Error: 164 to Error: 184


Below are some of the SQL Server Errors, Error: 164 through Error: 184.

Error: 164, Severity: 15,
Each GROUP BY expression must contain at least one column that is not an outer reference

Error: 165, Severity: 16,
Privilege %ls may not be granted or revoked

Error: 166, Severity: 15,
‘%ls’ does not allow specifying the database name as a prefix to the object name

Error: 167, Severity: 15,
Cannot create %S_MSG on a temporary object

Error: 168, Severity: 15,
The floating point value ‘%.*ls’ is out of the range of computer representation (%d bytes)

Error: 169, Severity: 15,
A column has been specified more than once in the order by list. Columns in the order by list must be unique

Error: 171, Severity: 15,
Browse mode cannot be used with INSERT, SELECT INTO, or UPDATE statements

Error: 172, Severity: 15,
Cannot use HOLDLOCK in browse mode

Error: 173, Severity: 15,
The definition for column ‘%.*ls’ must include a data type

Error: 174, Severity: 15,
The %.*ls function requires %d argument(s)

Error: 175, Severity: 15,
An aggregate may not appear in a computed column expression or check constraint

Error: 176, Severity: 15,
The FOR BROWSE clause is no longer supported in views

Error: 177, Severity: 15,
The IDENTITY function can only be used when the SELECT statement has an INTO clause

Error: 178, Severity: 15,
A RETURN statement with a return value cannot be used in this context

Error: 179, Severity: 15,
Cannot use the OUTPUT option when passing a constant to a stored procedure

Error: 180, Severity: 15,
There are too many parameters in this %ls statement. The maximum number is %d

Error: 181, Severity: 15,
Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement

Error: 182, Severity: 15,
Table and column names must be supplied for the READTEXT or WRITETEXT utility

Error: 183, Severity: 15,
The scale (%d) for column ‘%.*ls’ must be within the range %d to %d

Error: 184, Severity: 16,
DEFAULT cannot be specified more than once for filegroups of the same content type

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 *