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.
|
Thursday, January 15, 2015
SQL Server Error Message - Errors 1 to 200
Labels:
SQL Server TSQL Errors
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment