Thursday, January 15, 2015

SQL Server Error Message - Errors 1 to 200

1
Version date of last upgrade: 10/11/90
21
Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.
102
Incorrect syntax near '%.*ls'.
103
The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.
104
ORDER BY items must appear in the select list if the statement contains a UNION operator.
105
Unclosed quotation mark before the character string '%.*ls'.
106
Too many table names in the query. The maximum allowable is %d.
107
The column prefix '%.*ls' does not match with a table name or alias name used in the query.
108
The ORDER BY position number %ld is out of range of the number of items in the select list.
109
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
110
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
111
'%ls' must be the first statement in a query batch.
112
Variables are not allowed in the %ls statement.
113
Missing end comment mark '*/'.
114
Browse mode is invalid for a statement that assigns values to a variable.
116
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
117
The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.
118
Only members of the sysadmin role can specify the %ls option for the %ls statement.
119
Must pass parameter number %d and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.
120
The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.
121
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
122
The %ls option is allowed only with %ls syntax.
123
Batch/procedure exceeds maximum length of %d characters.
124
CREATE PROCEDURE contains no statements.
125
Case expressions may only be nested to level %d.
128
The name '%.*ls' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
129
Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.
130
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
131
The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum allowed for any data type (%d).
132
The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.
133
A GOTO statement references the label '%.*ls' but the label has not been declared.
134
The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.
135
Cannot use a BREAK statement outside the scope of a WHILE statement.
136
Cannot use a CONTINUE statement outside the scope of a WHILE statement.
137
Must declare the variable '%.*ls'.
138
Correlation clause in a subquery not permitted.
139
Cannot assign a default value to a local variable.
140
Can only use IF UPDATE within a CREATE TRIGGER statement.
141
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
142
Incorrect syntax for definition of the '%ls' constraint.
143
A COMPUTE BY item was not found in the order by list. All expressions in the compute by list must also be present in the order by list.
144
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
145
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
146
Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.
147
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
148
Incorrect time syntax in time string '%.*ls' used with WAITFOR.
149
Time value '%.*ls' used with WAITFOR is not a valid value. Check date/time syntax.
150
Both terms of an outer join must contain columns.
151
'%.*ls' is an invalid money value.
153
Invalid usage of the option %.*ls in the %ls statement.
154
%S_MSG is not allowed in %S_MSG.
155
'%.*ls' is not a recognized %ls option.
156
Incorrect syntax near the keyword '%.*ls'.
157
An aggregate may not appear in the set list of an UPDATE statement.
159
For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
160
Rule does not contain a variable.
161
Rule contains more than one variable.
163
The compute by list does not match the order by list.
164
GROUP BY expressions must refer to column names that appear in the select list.
165
Privilege %ls may not be granted or revoked.
166
'%ls' does not allow specifying the database name as a prefix to the object name.
167
Cannot create a trigger on a temporary object.
168
The %S_MSG '%.*ls' is out of the range of computer representation (%d bytes).
169
A column has been specified more than once in the order by list. Columns in the order by list must be unique.
170
Line %d: Incorrect syntax near '%.*ls'.
171
Cannot use SELECT INTO in browse mode.
172
Cannot use HOLDLOCK in browse mode.
173
The definition for column '%.*ls' must include a data type.
174
The %ls function requires %d arguments.
177
The IDENTITY function can only be used when the SELECT statement has an INTO clause.
178
A RETURN statement with a return value cannot be used in this context.
179
Cannot use the OUTPUT option when passing a constant to a stored procedure.
180
There are too many parameters in this %ls statement. The maximum number is %d.
181
Cannot use the OUTPUT option in a DECLARE statement.
182
Table and column names must be supplied for the READTEXT or WRITETEXT utility.
183
The scale (%d) for column '%.*ls' must be within the range %d to %d.
185
Data stream is invalid for WRITETEXT statement in bulk form.
186
Data stream missing from WRITETEXT statement.
188
Cannot specify a log device in a CREATE DATABASE statement without also specifying at least one non-log device.
189
The %ls function requires %d to %d arguments.
191
Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
192
The scale must be less than or equal to the precision.
193
The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.
194
A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.
195
'%.*ls' is not a recognized %S_MSG.
196
SELECT INTO must be the first query in an SQL statement containing a UNION operator.
197
EXECUTE cannot be used as a source when inserting into a table variable.
198
Browse mode is invalid for statements containing a UNION operator.
199
An INSERT statement cannot contain a SELECT statement that assigns values to a variable.


No comments:

Post a Comment