做DBA,未算赢先计输

很快就要转MS SQL了，贴份error list

Errors 1 - 999
Error Severity Description
1 10 Version date of last upgrade: 10/11/90.
21 10 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.
102 15 Incorrect syntax near '%.*ls'.
103 15 The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.
104 15 ORDER BY items must appear in the select list if the statement contains a UNION operator.
105 15 Unclosed quotation mark before the character string '%.*ls'.
106 16 Too many table names in the query. The maximum allowable is %d.
107 15 The column prefix '%.*ls' does not match with a table name or alias name used in the query.
108 15 The ORDER BY position number %ld is out of range of the number of items in the select list.
109 15 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 15 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 15 '%ls' must be the first statement in a query batch.
112 15 Variables are not allowed in the %ls statement.
113 15 Missing end comment mark '*/'.
114 15 Browse mode is invalid for a statement that assigns values to a variable.
116 15 Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
117 15 The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.
118 15 Only members of the sysadmin role can specify the %ls option for the %ls statement.
119 15 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 15 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 15 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.
123 15 Batch/procedure exceeds maximum length of %d characters.
124 15 CREATE PROCEDURE contains no statements.
125 15 Case expressions may only be nested to level %d.
128 15 The name '%.*ls' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
129 15 Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.
130 16 Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
131 15 The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum. The largest size allowed is %d.
132 15 The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.
133 15 A GOTO statement references the label '%.*ls' but the label has not been declared.
134 15 The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.
135 15 Cannot use a BREAK statement outside the scope of a WHILE statement.
136 15 Cannot use a CONTINUE statement outside the scope of a WHILE statement.
137 15 Must declare the variable '%.*ls'.
138 15 Correlation clause in a subquery not permitted.
139 15 Cannot assign a default value to a local variable.
140 15 Can only use IF UPDATE within a CREATE TRIGGER statement.
141 15 A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
142 15 Incorrect syntax for definition of the '%ls' constraint.
143 15 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 15 Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
145 15 ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
146 15 Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.
147 15 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 15 Incorrect time syntax in time string '%.*ls' used with WAITFOR.
149 15 Time value '%.*ls' used with WAITFOR is not a valid value. Check date/time syntax.
150 15 Both terms of an outer join must contain columns.
151 15 '%.*ls' is an invalid money value.
153 15 Invalid usage of the option %.*ls in the %ls statement.
154 15 %S_MSG is not allowed in %S_MSG.
155 15 '%.*ls' is not a recognized %ls option.
156 15 Incorrect syntax near the keyword '%.*ls'.
157 15 An aggregate may not appear in the set list of an UPDATE statement.
159 15 For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
160 15 Rule does not contain a variable.
161 15 Rule contains more than one variable.
163 15 The compute by list does not match the order by list.
164 15 GROUP BY expressions must refer to column names that appear in the select list.
165 16 Privilege %ls may not be granted or revoked.
166 15 '%ls' does not allow specifying the database name as a prefix to the object name.
167 16 Cannot create a trigger on a temporary object.
168 15 The %S_MSG '%.*ls' is out of the range of computer representation (%d bytes).
169 15 A column has been specified more than once in the order by list. Columns in the order by list must be unique.
170 15 Line %d: Incorrect syntax near '%.*ls'.
171 15 Cannot use SELECT INTO in browse mode.
172 15 Cannot use HOLDLOCK in browse mode.
173 15 The definition for column '%.*ls' must include a data type.
174 15 The %ls function requires %d arguments.
177 15 The IDENTITY function can only be used when the SELECT statement has an INTO clause.
178 15 A RETURN statement with a return status can only be used in a stored procedure.
179 15 Cannot use the OUTPUT option when passing a constant to a stored procedure.
180 15 There are too many parameters in this %ls statement. The maximum number is %d.
181 15 Cannot use the OUTPUT option in a DECLARE statement.
182 15 Table and column names must be supplied for the READTEXT or WRITETEXT utility.
183 15 The scale (%d) for column '%.*ls' must be within the range %d to %d.
185 15 Data stream is invalid for WRITETEXT statement in bulk form.
186 15 Data stream missing from WRITETEXT statement.
188 15 Cannot specify a log device in a CREATE DATABASE statement without also specifying at least one non-log device.
189 15 The %ls function requires %d to %d arguments.
190 15 Cannot update the function '%.*ls'.
191 15 Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
192 16 The scale must be less than or equal to the precision.
193 15 The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.
194 15 A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.
195 15 '%.*ls' is not a recognized %S_MSG.
196 15 SELECT INTO must be the first query in a SQL statement containing a UNION operator.
198 15 Browse mode is invalid for statements containing a UNION operator.
199 15 An INSERT statement cannot contain a SELECT statement that assigns values to a variable.
201 16 Procedure '%.*ls' expects parameter '%.*ls', which was not supplied.
203 16 The name '%.*ls' is not a valid identifier.
204 20 Normalization error in node %ls.
205 16 All queries in a SQL statement containing a UNION operator must have an equal number of expressions in their target lists.
206 16 Operand type clash: %ls is incompatible with %ls
207 16 Invalid column name '%.*ls'.
208 16 Invalid object name '%.*ls'.
209 16 Ambiguous column name '%.*ls'.
210 16 Syntax error converting datetime from binary/varbinary string.
212 16 Expression result length exceeds the maximum. %d max, %d found.
213 16 Insert Error: Column name or number of supplied values does not match table definition.
214 16 Cannot convert parameter '%ls' to %ls data type expected by procedure.
217 16 Maximum stored procedure nesting level exceeded (limit %d).
220 16 Arithmetic overflow error for data type %ls, value = %ld.
221 10 FIPS Warning: Implicit conversion from %ls to %ls.
223 11 Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default.
224 11 Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.
226 16 %ls statement not allowed within multi-statement transaction.
229 14 %ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.
230 14 %ls permission denied on column '%.*ls' of object '%.*ls', database '%.*ls', owner '%.*ls'.
231 11 No such default. ID = %ld, database ID = %d.
232 16 Arithmetic overflow error for type %ls, value = %f.
233 16 The column '%.*ls' in table '%.*ls' cannot be null.
234 16 There is insufficient result space to convert a money value to %ls.
235 16 Cannot convert a char value to money. The char value has incorrect syntax.
236 16 The conversion from char data type to money resulted in a money overflow error.
237 16 There is insufficient result space to convert a money value to %ls.
238 16 There is insufficient result space to convert the %ls value (= %d) to the money data type.
241 16 Syntax error converting datetime from character string.
242 16 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
243 16 Type %.*ls is not a defined system type.
244 16 The conversion of the %ls value '%.*ls' overflowed an %hs column. Use a larger integer column.
245 16 Syntax error converting the %ls value '%.*ls' to a column of data type %ls.
248 16 The conversion of the %ls value '%.*ls' overflowed an int column. Maximum integer value exceeded.
251 16 Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.
252 16 Cannot group by a bit column.
256 16 The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.
257 16 Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.
259 16 Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.
260 16 Disallowed implicit conversion from data type %ls to data type %ls, table '%ls', column '%ls'. Use the CONVERT function to run this query.
261 16 '%.*ls' is not a recognized function.
262 16 %ls permission denied, database '%.*ls', owner '%.*ls'.
263 16 Must specify table to select from.
264 16 Column name '%.*ls' appears more than once in the result column list.
266 16 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld.
267 16 Object '%.*ls' cannot be found.
268 16 Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.
270 16 Table '%.*ls' cannot be modified.
271 16 Column '%.*ls' cannot be modified because it is a computed column.
272 16 Cannot update a timestamp column.
273 16 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 16 The text, ntext, and image data types cannot be used in a GROUP BY clause.
279 16 The text, ntext, and image data types are invalid in this subquery or aggregate expression.
280 16 Only text, ntext, and image data types are valid with the TEXTPTR function.
281 16 %d is not a valid style number when converting from datetime to a character string.
282 10 The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
284 16 Rules cannot be bound to text, ntext, or image data types.
285 16 The READTEXT and WRITETEXT statements cannot be used with views.
286 16 The logical tables INSERTED and DELETED cannot be updated.
287 16 The %ls statement is not allowed within a trigger.
288 16 The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.
292 16 There is insufficient result space to convert a smallmoney value to %ls.
293 16 Cannot convert char value to smallmoney. The char value has incorrect syntax.
294 16 The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.
295 16 Syntax error converting character string to smalldatetime data type.
296 16 The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
298 16 The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.
299 16 The DATEADD function was called with bad type %ls.
301 16 Query contains an outer-join request that is not permitted.
303 16 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 16 The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with the LIKE or IS NULL predicates.
307 16 Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.
308 16 Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.
310 16 Invalid escape sequence. Valid characters after ESC are: an ESC pair, underscore, percent sign.
311 16 Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.
312 16 Cannot reference text, ntext, or image columns in a filter stored procedure.
401 16 Unimplemented statement or expression %ls.
403 16 Invalid operator for data type. Operator equals %ls, type equals %ls.
409 16 The %ls operation cannot take a %ls data type as an argument.
410 20 COMPUTE clause #%d 'BY' expression #%d is not in the order by list.
411 20 COMPUTE clause #%d, aggregate expression #%d is not in the select list.
420 16 The text, ntext, and image data types cannot be used in an ORDER BY clause.
425 16 Data type %ls of receiving variable is not equal to the data type %ls of column '%.*ls'.
426 16 The length %d of the receiving variable is less than the length %d of the column '%.*ls'.
427 20 Could not load sysprocedures entries for constraint ID %d in database ID %d.
428 20 Could not find row in sysconstraints for constraint ID %d in database ID %d.
429 20 Could not find new constraint ID %d in sysconstraints, database ID %d, at compile time.
430 20 Could not resolve table name for object ID %d, database ID %d, when compiling foreign key.
431 19 Could not bind foreign key constraint. Too many tables involved in the query.
433 20 Could not find CHECK constraint for '%.*ls', although the table is flagged as having one.
436 20 Could not open referenced table ID %d in database ID %d.
437 20 Could not resolve the referenced column name in table ID %d.
438 20 Could not resolve the referencing column name in table ID %d.
439 20 Could not find FOREIGN KEY constraints for table '%.*ls' in database ID %d although the table is flagged as having them.
441 16 Cannot use the '%ls' function on a remote data source.
505 16 Current user account was invoked with SETUSER. Changing databases is not allowed.
506 16 Invalid ESCAPE character '%.*hs' has been specified in a LIKE predicate.
507 16 Invalid argument %d specified for SET ROWCOUNT.
509 11 User name '%.*ls' not found.
510 16 Cannot create a work table row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.
511 16 Cannot create a row of size %d which is greater than the allowable maximum of %d.
512 16 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.
513 16 A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database '%.*ls', table '%.*ls', column '%.*ls'.
515 16 Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.
516 18 Could not get system date/time.
517 16 Adding a value to a '%ls' column caused overflow.
518 16 Cannot convert data type %ls to %ls.
528 20 System error detected during attempt to use the 'upsleep' system function.
529 16 Explicit conversion from data type %ls to %ls is not allowed.
532 16 The timestamp (changed to %S_TS) shows that the row has been updated by another user.
535 16 Difference of two datetime columns caused overflow at runtime.
536 16 Invalid length parameter passed to the substring function.
538 16 Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator.
542 16 An invalid datetime value was encountered. Value exceeds the year 9999.
544 16 Cannot insert explicit value for identity column in table '%.*ls' when IDENTITY_INSERT is set to OFF.
545 16 Explicit value must be specified for identity column in table '%.*ls' when IDENTITY_INSERT is set to ON.
547 16 %ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.
548 16 Cannot perform direct %ls to range maintained by replication. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.
550 16 The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.
551 16 The checksum has changed to %d. This shows that the row has been updated by another user.
553 16 %hs over nullable side of outer join query on table '%ls'.
555 16 User-defined functions are not yet enabled.
556 16 INSERT EXEC failed because the stored procedure altered the schema of the target table.
601 12 Could not continue scan with NOLOCK due to data movement.
602 21 Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.
604 21 Could not find row in sysobjects for object ID %ld in database '%.*ls'. Run DBCC CHECKTABLE on sysobjects.
605 21 Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.
607 21 Insufficient room was allocated for search arguments in the session descriptor for object '%.*ls'. Only %d search arguments were anticipated.
615 21 Could not find database table ID %d, name '%.*ls'.
617 20 Descriptor for object ID %ld in database ID %d not found in the hash table during attempt to unhash it.
618 21 A varno of %d was passed to the opentable system function. The largest valid value is %d.
623 21 Could not retrieve row from page by RID because logical page %S_PGID is not a data page. %S_RID. %S_PAGE.
624 21 Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. %S_RID.%S_PAGE, DBID %d.
625 21 Could not retrieve row from logical page %S_PGID by RID because the entry in the offset table (%d) for that RID (%d) is less than or equal to 0.
626 16 Cannot use ROLLBACK with a savepoint within a distributed transaction.
627 16 Cannot use SAVE TRANSACTION within a distributed transaction.
628 13 Cannot issue SAVE TRANSACTION when there is no active transaction.
635 20 Process %d tried to remove DES resource lock %S_DES, which it does not hold.
637 20 Index shrink program returned invalid status of 0.
639 21 Could not fetch logical page %S_PGID, database ID %d. The page is not currently allocated.
644 21 Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.
649 21 Could not find the clustered index entry for page %S_PGID, object ID %ld, status 0x%x. Index page %S_PGID, in database '%.*ls', was searched for this entry.
650 16 You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.
651 16 Cannot use %hs granularity hint on table '%.*ls' because locking at the specified granularity is inhibited.
652 16 Index ID %d for table '%.*ls' resides on a read-only filegroup which cannot be modified.
653 20 Two buffers are conflicting for the same keep slot in table '%.*ls'.
654 20 No slots are free to keep buffers for table '%.*ls'.
655 20 Expected to find buffer in keep slot for table '%.*ls'.
666 16 Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key.
701 19 There is insufficient system memory to run this query.
708 10 Warning: Due to low virtual memory, special reserved memory used %d times since startup. Increase virtual memory on server.
802 17 No more buffers can be stolen.
804 20 Could not find buffer 0x%lx holding logical page %S_PGID in the SDES 0x%lx kept buffer pool for object '%.*ls'.
809 20 Buffer 0x%lx, allocation page %S_PGID, in database '%.*ls' is not in allocation buffer pool in PSS (process status structure). Contact Technical Support.
813 20 Logical page %S_PGID in database ID %d is already hashed.
816 20 Process ID %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES. Contact Technical Support.
818 19 There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES. Contact Technical Support.
821 20 Could not unhash buffer at 0x%lx with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE.
822 21 Could not start I/O for request %S_BLKIOPTR.
823 24 I/O error %ls detected during %S_MSG of %S_BUF.
834 21 The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).
840 17 Device '%.*ls' (physical name '%.*ls', virtual device number %d) is not available. Contact the system administrator for assistance.
844 10 Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.
845 17 Time out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d, object ID %d, index ID %d.
901 21 Could not find descriptor for database ID %d, object ID %ld in hash table after hashing it.
903 22 Could not find row in sysindexes for clustered index on system catalog %ld in database ID %d. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.
906 22 Could not locate row in sysobjects for system catalog '%.*ls' in database '%.*ls'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.
911 16 Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.
913 22 Could not find database ID %d. Database may not be activated yet or may be in transition.
916 14 Server user '%.*ls' is not a valid user in database '%.*ls'.
921 14 Database '%.*ls' has not been recovered yet. Wait and try again.
922 14 Database '%.*ls' is being recovered. Waiting until recovery is finished.
923 14 User %d not allowed in database '%.*ls'. Only the owner can access this database.
924 14 Database '%.*ls' is already open and can only have one user at a time.
925 19 Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.
926 14 Database '%.*ls' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
927 14 Database '%.*ls' cannot be opened. It is in the middle of a restore.
929 20 Attempting to close a database that is not already open. Contact Technical Support.
941 14 Cannot open database '%.*ls'. It has not been upgraded to the latest format.
942 14 Database '%.*ls' cannot be opened because it is offline.
943 14 Database '%.*ls' cannot be opened because its version (%d) is later than the current server version (%d).
944 10 Converting database '%.*ls' from version %d to the current version %d.
945 16 Database '%.*ls' cannot be opened because some of the files could not be activated.
946 14 Cannot open database '%.*ls' version %d. Upgrade the database to the latest version.
947 16 Error while closing database '%.*ls' cleanly.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/167898/viewspace-908935/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/167898/viewspace-908935/