Monday, January 19, 2015

SQL Server Error Messages 201-314

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

No comments:

Post a Comment