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.