201 | Procedure '%.*ls' expects parameter '%.*ls', which was not supplied. |
202 | Invalid type '%s' for WAITFOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAITFOR DELAY supports the INT and SMALLINT data types. |
203 | The name '%.*ls' is not a valid identifier. |
204 | Normalization error in node %ls. |
205 | All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists. |
206 | Operand type clash: %ls is incompatible with %ls |
207 | Invalid column name '%.*ls'. |
208 | Invalid object name '%.*ls'. |
209 | Ambiguous column name '%.*ls'. |
210 | Syntax error converting datetime from binary/varbinary string. |
212 | Expression result length exceeds the maximum. %d max, %d found. |
213 | Insert Error: Column name or number of supplied values does not match table definition. |
214 | Procedure expects parameter '%ls' of type '%ls'. |
217 | Maximum stored procedure, function, trigger, or view nesting level exceeded (limit %d). |
220 | Arithmetic overflow error for data type %ls, value = %ld. |
221 | FIPS Warning: Implicit conversion from %ls to %ls. |
223 | Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default. |
224 | Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default. |
226 | %ls statement not allowed within multi-statement transaction. |
229 | %ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'. |
230 | %ls permission denied on column '%.*ls' of object '%.*ls', database '%.*ls', owner '%.*ls'. |
231 | No such default. ID = %ld, database ID = %d. |
232 | Arithmetic overflow error for type %ls, value = %f. |
233 | The column '%.*ls' in table '%.*ls' cannot be null. |
234 | There is insufficient result space to convert a money value to %ls. |
235 | Cannot convert a char value to money. The char value has incorrect syntax. |
236 | The conversion from char data type to money resulted in a money overflow error. |
237 | There is insufficient result space to convert a money value to %ls. |
238 | There is insufficient result space to convert the %ls value (= %d) to the money data type. |
241 | Syntax error converting datetime from character string. |
242 | The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. |
243 | Type %.*ls is not a defined system type. |
244 | The conversion of the %ls value '%.*ls' overflowed an %hs column. Use a larger integer column. |
245 | Syntax error converting the %ls value '%.*ls' to a column of data type %ls. |
248 | The conversion of the %ls value '%.*ls' overflowed an int column. Maximum integer value exceeded. |
251 | Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded. |
256 | The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. |
257 | Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query. |
259 | Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this. |
260 | Disallowed implicit conversion from data type %ls to data type %ls, table '%.*ls', column '%.*ls'. Use the CONVERT function to run this query. |
261 | '%.*ls' is not a recognized function. |
262 | %ls permission denied in database '%.*ls'. |
263 | Must specify table to select from. |
264 | Column name '%.*ls' appears more than once in the result column list. |
266 | Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld. |
267 | Object '%.*ls' cannot be found. |
268 | Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option. |
270 | Object '%.*ls' cannot be modified. |
271 | Column '%.*ls' cannot be modified because it is a computed column. |
272 | Cannot update a timestamp column. |
273 | Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column. |
278 | The text, ntext, and image data types cannot be used in a GROUP BY clause. |
279 | The text, ntext, and image data types are invalid in this subquery or aggregate expression. |
280 | Only text, ntext, and image columns are valid with the TEXTPTR function. |
281 | %d is not a valid style number when converting from %ls to a character string. |
282 | The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. |
283 | READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger. |
284 | Rules cannot be bound to text, ntext, or image data types. |
285 | The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions. |
286 | The logical tables INSERTED and DELETED cannot be updated. |
287 | The %ls statement is not allowed within a trigger. |
288 | The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only. |
291 | CAST or CONVERT: invalid attributes specified for type '%.*ls' |
292 | There is insufficient result space to convert a smallmoney value to %ls. |
293 | Cannot convert char value to smallmoney. The char value has incorrect syntax. |
294 | The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error. |
295 | Syntax error converting character string to smalldatetime data type. |
296 | The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. |
298 | The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error. |
299 | The DATEADD function was called with bad type %ls. |
301 | Query contains an outer-join request that is not permitted. |
303 | The table '%.*ls' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause. |
306 | The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. |
307 | Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist. |
308 | Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist. |
311 | Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables. |
312 | Cannot reference text, ntext, or image columns in a filter stored procedure. |
313 | An insufficient number of arguments were supplied for the procedure or function %.*ls. |
314 | Cannot use GROUP BY ALL with the special tables INSERTED or DELETED. |
Monday, January 19, 2015
SQL Server Error Messages 201-314
Labels:
SQL Server TSQL Errors
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment