SQL Server Error Messages

General Error Message (Volume 3)

The below information can be seen from sys.messages table.

This helps to understand the error falls under which severity.

Msg_Id Severity Message

4002 16 The incoming tabular data stream (TDS) protocol stream is incorrect. The stream ended unexpectedly.
4004 16 Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
4005 16 Cannot update columns from more than one underlying table in a single update call.
4006 16 You cannot delete rows from more than one underlying table in a single delete call.
4007 16 Cannot update or insert column “%.*ls”. It may be an expression.
4008 16 The data types varchar(max), nvarchar(max), varbinary(max), and XML can not be used in the compute clause by client driver versions earlier than SQL Server 2005. Please resubmit the query using a more recent client driver.
4009 16 The incoming tabular data stream (TDS) protocol stream is incorrect. The TDS headers contained errors.
4010 16 The incoming tabular data stream (TDS) protocol stream is incorrect. The Query Notification TDS header contained errors. 4011 16 The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors.
4012 16 An invalid tabular data stream (TDS) collation was
encountered.
4013 16 The incoming tabular data stream (TDS) protocol stream is incorrect. The multiple active result sets (MARS) TDS header is missing. 4014 20 A fatal error occurred while reading the input stream from the network. The session will be terminated.
4015 16 Language requested in login ‘%.*ls’ is not an official name on this SQL Server. Using server-wide default %.*ls instead. 4016 16 Language requested in ‘login %.*ls’ is not an official name on this SQL Server. Using user default %.*ls instead.
4017 16 Neither the language requested in ‘login %.*ls’ nor user default language %.*ls is an official language name on this SQL Server. Using server-wide default %.*ls instead.
4018 16 User default language %.*ls is not an official language name on this SQL Server. Using server-wide default %.*ls instead. 4019 16 Language requested in login ‘%.*ls’ is not an official language name on this SQL Server. Login fails.
4020 16 Default date order ‘%.*ls’ for language %.*ls is invalid. Using mdy instead.
4021 16 Resetting the connection results in a different state than the initial login. The login fails.
4022 16 Bulk load data was expected but not sent. The batch will be terminated.
4027 16 Mount tape for %hs of database ‘%ls’ on tape drive ‘%ls’. 4028 16 End of tape has been reached. Remove tape ‘%ls’ and mount next tape for %hs of database ‘%ls’.
4030 10 The medium on device ‘%ls’ expires on %hs and cannot be overwritten.
4035 10 Processed %d pages for database ‘%ls’, file ‘%ls’ on file %d.
4037 16 The user-specified MEDIANAME “%ls” does not match the MEDIANAME “%ls” of the device “%ls”.
4038 16 Cannot find file ID %d on device ‘%ls’.
4060 11 Cannot open database “%.*ls” requested by the login. The login failed.
4061 11 Neither the database “%.*ls” requested by the login nor the user default database could be opened. The master database is being used instead.
4062 11 Cannot open user default database. Using master database instead.
4063 11 Cannot open database “%.*ls” that was requested by the login. Using the user default database “%.*ls” instead.
4064 11 Cannot open user default database. Login failed.
4065 16 User is trying to use ‘%.*ls’ through ODS, which is not supported any more.
4066 16 Type IDs larger than 65535 cannot be sent to clients shipped in SQL Server 2000 or earlier.
4067 16 User-defined type serialization failed because an invalid cookie was specified.
4068 20 sp_resetconnection was sent as part of a remote procedure call (RPC) batch, but it was not the last RPC in the batch. This connection will be terminated.
4069 16 The final value of the output parameter was null, and could not be sent to a 6.5 client expecting the parameter to be non-nullable. 4070 16 More than 255 columns were specified in the COMPUTE clause, and this metadata cannot be sent to a SQL Server version 6.5 client. 4071 10 The XP callback function ‘%.*ls’ failed in extended
procedure ‘%.*ls’ because it was executed within an INSERT-EXEC statement which does not allow the extended procedure to send information other than result set.
4072 10 The XP callback function ‘%.*ls’ failed in extended
procedure ‘%.*ls’ because the extended procedure is called inside an UDF which doesn’t allow sending data.
4073 16 A return value of data type varchar(max), nvarchar(max), varbinary(max), XML or other large object type can not be returned to client driver versions earlier than SQL Server 2005. Please resubmit the query using a more recent client driver.
4101 16 Aggregates on the right side of an APPLY cannot reference columns from the left side.
4102 15 The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause. 4103 15 “%.*ls”: Temporary views are not allowed.
4104 16 The multi-part identifier “%.*ls” could not be bound. 4105 16 User-defined functions, partition functions, and column references are not allowed in expressions in this context.
4107 16 Inserting into remote tables or views is not allowed by using the BCP utility or by using BULK INSERT.
4108 16 Windowed functions can only appear in the SELECT or ORDER BY clauses.
4109 16 Windowed functions cannot be used in the context of another windowed function or aggregate.
4110 16 The argument type “%s” is invalid for argument %d of “%s”. 4111 16 The CREATE SCHEMA statement should be followed by a name or authorization keyword.
4112 16 The ranking function “%.*ls” must have an ORDER BY clause. 4113 16 “%.*ls” is not a valid windowing function, and cannot be used with the OVER clause.
4114 16 The function ‘%.*ls’ takes exactly %d argument(s).
4115 16 The reference to column “%.*ls” is not allowed in the argument of the TOP clause. Only references to columns at an outer scope or standalone expressions and subqueries are allowed here.
4116 16 The function ‘ntile’ takes only a positive int or bigint expression as its input.
4117 16 Cannot load computed column definitions for table “%.*ls” because of too much data definition language (DDL) activity. 4118 16 An invalid expression was specified in the FOR UPDATE clause.
4119 16 Default values cannot be assigned to property setters of columns with a user-defined type.
4120 16 A user-defined function name cannot be prefixed with a database name in this context.
4121 16 Cannot find either column “%.*ls” or the user-defined function or aggregate “%.*ls”, or the name is ambiguous.
4122 16 Remote table-valued function calls are not allowed.
4124 16 The parameters supplied for the batch are not valid. 4126 16 No full-text indexed columns were found.
4127 16 At least one of the arguments to COALESCE must be a typed NULL.
4128 16 An internal error occurred during remote query execution. Contact your SQL Server support professional and provide details about the query you were trying to run.
4129 16 The inline function “%.*ls” cannot take correlated
parameters or subqueries because it uses a full-text operator. 4130 16 A duplicate hint was specified for the BULK rowset. 4131 16 A compile-time literal value is specified more than once for the variable “%.*ls” in one or more OPTIMIZE FOR clauses.
4132 16 The value specified for the variable “%.*ls” in the OPTIMIZE FOR clause could not be implicitly converted to that variable’s type. 4133 16 Only a scalar expression may be specified as the argument to the RETURN statement.
4134 16 Metadata stored on disk for computed column ‘%.*ls’ in table ‘%.*ls’ did not match the column definition. In order to avoid possible index corruption, please drop and recreate this computed column. 4135 16 Synonym ‘%.*ls’ is defined over queue ‘%.*ls’. Synonyms on queues are not allowed.
4136 16 The hint ‘%.*ls’ cannot be used with the hint ‘%.*ls’. 4137 16 A format file cannot be specified together with SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB option.
4138 16 Conflicting locking hints are specified for table “%.*ls”. This may be caused by a conflicting hint specified for a view. 4139 16 Cannot process the query because it references the common language runtime (CLR) table-valued function “%.*ls” with a hint through view “%.*ls”.
4140 15 The READCOMMITTEDLOCK lock hint is not allowed on the target table of an INSERT statement.
4141 16 Nested user-defined type updates are not allowed.
4142 16 Aggregates are not allowed in the RECEIVE list.
4143 16 The bulk openrowset provider is not a valid target for %.*ls.
4144 16 The hint ‘%.*ls’ is not allowed when inserting into remote tables.
4145 15 An expression of non-boolean type specified in a context where a condition is expected, near ‘%.*ls’.
4146 16 Statistics can only be created on columns.
4147 15 The query uses non-ANSI outer join operators (“*=” or “=*”). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.
4148 16 XML methods are not allowed in a GROUP BY clause.
4150 16 Hints are not allowed on recursive common table expression (CTE) references. Consider removing hint from recursive CTE reference ‘%.*ls’.
4152 16 Type “%.*ls” is not a user-defined type.
4153 16 Cannot treat data type “%ls” as data type “%ls”.
4154 16 UNNEST can only take an expression of type multiset. 4155 15 The SELECT list for the nested INSERT statement can only contain one item.
4156 16 The target of nested insert, nested update, or nested delete must be of type multiset.
4157 16 “%.*ls” is not a valid property, field, or method.
4158 16 The field “%.*ls” is referenced more than once in the set list, either directly or through a property.
4159 16 Delayed UDT instances require local base table column as an argument.
4160 16 Could not find suitable key in table ‘%.*ls’ for use in delayed UDT fetching.
4161 16 Only user-defined types are allowed in delayed UDT fetching. 4162 16 A PROB_MATCH table can only be used inside of a PROB_MATCH query.
4163 16 A GROUP BY clause is required in a PROB_MATCH query. 4164 16 A GROUP BY clause in a PROB_MATCH query can only have key columns, and needs to include all the key columns.
4165 16 The score override argument, if present in one of the subqueries, must be present in all subqueries and must be the same constant and variable.
4166 16 Invalid PROB_MATCH subquery.
4167 16 Multiple PROB_MATCH subqueries can only refer to the same base table.
4168 16 Invalid PROB_MATCH project item in the PROB_MATCH SELECT list.
4169 16 Applying TREAT more than once to the same expression is not allowed in a full-text property reference.
4170 16 The (ANY) specification can only be applied to expressions of type multiset.
4171 16 Alias was not specified for an aggregate in the PROB_MATCH SELECT list.
4172 16 Incorrect use of full-text %s.
4173 16 “%.*s” is not a valid scoring function name.
4174 16 Delayed UDT instantiation fetch value query may only reference column of a large object or large value type.
4175 16 Nested updates cannot be performed on UDT types that are not Format.Structured.
4176 16 Too many parameters were specified for FULLTEXTTABLE of type “Simple”. The maximum number of parameters is %d.
4177 16 The FROM clause of a PROB_MATCH query must consist of a single derived table.
4202 16 BACKUP LOG is not possible because bulk logged changes exist in the database and one or more filegroups are unavailable. 4208 16 The statement %hs is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
4212 16 Cannot back up the log of the master database. Use BACKUP DATABASE instead.
4214 16 BACKUP LOG cannot be performed because there is no current database backup.
4215 10 The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.
4217 10 BACKUP LOG cannot modify the database because the database is read-only. The backup will continue, although subsequent backups will duplicate the work of this backup.
4218 16 Bulk-logged operations exist in the database. Perform a BACKUP LOG.
4302 16 The option “%ls” conflicts with online restore. Remove the conflicting option and reissue the command.
4303 16 The roll forward start point is now at log sequence number (LSN) %.*s. Additional roll forward past LSN %.*s is required to complete the restore sequence.
4305 16 The log in this backup set begins at LSN %.*ls, which is too recent to apply to the database. An earlier log backup that includes LSN %.*ls can be restored.
4307 16 The online restore to database ‘%ls’ failed. It may be appropriate to perform an offline restore instead. To force an offline restore, first take the database offline using the ALTER DATABASE statement. 4308 10 The online restore is complete, but WITH NORECOVERY was specified. Use RESTORE WITH RECOVERY to bring affected data online. 4309 16 The state of file “%ls” prevents restoring individual pages. Only a file restore is currently possible.
4310 16 RESTORE PAGE is not allowed on file “%ls” because the file is not online.
4311 16 RESTORE PAGE is not allowed from backups taken with earlier versions of SQL Server.
4312 16 This log cannot be restored because a gap in the log chain was created. Use more recent data backups to bridge the gap. 4315 10 Some files still require more restore steps before the online restore sequence can be completed.
4318 16 File ‘%ls’ has been rolled forward to LSN %.*ls. This log terminates at LSN %.*ls, which is too early to apply the WITH RECOVERY option. Reissue the RESTORE LOG statement WITH NORECOVERY.
4319 16 A previous restore operation was interrupted and did not complete processing on file ‘%ls’. Either restore the backup set that was interrupted or restart the restore sequence.
4320 16 The file “%ls” was not fully restored by a database or file restore. The entire file must be successfully restored before applying this backup set.
4322 10 This backup set contains records that were logged before the designated point in time. The database is being left in the restoring state so that more roll forward can be performed.
4323 16 The database is marked suspect. Transaction logs cannot be restored. Use RESTORE DATABASE to recover the database.
4326 16 The log in this backup set terminates at LSN %.*ls, which is too early to apply to the database. A more recent log backup that includes LSN %.*ls can be restored.
4327 16 The log in this backup set contains bulk-logged changes. Point-in-time recovery was inhibited. The database has been rolled forward to the end of the log.
4328 16 The file “%ls” is missing. Roll forward stops at log sequence number %.*ls. The file is created at log sequence number (LSN) %.*ls, dropped at LSN %.*ls. Restore the transaction log beyond the point in time when the file was dropped, or restore data to be consistent with rest of the database.
4329 10 This log file contains records logged before the designated mark. The database is being left in the Restoring state so you can apply another log file.
4330 16 This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backups that have brought the database to a particular recovery point. Find a compatible backup to restore, or restore the rest of the database to match a recovery point within this backup set, which will restore the database to a different point in time. For more information about recovery paths, see SQL Server Books Online. 4331 16 The database cannot be recovered because the files have been restored to inconsistent points in time.
4332 16 RESTORE LOG has been halted. To use the database in its current state, run RESTORE DATABASE %ls WITH RECOVERY.
4333 16 The database cannot be recovered because the log was not restored.
4334 16 The named mark does not identify a valid LSN.
4335 16 The specified STOPAT time is too early. All or part of the database is already rolled forward beyond that point.
4336 16 The filegroup “%ls” has been dropped and cannot be restored into the online database.
4337 16 The file “%ls” has been dropped and cannot be restored into the online database.
4338 16 The STOPAT clause specifies a point too early to allow this backup set to be restored. Choose a different stop point or use RESTORE DATABASE WITH RECOVERY to recover at the current point.
4339 10 This RESTORE statement successfully performed some actions, but the database could not be brought online because one or more RESTORE steps are needed. Previous messages indicate reasons why recovery cannot occur at this point.
4340 16 The point-in-time clause of this RESTORE statement is restricted for use by RESTORE LOG statements only. Omit the clause or use a clause that includes a timestamp.
4341 16 This log backup contains bulk-logged changes. It cannot be used to stop at an arbitrary point in time.
4342 16 Point-in-time recovery is not possible unless the primary filegroup is part of the restore sequence. Omit the point-in-time clause or restore the primary filegroup.
4343 16 The database has been rolled forward to the end of this backup set and beyond the specified point in time. RESTORE WITH RECOVERY can be used to accept the current recovery point.
4344 16 RESTORE PAGE is not allowed on read-only databases or filegroups.
4345 10 Problems recording information in the msdb..suspect_pages table were encountered. This error does not interfere with any activity except maintenance of the suspect_pages table. Check the error log for more information.
4346 16 RESTORE PAGE is not allowed with databases that use the simple recovery model.
4347 16 The current restore sequence was previously interrupted during the transition to the online state. RESTORE DATABASE WITH RECOVERY can be used to complete the transition to online.
4348 16 The online restore to database ‘%ls’ failed. It may be appropriate to perform an offline restore instead. An offline restore is initiated by using BACKUP LOG WITH NORECOVERY.
4349 16 The log in this backup set begins at LSN %.*ls, which is too recent to apply to the database. This restore sequence needs to initialize the log to start at LSN %.*ls. Reissue the RESTORE LOG statement using an earlier log backup.
4350 16 The list of pages provided with the RESTORE PAGE statement is incorrectly formatted. Prior to the problem %d pages were correctly identified. The problem was hit at character offset %d. Check that all pages are identified by numeric : pairs with commas separating each pair. For example: PAGE=’1:57,2:31′.
4351 16 Backups taken on earlier versions of SQL Server are not supported by fn_dump_dblog.
4354 10 The file ‘%.*ls’ of restored database ‘%ls’ is being left in the defunct state because the database is being upgraded from a prior version. Piecemeal restore is not supported when an upgrade is involved. 4403 16 Cannot update the view or function “%.*ls” because it contains aggregates or a DISTINCT clause.
4404 16 View or function ‘%.*ls’ is not updatable because the definition contains the DISTINCT clause.
4405 16 View or function ‘%.*ls’ is not updatable because the modification affects multiple base tables.
4406 16 Update or insert of view or function ‘%.*ls’ failed because it contains a derived or constant field.
4408 19 Too many tables. The query and the views or functions in it exceed the limit of %d tables. Revise the query to reduce the number of tables.
4413 16 Could not use view or function ‘%.*ls’ because of binding errors.
4414 16 Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (%d) was exceeded. 4415 16 View ‘%.*ls’ is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times in the resulting query. 4416 16 UNION ALL view ‘%.*ls’ is not updatable because the
definition contains a disallowed construct.
4417 16 Derived table ‘%.*ls’ is not updatable because the
definition contains a UNION operator.
4418 16 Derived table ‘%.*ls’ is not updatable because it contains aggregates.
4419 16 Derived table ‘%.*ls’ is not updatable because the
definition contains the DISTINCT clause.
4420 16 Derived table ‘%.*ls’ is not updatable because the
modification affects multiple base tables.
4421 16 Derived table ‘%.*ls’ is not updatable because a column of the derived table is derived or constant.
4422 16 View ‘%.*ls’ has an INSTEAD OF UPDATE trigger and cannot be a target of an UPDATE FROM statement.
4423 16 View ‘%.*ls’ has an INSTEAD OF DELETE trigger and cannot be a target of a DELETE FROM statement.
4424 16 Joined tables cannot be specified in a query containing outer join operators. View or function ‘%.*ls’ contains joined tables. 4425 16 Cannot specify outer join operators in a query containing joined tables. View or function ‘%.*ls’ contains outer join operators. 4426 16 View ‘%.*ls’ is not updatable because the definition contains a UNION operator.
4427 16 Cannot update the view “%.*ls” because it or a view it references was created with WITH CHECK OPTION and its definition contains the TOP clause.
4429 16 View or function ‘%.*ls’ contains a self-reference. Views or functions cannot reference themselves directly or indirectly. 4430 10 Warning: Index hints supplied for view ‘%.*ls’ will be ignored.
4431 16 Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a timestamp column.
4432 16 Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a DEFAULT constraint.
4433 16 Cannot INSERT into partitioned view ‘%.*ls’ because table ‘%.*ls’ has an IDENTITY constraint.
4434 16 Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has an INSTEAD OF trigger.
4435 16 Partitioned view ‘%.*ls’ is not updatable because a value was not specified for partitioning column ‘%.*ls’.
4436 16 UNION ALL view ‘%.*ls’ is not updatable because a
partitioning column was not found.
4437 16 Partitioned view ‘%.*ls’ is not updatable as the target of a bulk operation.
4438 16 Partitioned view ‘%.*ls’ is not updatable because it does not deliver all columns from its member tables.
4439 16 Partitioned view ‘%.*ls’ is not updatable because the source query contains references to partition table ‘%.*ls’.
4440 16 UNION ALL view ‘%.*ls’ is not updatable because a primary key was not found on table ‘%.*ls’.
4441 16 Partitioned view ‘%.*ls’ is not updatable because the table ‘%.*ls’ has an index on a computed column.
4442 16 UNION ALL view ‘%.*ls’ is not updatable because base table ‘%.*ls’ is used multiple times.
4443 16 UNION ALL view ‘%.*ls’ is not updatable because column ‘%.*ls’ of base table ‘%.*ls’ is used multiple times.
4444 16 UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not included in the union result.
4445 16 UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not unioned with primary keys of preceding tables. 4446 16 Cannot update the UNION ALL view “%.*ls” because the definition of column “%.*ls” of view “%.*ls” is used by another view column. 4447 16 View ‘%.*ls’ is not updatable because the definition contains a set operator.
4448 16 Cannot INSERT into partitioned view ‘%.*ls’ because values were not supplied for all columns.
4449 16 Using defaults is not allowed in views that contain a set operator.
4450 16 Cannot update partitioned view ‘%.*ls’ because the
definition of the view column ‘%.*ls’ in table ‘%.*ls’ has a IDENTITY constraint.
4451 16 Views referencing tables on multiple servers are not updatable in the edition of this SQL Server instance ‘%.*ls’. See books online for more details on feature support in different SQL Server editions. 4452 16 Cannot UPDATE partitioning column ‘%.*ls’ of view ‘%.*ls’ because the table ‘%.*ls’ has a CASCADE DELETE or CASCADE UPDATE constraint. 4453 16 Cannot UPDATE partitioning column ‘%.*ls’ of view ‘%.*ls’ because the table ‘%.*ls’ has a INSERT, UPDATE or DELETE trigger. 4454 16 Cannot update the partitioned view “%.*ls” because the partitioning columns of its member tables have mismatched types. 4456 16 The partitioned view “%.*ls” is not updatable because one or more of the non-partitioning columns of its member tables have mismatched types.
4457 16 The attempted insert or update of the partitioned view failed because the value of the partitioning column does not belong to any of the partitions.
4502 16 View or function ‘%.*ls’ has more column names specified than columns defined.
4503 16 Could not create schemabound %S_MSG ‘%.*ls’ because it references an object in another database.
4504 16 Could not create %S_MSG ‘%.*ls’ because user defined type ‘%.*ls’ does not exist in the target database ‘%.*ls’.
4505 16 CREATE VIEW failed because column ‘%.*ls’ in view ‘%.*ls’ exceeds the maximum of %d columns.
4506 16 Column names in each view or function must be unique. Column name ‘%.*ls’ in view or function ‘%.*ls’ is specified more than once. 4508 16 Views or functions are not allowed on temporary tables. Table names that begin with ‘#’ denote temporary tables.
4510 16 Could not perform CREATE VIEW because WITH %ls was specified and the view is not updatable.
4511 16 Create View or Function failed because no column name was specified for column %d.
4512 16 Cannot schema bind %S_MSG ‘%.*ls’ because name ‘%.*ls’ is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.
4513 16 Cannot schema bind %S_MSG ‘%.*ls’. ‘%.*ls’ is not schema bound.
4514 16 CREATE FUNCTION failed because a column name is not
specified for column %d.
4515 16 CREATE FUNCTION failed because column ‘%.*ls’ in function ‘%.*ls’ exceeds the maximum of %d columns.
4516 16 Cannot schema bind function ‘%.*ls’ because it contains an EXECUTE statement.
4517 16 Service queue object cannot be used in schemabinding expressions. ‘%.*ls’ is a service queue.
4519 16 Cannot %S_MSG %S_MSG ‘%.*ls’ on view ‘%.*ls’ because it is a system generated view that was created for optimization purposes. 4520 16 Cannot disable index on view ‘%.*ls’ because it is a system generated view that was created for optimization purposes.
4521 16 Cannot use object ‘%.*ls’ with autodrop object attribute in schemabinding expressions because it is a system generated view that was created for optimization purposes.
4522 16 Cannot alter view ‘%.*ls’ because it is a system generated view that was created for optimization purposes.
4523 16 Cannot create trigger on view ‘%.*ls’ because it is a system generated view that was created for optimization purposes.
4602 14 Only members of the sysadmin role can grant or revoke the CREATE DATABASE permission.
4604 16 There is no such user or group ‘%.*ls’ or you do not have permission.
4606 16 Granted or revoked privilege %ls is not compatible with object.
4610 16 You can only grant or revoke permissions on objects in the current database.
4611 16 To revoke or deny grantable privileges, specify the CASCADE option.
4613 16 Grantor does not have GRANT permission.
4615 16 Invalid column name ‘%.*ls’.
4616 16 You cannot perform this operation for the resource database. 4617 16 Cannot grant, deny or revoke permissions to or from special roles.
4618 16 You do not have permission to use %.*ls in the AS clause. 4619 16 CREATE DATABASE permission can only be granted in the master database.
4620 16 All permissions in a grant/deny/revoke statement should be at the same scope (e.g., server or database)
4621 16 Permissions at the server scope can only be granted when the current database is master
4622 16 Permissions at the server scope can only be granted to logins
4623 16 The all permission has been deprecated and is not available for this class of entity
4624 16 Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
4625 16 There is no such server principal %.*s or you do not have permission.
4627 16 Cannot grant, deny, or revoke the connect database
permission to roles and application roles.
4628 16 The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. 4629 16 Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.
4701 16 Cannot find the object “%.*ls” because it does not exist or you do not have permissions.
4707 16 Could not truncate object ‘%.*ls’ because it or one of its indexes resides on a READONLY filegroup ‘%.*ls’.
4708 16 Could not truncate object ‘%.*ls’ because it is not a table. 4709 16 You are not allowed to truncate the system table ‘%.*ls’. 4710 16 Could not truncate object ‘%.*ls’ because it or one of its indexes resides on an offline filegroup ‘%.*ls’.
4711 16 Cannot truncate table ‘%.*ls’ because it is published for replication.
4712 16 Cannot truncate table ‘%.*ls’ because it is being referenced by a FOREIGN KEY constraint.
4801 16 Insert bulk is not supported over this access protocol. 4802 16 The SINGLE_LOB, SINGLE_CLOB, and SINGLE_NCLOB options are mutually exclusive with all other options.
4803 21 The bulk copy (bcp) client has sent a row length of %d. This is not a valid size. The maximum row size is %d. Use a supported client application programming interface (API).
4804 21 While reading current row from host, a premature
end-of-message was encountered–an incoming data stream was interrupted when the server expected to see more data. The host program may have terminated. Ensure that you are using a supported client application programming interface (API).
4805 17 The front-end tool you are using does not support bulk load from host. Use the supported tools for this command.
4806 16 SINGLE_CLOB requires a double-byte character set (DBCS) (char) input file. The file specified is Unicode.
4807 21 The bulk copy (bcp) client sent a row length of %d. This size is not valid. The minimum row size is %d. Use a supported client application programming interface (API).
4808 16 Bulk copy operations cannot trigger bulk load statements. 4809 16 SINGLE_NCLOB requires a UNICODE (widechar) input file. The file specified is not Unicode.
4810 16 Expected the TEXT token in data stream for bulk copy of text or image data.
4811 16 Expected the column offset in data stream for bulk copy of text or image data.
4812 16 Expected the row offset in data stream for bulk copy of text or image data.
4813 16 Expected the text length in data stream for bulk copy of text, ntext, or image data.
4814 16 Bulk copy into a partitioned table is not supported for down-level clients.
4815 16 Received an invalid column length from the bcp client for colid %d.
4816 16 Invalid column type from bcp client for colid %d.
4817 16 Could not bulk load. The sorted column ‘%.*ls’ is not valid. The ORDER hint is ignored.
4818 16 Could not bulk load. The sorted column ‘%.*ls’ was specified more than once. The ORDER hint is ignored.
4819 16 Cannot bulk load. The bulk data stream was incorrectly specified as sorted. Sort order is incorrect for the following two rows: key of first row: %s, key of second row: %s.
4820 16 Cannot bulk load. Unknown version of format file “%s”. 4821 16 Cannot bulk load. Error reading the number of columns from the format file “%s”.
4822 16 Cannot bulk load. Invalid number of columns in the format file “%s”.
4823 16 Cannot bulk load. Invalid column number in the format file “%s”.
4824 16 Cannot bulk load. Invalid data type for column number %d in the format file “%s”.
4825 16 Cannot bulk load. Invalid prefix for column number %d in the format file “%s”.
4826 16 Cannot bulk load. Invalid column length for column number %d in the format file “%s”.
4827 16 Cannot bulk load. Invalid column terminator for column number %d in the format file “%s”.
4828 16 Cannot bulk load. Invalid destination table column number for source column %d in the format file “%s”.
4829 16 Cannot bulk load. Error reading the destination table column name for source column %d in the format file “%s”.
4830 10 Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.
4831 10 Bulk load: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.
4832 16 Bulk load: An unexpected end of file was encountered in the data file.
4833 16 Bulk load: Version mismatch between the provider dynamic link library and the server executable.
4834 16 You do not have permission to use the bulk load statement. 4835 16 Bulk copying into a table with computed columns is not supported for downlevel clients.
4836 10 Warning: Table “%.*s” is published for merge replication. Reinitialize affected subscribers or execute sp_addtabletocontents to ensure that data added is included in the next synchronization.
4837 16 Cannot bulk copy into a table “%.*s” that is enabled for immediate-updating subscriptions.
4838 16 The bulk data source does not support the SQLNUMERIC or SQLDECIMAL data types.
4839 16 Cannot perform the bulk load. Invalid collation name for source column %d in the format file “%s”.
4840 16 The bulk data source provider string has an invalid %ls property value %ls.
4841 16 The data source name is not a simple object name.
4842 16 The required FormatFile property is missing from the provider string of the server.
4843 16 The bulk data source provider string has a syntax error (‘%lc’) near character position %d.
4844 16 The bulk data source provider string has an unsupported property name (%ls).
4845 16 The bulk data source provider string has a syntax error near character position %d. Expected ‘%lc’, but found ‘%lc’.
4846 16 The bulk data provider failed to allocate memory.
4847 16 Bulk copying into a table with bigint columns is not supported for versions earlier than SQL Server 2000.
4848 16 Bulk copying into a table with sql_variant columns is not supported for versions earlier than SQL Server 2000.
4855 16 Line %d in format file “%ls”: unexpected element “%ls”. 4856 16 Line %d in format file “%ls”: unexpected info item.
4857 16 Line %d in format file “%ls”: Attribute “%ls” could not be specified for this type.
4858 16 Line %d in format file “%ls”: bad value %ls for attribute “%ls”.
4859 16 Line %d in format file “%ls”: required attribute “%ls” is missing.
4860 16 Cannot bulk load. The file “%ls” does not exist.
4861 16 Cannot bulk load because the file “%ls” could not be opened. Operating system error code %ls.
4862 16 Cannot bulk load because the file “%ls” could not be read. Operating system error code %ls.
4863 16 Bulk load data conversion error (truncation) for row %d, column %d (%ls).
4864 16 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row %d, column %d (%ls). 4865 16 Cannot bulk load because the maximum number of errors (%d) was exceeded.
4866 16 The bulk load failed. The column is too long in the data file for row %d, column %d. Verify that the field terminator and row terminator are specified correctly.
4867 16 Bulk load data conversion error (overflow) for row %d, column %d (%ls).
4868 16 The bulk load failed. The codepage “%d” is not installed. Install the codepage and run the command again.
4869 16 The bulk load failed. Unexpected NULL value in data file row %d, column %d. The destination column (%ls) is defined as NOT NULL. 4870 16 Cannot bulk load because of an error writing file “%ls”. Operating system error code %ls.
4871 16 Bulk load error while attempting to log errors.
4872 16 Line %d in format file “%ls”: duplicate element id “%ls”. 4873 16 Line %d in format file “%ls”: referencing non-existing element id “%ls”.
4874 16 Line %d in format file “%ls”: duplicate element id reference “%ls”.
4875 16 Only one instance of the BULK rowset provider can be used per query.
4876 16 Reading from DTS buffer timed out.
4877 16 Error parsing DTS stream when reading row %d, column %d. 4880 16 Cannot bulk load. When you use the FIRSTROW and LASTROW parameters, the value for FIRSTROW cannot be greater than the value for LASTROW.
4881 10 Note: Bulk Insert through a view may result in base table default values being ignored for NULL columns in the data file. 4882 16 Cannot bulk load. A prefix length, field length, or
terminator is required for the source column %d in the format file “%s”. 4883 16 The XML reader returned 0x%08X for the info item starting near line %d column %d in format file “%ls”.
4884 16 Unknown error near info item starting near line %d column %d in format file “%ls”.
4885 16 Cannot open file “%ls”. A Windows NT Integrated Security login is required.
4886 16 Cannot open the file “%ls”. Operating system error: %ls 4887 16 Cannot open the file “%ls”. Only disk files are supported. 4888 16 Cannot open the file “%ls”. The bulkadmin role membership is required.
4889 16 Cannot open the file “%ls”. A unicode byte-order mark is missing.
4890 16 Insert bulk is not supported in showplan mode.
4891 16 Insert bulk failed due to a schema change of the target table.
4892 16 Bulk insert failed due to a schema change of the target table.
4893 16 Could not bulk load because SSIS file mapping object ‘%ls’ could not be opened. Operating system error code %ls. Make sure you are accessing a local server via Windows security.
4894 21 COLMETADATA must be present when using bcp.
4895 21 Unicode data is odd byte size for column %d. Should be even byte size.
4896 16 Invalid column value from bcp client for colid %d.
4901 16 ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column ‘%.*ls’ cannot be added to non-empty table ‘%.*ls’ because it does not satisfy these conditions.
4902 16 Cannot find the object “%.*ls” because it does not exist or you do not have permissions.
4903 10 Warning: The specified partition %d for the table ‘%.*ls’ was ignored in ALTER TABLE SWITCH statement because the table is not partitioned.
4904 16 ALTER TABLE SWITCH statement failed. The specified partition %d of target table ‘%.*ls’ must be empty.
4905 16 ALTER TABLE SWITCH statement failed. The target table ‘%.*ls’ must be empty.
4906 16 ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ is %S_MSG partitioned while index ‘%.*ls’ is %S_MSG partitioned.
4907 16 ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ has %d partitions while index ‘%.*ls’ has %d partitions.
4908 16 ‘%ls’ statement failed. The range boundary values used to partition the %S_MSG ‘%.*ls’ are different from the range boundary values used for index ‘%.*ls’.
4909 16 Cannot alter ‘%.*ls’ because it is not a table.
4911 16 Cannot specify a partitioned table without partition number in ALTER TABLE SWITCH statement. The table ‘%.*ls’ is partitioned. 4912 16 ‘%ls’ statement failed. The columns set used to partition the %S_MSG ‘%.*ls’ is different from the column set used to partition index ‘%.*ls’.
4913 16 ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has clustered index ‘%.*ls’ while the table ‘%.*ls’ does not have clustered index.
4914 16 The ALTER TABLE SWITCH statement failed. The table “%.*ls” has a disabled clustered index.
4915 16 ‘%ls’ statement failed. The parameter type of the partition function used to partition the %S_MSG ‘%.*ls’ is different from the parameter type of the partition function used to partition index ‘%.*ls’. 4916 16 Could not enable or disable the constraint. See previous errors.
4917 16 Constraint ‘%.*ls’ does not exist.
4918 16 ALTER TABLE SWITCH statement failed because the table ‘%.*ls’ has fulltext index on it.
4919 16 PERSISTED attribute cannot be altered on column ‘%.*ls’ because this column is not computed.
4920 16 ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.
4921 16 ALTER TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’.
4922 16 %ls %.*ls failed because one or more objects access this column.
4923 16 ALTER TABLE DROP COLUMN failed because ‘%.*ls’ is the only data column in table ‘%.*ls’. A table must have at least one data column. 4924 16 %ls failed because column ‘%.*ls’ does not exist in table ‘%.*ls’.
4925 16 ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table ‘%.*ls’ with ROWGUIDCOL property. 4926 16 ALTER TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table ‘%.*ls’ with ROWGUIDCOL property. 4927 16 Cannot alter column ‘%.*ls’ to be data type %.*ls.
4928 16 Cannot alter column ‘%.*ls’ because it is ‘%ls’.
4929 16 Cannot alter the %S_MSG ‘%.*ls’ because it is being
published for replication.
4933 16 Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column depends on a non-schemabound object.
4934 16 Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column does user or system data access.
4935 16 ALTER TABLE ADD COLUMN cannot specify a FILESTREAM filegroup that differs from the existing one.
4936 16 Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column is non-deterministic.
4937 16 ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has view ‘%.*ls’ with schemabinding.
4938 16 ALTER TABLE SWITCH statement failed. Partition %d of %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’.
4939 16 ALTER TABLE SWITCH statement failed. %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’.
4940 16 ALTER TABLE SWITCH statement failed. %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’ and %S_MSG ‘%.*ls’ is in filegroup ‘%.*ls’. 4941 16 ALTER TABLE SWITCH statement failed because the table ‘%.*ls’ is marked for replication.
4942 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ at ordinal %d in table ‘%.*ls’ has a different name than the column ‘%.*ls’ at the same ordinal in table ‘%.*ls’.
4943 16 ALTER TABLE SWITCH statement failed because table ‘%.*ls’ has %d columns and table ‘%.*ls’ has %d columns.
4944 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ has data type %s in source table ‘%.*ls’ which is different from its type %s in target table ‘%.*ls’.
4945 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*ls’. 4946 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same persistent attribute in tables ‘%.*ls’ and ‘%.*ls’. 4947 16 ALTER TABLE SWITCH statement failed. There is no identical index in source table ‘%.*ls’ for the index ‘%.*ls’ in target table ‘%.*ls’ .
4948 16 ALTER TABLE SWITCH statement failed. The source table ‘%.*ls’ is in database ‘%.*ls’ while the target table ‘%.*ls’ is in database ‘%.*ls’.
4949 16 ALTER TABLE SWITCH statement failed because the object ‘%.*ls’ is not a user defined table.
4950 16 ALTER TABLE SWITCH statement failed because partition number %d does not exist in table ‘%.*ls’.
4951 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same ansi trimming semantics in tables ‘%.*ls’ and ‘%.*ls’.
4952 16 ALTER TABLE SWITCH statement failed because table ‘%.*ls’ is created using FILESTREAM filegroup.
4953 16 ALTER TABLE SWITCH statement failed. The columns set used to partition the table ‘%.*ls’ is different from the column set used to partition the table ‘%.*ls’.
4954 16 ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has inline limit of %d for text in row data which is different from value %d used by table ‘%.*ls’.
4955 16 ALTER TABLE SWITCH statement failed. The source table ‘%.*ls’ and target table ‘%.*ls’ are same.
4956 16 ALTER TABLE SWITCH statement failed because the table ‘%.*ls’ is not RANGE partitioned.
4957 16 ‘%ls’ statement failed because the expression identifying partition number for the %S_MSG ‘%.*ls’ is not of integer type. 4958 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same ROWGUIDCOL property in tables ‘%.*ls’ and ‘%.*ls’. 4959 16 ALTER TABLE SWITCH statement failed. Partition %d of %S_MSG ‘%.*ls’ has TEXT filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ has TEXT filegroup ‘%.*ls’.
4960 16 ALTER TABLE SWITCH statement failed. Check constraint ‘%.*ls’ in source table ‘%.*ls’ is NOCHECK constraint but the matching check constraint ‘%.*ls’ in target table ‘%.*ls’ is CHECK.
4961 16 ALTER TABLE SWITCH statement failed. Column ‘%.*ls’ in table ‘%.*ls’ is nullable and it is not nullable in ‘%.*ls’.
4962 16 ALTER TABLE SWITCH statement failed. Partition %d in table ‘%.*ls’ is not a range partition.
4963 16 ALTER TABLE SWITCH statement failed. Partition %d is not valid for table ‘%.*ls’.
4964 16 ALTER TABLE SWITCH statement failed. Table ‘%.*ls’ has RULE constraint ‘%.*ls’. SWITCH is not allowed on tables with RULE constraints. 4965 16 ALTER TABLE SWITCH statement failed. Column ‘%.*ls’ in table ‘%.*ls’ is computed column but the same column in ‘%.*ls’ is not computed. 4966 16 ALTER TABLE SWITCH statement failed. Computed column ‘%.*ls’ defined as ‘%.*ls’ in table ‘%.*ls’ is different from the same column in table ‘%.*ls’ defined as ‘%.*ls’.
4967 16 ALTER TABLE SWITCH statement failed. SWITCH is not allowed because source table ‘%.*ls’ contains primary key for constraint ‘%.*ls’. 4968 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has foreign key for constraint ‘%.*ls’ but source table ‘%.*ls’ does not have corresponding key.
4969 16 ALTER TABLE SWITCH statement failed. Foreign key constraint ‘%.*ls’ is disabled in source table ‘%.*ls’ and the corresponding constraint ‘%.*ls’ is enabled in target table ‘%.*ls’. The source table constraint must be enabled.
4970 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a table level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint.
4971 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a column level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint.
4972 16 ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table ‘%.*ls’ allows values that are not allowed by check constraints or partition function on target table ‘%.*ls’. 4973 16 ALTER TABLE SWITCH statement failed. Range defined by partition %d in table ‘%.*ls’ is not a subset of range defined by partition %d in table ‘%.*ls’.
4974 16 ALTER TABLE SWITCH statement failed. Foreign key constraint ‘%.*ls’ is NOCHECK in source table ‘%.*ls’ and the corresponding constraint ‘%.*ls’ is CHECK in target table ‘%.*ls’. The source table constraint must be in CHECK.
4975 16 ALTER TABLE SWITCH statement failed. Check constraint ‘%.*ls’ in source table ‘%.*ls’ and check constraint ‘%.*ls’ in target table ‘%.*ls’ have different ‘Not For Replication’ settings.
4976 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a check constraint ‘%.*ls’ on an XML column, but the source table ‘%.*ls’ does not have an identical check constraint.
4977 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a check constraint ‘%.*ls’ on a CLR UDT column, but the source table ‘%.*ls’ does not have an identical check constraint.
4978 16 ALTER TABLE SWITCH statement failed. The partition %d in table ‘%.*ls’ resides in a read-only filegroup ‘%.*ls’.
4979 16 ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ resides in a readonly filegroup ‘%.*ls’.
4980 16 ALTER TABLE SWITCH statement failed. The lobdata of partition %d in table ‘%.*ls’ resides in a readonly filegroup ‘%.*ls’. 4981 16 ALTER TABLE SWITCH statement failed. The lobdata of table ‘%.*ls’ resides in a readonly filegroup ‘%.*ls’.
4982 16 ALTER TABLE SWITCH statement failed. Check constraints of source table ‘%.*ls’ allow values that are not allowed by range defined by partition %d on target table ‘%.*ls’.
4983 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has an XML index ‘%.*ls’ on it. Only source table can have XML indexes in the ALTER TABLE SWITCH statement.
4984 16 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ and source table ‘%.*ls’ have different values for table option ‘vardecimal storage format’.
4985 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same nullability attribute in tables ‘%.*ls’ and ‘%.*ls’. 4986 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same .NET user defined type in tables ‘%.*ls’ and ‘%.*ls’. 4987 16 ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same XML Schema Collection in tables ‘%.*ls’ and ‘%.*ls’. 4988 16 Cannot persist computed column ‘%.*ls’. Underlying object ‘%.*ls’ has a different owner than table ‘%.*ls’.
4989 16 Cannot drop the ROWGUIDCOL property for column ‘%.*ls’ in table ‘%.*ls’ because the column is not the designated ROWGUIDCOL for the table.
4990 16 Cannot alter column ‘%.*ls’ in table ‘%.*ls’ to add or remove the FILESTREAM column attribute.
4991 16 Cannot alter NOT FOR REPLICATION attribute on column ‘%.*ls’ in table ‘%.*ls’ because this column is not an identity column. 4992 16 Cannot use table option LARGE VALUE TYPES OUT OF ROW on a user table that does not have any of large value types varchar(max), nvarchar(max), varbinary(max) or xml columns in it. This option can be applied to tables having large values computed column that are persisted. 4993 16 ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has different setting for Large Value Types Out Of Row table option as compared to table ‘%.*ls’.
4994 16 Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column type, ‘%.*ls’, is a non-byte-ordered CLR user defined type.
4995 16 Vardecimal storage format is not enabled on database ‘%.*ls’. To enable this storage format, use the
sp_db_vardecimal_storage_format stored procedure.
5001 16 User must be in the master database.
5002 16 Database ‘%.*ls’ does not exist. Verify the name in
sys.databases and try the operation again.
5003 16 Database mirroring cannot be enabled while the database has offline files.
5004 16 To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed.
5006 16 Could not get exclusive use of %S_MSG ‘%.*ls’ to perform the requested operation.
5008 16 This ALTER DATABASE statement is not supported. Correct the syntax and execute the statement again.
5009 16 One or more files listed in the statement could not be found or could not be initialized.
5010 16 Log file name cannot be generated from a raw device. The log file name and path must be specified.
5011 14 User does not have permission to alter database ‘%.*ls’, or the database does not exist.
5012 16 The name of the primary filegroup cannot be changed. 5013 16 The master and model databases cannot have files added to them. ALTER DATABASE was aborted.
5014 16 The %S_MSG ‘%.*ls’ does not exist in database ‘%.*ls’. 5015 16 ALTER DATABASE failed. The total size specified must be 1 MB or greater.
5016 16 Cannot change the name of the system database %.*ls. 5018 10 The file “%.*ls” has been modified in the system catalog. The new path will be used the next time the database is started. 5019 10 Cannot find entry in sys.master_files for file ‘%.*ls’. Retry the operation.
5020 16 The primary data or log file cannot be removed from a database.
5021 10 The %S_MSG name ‘%.*ls’ has been set.
5022 16 Log file ‘%ls’ for this database is already active.
5023 16 The database must be suspect or in emergency mode to rebuild the log.
5024 16 No entry found for the primary log file in sysfiles1. Could not rebuild the log.
5025 16 The file ‘%ls’ already exists. It should be renamed or deleted so that a new log file can be created.
5027 16 System databases master, model, and tempdb cannot have their logs rebuilt.
5028 16 The system could not activate enough of the database to rebuild the log.
5029 10 Warning: The log for database ‘%.*ls’ has been rebuilt. Transactional consistency has been lost. The RESTORE chain was broken, and the server no longer has context on the previous log files, so you will need to know what they were. You should run DBCC CHECKDB to validate physical consistency. The database has been put in dbo-only mode. When you are ready to make the database available for use, you will need to reset database options and delete any extra log files.
5030 16 The database could not be exclusively locked to perform the operation.
5031 16 Cannot remove the file ‘%.*ls’ because it is the only file in the DEFAULT filegroup.
5032 10 The file cannot be shrunk below page %ud until the log is backed up because it contains bulk logged pages.
5033 16 The maximum of %ld files per database has been exceeded. 5034 16 The file %ls is currently being autogrown or modified by another process. Try the operation again later.
5035 16 Filegroup ‘%.*ls’ already exists in this database. Specify a different name or remove the conflicting filegroup if it is empty. 5036 16 MODIFY FILE failed. Specify logical name.
5038 16 MODIFY FILE failed for file “%.*ls”. At least one property per file must be specified.
5039 16 MODIFY FILE failed. Specified size is less than current size.
5040 16 MODIFY FILE failed. Size is greater than MAXSIZE.
5041 16 MODIFY FILE failed. File ‘%.*ls’ does not exist.
5042 16 The %S_MSG ‘%.*ls’ cannot be removed because it is not empty.
5043 16 The %S_MSG ‘%.*ls’ cannot be found in %ls.
5044 10 The %S_MSG ‘%.*ls’ has been removed.
5045 16 The %S_MSG already has the ‘%ls’ property set.
5046 10 The %S_MSG property ‘%ls’ has been set.
5047 16 Cannot change the READONLY property of the PRIMARY
filegroup.
5048 16 Cannot add, remove, or modify files in filegroup ‘%.*ls’. The filegroup is read-only.
5050 16 Cannot change the properties of empty filegroup ‘%.*ls’. The filegroup must contain at least one file.
5051 16 Cannot have a filegroup with the name ‘DEFAULT’.
5052 16 %ls is not permitted while a database is in the %ls state. 5054 16 Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle. 5055 16 Cannot add, remove, or modify file ‘%.*ls’. The file is read-only.
5056 16 Cannot add, remove, or modify a file in filegroup ‘%.*ls’ because the filegroup is offline.
5057 16 Cannot add, remove, or modify file ‘%.*ls’ because it is offline.
5058 16 Option ‘%.*ls’ cannot be set in database ‘%.*ls’.
5059 16 Database ‘%.*ls’ is in transition. Try the ALTER DATABASE statement later.
5060 10 Nonqualified transactions are being rolled back. Estimated rollback completion: %d%%.
5061 16 ALTER DATABASE failed because a lock could not be placed on database ‘%.*ls’. Try again later.
5062 16 The option “%.*ls” conflicts with another requested option. The options cannot both be requested at the same time.
5063 16 Database ‘%.*ls’ is in warm standby. A warm-standby database is read-only.
5064 16 Changes to the state or options of database ‘%.*ls’ cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
5065 16 The file “%ls” is currently being scanned or used by a background or user process. Try the operation again later.
5066 16 Database options single user and dbo use only cannot be set at the same time.
5067 16 The database option TORN_PAGE_DETECTION is incompatible with the PAGE_CHECKSUM option.
5068 10 Failed to restart the current database. The current database is switched to master.
5069 16 ALTER DATABASE statement failed.
5070 16 Database state cannot be changed while other users are using the database ‘%.*ls’
5071 16 Rebuild log can only specify one file.
5072 16 ALTER DATABASE failed. The default collation of database ‘%.*ls’ cannot be set to %.*ls.
5073 16 Cannot alter collation for database ‘%ls’ because it is READONLY, OFFLINE, or marked SUSPECT.
5074 16 The %S_MSG ‘%.*ls’ is dependent on %S_MSG ‘%.*ls’.
5075 16 The %S_MSG ‘%.*ls’ is dependent on %S_MSG. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation. 5076 10 Warning: Changing default collation for database ‘%.*ls’, which is used in replication. All replication databases should have the same default collation.
5077 16 Cannot change the state of non-data files or files in the primary filegroup.
5078 16 Cannot alter database options for “%ls” because it is READONLY, OFFLINE, or marked SUSPECT.
5080 16 Vardecimal storage format cannot be disabled for database “%.*ls” because it’s not in simple recovery model.
5082 16 Cannot change the versioning state on database “%.*ls” together with another database state.
5083 16 The termination option is not supported when making
versioning state changes.
5084 10 Setting database option %ls to %ls for database %.*ls. 5085 16 Alter database command failed because SQL Server was started with one or more undocumented trace flags that prevent enabling/disabling database for versioning.
5086 16 There are one or more tables with vardecimal storage format enabled.
5087 16 The file content type mismatches with the content type of the filegroup.
5093 16 The operation cannot be performed on a database snapshot. 5094 16 The operation cannot be performed on a database with database snapshots or active DBCC replicas.
5095 16 A database or filegroup cannot be set to read-only mode when any files are subject to a RESTORE PAGE operation. Complete the restore sequence involving file “%ls” before attempting to transition to read-only. 5096 16 The recovery model cannot be changed to SIMPLE when any files are subject to a RESTORE PAGE operation. Complete the restore sequence involving file “%ls” before attempting to transition to SIMPLE. 5102 22 Attempted to open a filegroup for the invalid ID %d in database “%.*ls”.
5103 16 MAXSIZE cannot be less than SIZE for file ‘%ls’.
5104 16 File ‘%.*ls’ already used.
5105 16 A file activation error occurred. The physical file name ‘%.*ls’ may be incorrect. Diagnose and correct additional errors, and retry the operation.
5108 10 Log file ‘%.*ls’ does not match the primary file. It may be from a different database or the log may have been rebuilt previously. 5110 16 The file “%.*ls” is on a network path that is not supported for database files.
5111 10 File activation failure. The physical file name “%.*ls” may be incorrect.
5112 10 FCB::SetSize dbid %d fileid %d oldSize %d newSize %d. To prevent this informational message from appearing in the error log, use DBCC TRACEOFF to turn off the trace flag.
5113 10 The log cannot be rebuilt because the database was not cleanly shut down.
5114 16 Log files, offline files, restoring files, and defunct files for database snapshots should not be specified. “%.*ls” is not an eligible file for a database snapshot.
5115 16 Only SQL Server database files can be specified for database snapshots. ‘%.*ls’ is not a SQL Server database file.
5118 16 The file “%ls” is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. 5119 16 Cannot make the file “%.*ls” a sparse file. Make sure the file system supports sparse files.
5120 16 Unable to open the physical file “%.*ls”. Operating system error %d: “%ls”.
5121 16 The path specified by “%.*ls” is not in a valid directory. 5123 16 CREATE FILE encountered operating system error %ls while attempting to open or create the physical file ‘%.*ls’.
5124 16 The file header in ‘%ls’ does not match the expected contents for file ‘%ls’ of database ‘%ls’. The mismatch is possibly between the full-text catalog files and the related database. Perform a restore if necessary.
5125 24 File ‘%ls’ appears to have been truncated by the operating system. Expected size is %I64d KB but actual size is %I64d KB. 5127 16 All files must be specified for database snapshot creation. Missing the file “%ls”.
5128 17 Write to sparse file ‘%ls’ failed due to lack of disk space. 5129 10 The log cannot be rebuilt when the primary file is
read-only.
5130 10 The log cannot be rebuilt when database mirroring is enabled.
5131 10 The log was not rebuilt because there is more than one log file.
5132 16 The path specified by ‘%.*ls’ cannot be used for FILESTREAM files because it is a raw device.
5133 16 Directory lookup for the file “%ls” failed with the
operating system error %ls.
5144 10 Autogrow of file ‘%.*ls’ in database ‘%.*ls’ was cancelled by user or timed out after %d milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size. 5145 10 Autogrow of file ‘%.*ls’ in database ‘%.*ls’ took %d milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
5149 16 MODIFY FILE encountered operating system error %ls while attempting to expand the physical file.
5150 16 The size of a single log file must not be greater than 2 TB. 5159 24 Operating system error %.*ls on file “%.*ls” during %ls. 5169 16 FILEGROWTH cannot be greater than MAXSIZE for file ‘%.*ls’. 5170 16 Cannot create file ‘%ls’ because it already exists. Change the file path or the file name, and retry the operation.
5171 16 %.*ls is not a primary database file.
5172 16 The header for file ‘%ls’ is not a valid database file header. The %ls property is incorrect.
5173 16 One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
5174 16 Each file size must be greater than or equal to 512 KB. 5175 10 The file %.*ls has been expanded to allow recovery to succeed. After recovery completes, you can increase the size of the files in the database. Contact the system administrator for assistance. 5176 10 To allow recovery to succeed, the log file ‘%.*ls’ has been expanded beyond its maximum size. After recovery completes, you should either increase the size of the log file in the database or schedule more frequent backups of the log (under the full or bulk-logged recovery model). 5177 16 An unexpected error occurred while checking the sector size for file ‘%.*ls’. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information. 5178 16 Cannot use file ‘%.*ls’ because it was originally formatted with sector size %d and is now on a volume with sector size %d. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
5179 16 Cannot use file ‘%.*ls’, because it is on a volume with sector size %d. SQL Server supports a maximum sector size of 4096 bytes. Move the file to a volume with a compatible sector size.
5180 22 Could not open File Control Bank (FCB) for invalid file ID %d in database ‘%.*ls’. Verify the file location. Execute DBCC CHECKDB. 5181 16 Could not restart database “%.*ls”. Reverting to the previous status.
5182 10 New log file ‘%.*ls’ was created.
5183 16 Cannot create the file “%ls”. Use WITH MOVE to specify a usable physical file name. Use WITH REPLACE to overwrite an existing file. 5184 16 Cannot use file ‘%.*ls’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.
5185 16 Cannot find the matching log file for FILESTRAM file ‘%.*ls’.
5186 16 Encountered an error (NT status code 0x%x) while attempting to start the Transactional File System Resource Manager ‘%.*ls’. 5188 16 Encountered error (NT status code 0x%x) while attempting to perform redo for transactional file system resource manager ‘%.*ls’. 5189 16 Encountered error (NT status code 0x%x) while attempting to perform undo for transactional file system resource manager ‘%.*ls’. 5190 16 Encountered error (NT status code 0x%x) while attempting to checkpoint transactional file system resource manager ‘%.*ls’. 5194 16 The size for FILESTREAM log file ‘%.*ls’ must be greater than or equal to 1 MB.
5195 16 The Cluster Service function call ‘%s’ failed with error code ‘%s’ while verifying the file path. Verify that your failover cluster is configured properly.
5196 10 The file “%ls” has been uncompressed.
5197 16 Encountered an error (%ls) while attempting to uncompress the file “%ls”.
5198 16 The path specified by “%.*ls” is a UNC path. UNC path is not supported in failover clustered enviornment.
5199 16 The path specified by “%.*ls” is a raw device. Raw device path is not supported in failover clustered enviornment.
5201 10 DBCC SHRINKDATABASE: File ID %d of database ID %d was skipped because the file does not have enough free space to reclaim. 5202 10 DBCC SHRINKDATABASE for database ID %d is waiting for the snapshot transaction with timestamp %I64d and other snapshot transactions linked to timestamp %I64d or with timestamps older than %I64d to finish. 5203 10 DBCC SHRINKFILE for file ID %d is waiting for the snapshot transaction with timestamp %I64d and other snapshot transactions linked to timestamp %I64d or with timestamps older than %I64d to finish. 5204 16 Could not find allocation unit ID %I64d. Check
sys.allocation_units.
5205 10 %.*ls: Moving page %d:%d failed.
5206 10 %.*ls: Page %d:%d could not be moved because it could not be read.
5207 10 %.*ls: Page %d:%d could not be moved because it is a work table page.
5208 10 %.*ls: Page %d:%d could not be moved because it is a work file page.
5209 10 %.*ls: Page %d:%d could not be moved because it is a dedicated allocation page.
5210 10 %.*ls: Page %d:%d could not be moved because it is an invalid page type.
5211 10 %.*ls: Page %d:%d could not be moved because it was
deallocated during shrink.
5212 10 %.*ls: System table SYSFILES1 Page %d:%d could not be moved to other files because it only can reside in the primary file of the database.
5213 10 %.*ls: Page %d:%d could not be moved because its ownership was changed during shrink.
5214 10 %.*ls: Page %d:%d could not be moved because its page type was changed during shrink.
5215 10 %.*ls: Page %d:%d could not be moved because the partition to which it belonged was dropped.
5216 10 %.*ls: Heap page %d:%d could not be moved because the table to which it belonged was dropped.
5217 10 %.*ls: Page %d:%d could not be moved because it is an empty non-leaf level index page.
5218 10 %.*ls: Heap page %d:%d could not be moved because the table name could not be found.
5219 10 %.*ls: Heap page %d:%d could not be moved.
5220 10 %.*ls: Index Allocation Map (IAM) page %d:%d could not be moved.
5221 10 %.*ls: Index Allocation Map (IAM) page %d:%d from a dropped allocation unit could not be moved.
5222 10 %.*ls: Page %d:%d from a dropped allocation unit could not be deallocated.
5223 10 %.*ls: Empty page %d:%d could not be deallocated. 5224 10 %.*ls: Empty large object page %d:%d could not be
deallocated.
5225 10 %.*ls: Not all ghost records on the large object page %d:%d could be removed.
5226 10 %.*ls: Page %d:%d (type UNLINKED_REORG_PAGE) could not be deallocated.
5227 10 %.*ls: Page %d:%d (type BULK_OPERATION_PAGE) could not be deallocated.
5228 16 Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. DBCC detected incomplete cleanup from an online index build operation. (The anti-matter column value is %d.)
5229 16 Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) contains an anti-matter column, but is not a nonclustered index.
5230 10 The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.
5231 10 Object ID %ld (object ‘%.*ls’): A deadlock occurred while trying to lock this object for checking. This object has been skipped and will not be processed.
5232 10 DBCC CHECKDB will not check SQL Server catalog or Service Broker consistency because a database snapshot could not be created or because WITH TABLOCK was specified.
5233 16 Table error: alloc unit ID %I64d, page %S_PGID. The test (%hs) failed. The values are %ld and %ld.
5234 10 DBCC SHRINKDATABASE: File ID %d of database ID %d was skipped because trying to adjust the space allocation for the file was failed.
5235 10 %lsDBCC %ls (%ls%ls%ls)%ls executed by %ls terminated abnormally due to error state %d. Elapsed time: %d hours %d minutes %d seconds.
5236 10 Unable to process object ‘%ls’ because it is a four-part name, which is not supported by any DBCC command.
5237 10 Indexed view check failed for indexed view ‘%.*ls’ (object ID %d) due to an internal query error. This error does not represent an issue with the integrity of the data in this database. However, this view will not be processed further.
5238 16 Unable to process object ID %ld (object ‘%.*ls’) because it is a stored procedure or user-defined function, which is not supported by any DBCC command.
5239 16 Unable to process object ID %ld (object ‘%.*ls’) because this DBCC command does not support objects of this type.
5240 10 File ID %d of database ID %d cannot be shrunk as it is either being shrunk by another process or is empty.
5241 10 File ID %d of database ID %d cannot be shrunk as the target shrink size (%I64d KB) is greater than the actual file size (%I64d KB). 5242 16 An inconsistency was detected during an internal operation in database ‘%.*ls’(ID:%d) on page %S_PGID. Please contact technical support. Reference number %ld.
5243 16 An inconsistency was detected during an internal operation. Please contact technical support. Reference number %ld.
5244 16 Repair statement not processed. One or more files in the database are read-only and must be made writeable in order to run repair. 5245 16 DBCC could not obtain a lock on object %ld because the lock request timeout period was exceeded.
5246 10 Repair operations cannot be performed on the
MSSQLSYSTEMRESOURCE database. Consult Books Online topic “Resource Database” for more information.
5247 16 Repair: insert a secondary index row based on its base table row.
5248 10 Repair: Successfully %ls row in index “%ls” in database “%ls”.
5249 10 %.*ls: Page %d:%d could not be moved because shrink could not lock the page.
5250 16 Database error: %ls page %S_PGID for database ‘%.*ls’ (database ID %d) is invalid. This error cannot be repaired. You must restore from backup.
5251 10 %.*ls: Heap page %d:%d could not be moved because
maintaining NC indexes associated with the heap failed.
5252 10 File ID %d of database ID %d cannot be shrunk to the expected size. The high concurrent workload is leading to too many deadlocks during the shrink operation. Re-run the shrink operation when the workload is lower.
5253 10 The check statement was aborted. DBCC CHECKALLOC cannot be run on TEMPDB.
5254 10 %.*ls: Heap page %d:%d could not be moved because the table to which it belonged was building the heap by another process. 5255 10 %.*ls: Page %d:%d could not be moved because it is a sort page.
5256 16 Table error: alloc unit ID %I64d, page %S_PGID contains an incorrect page ID in its page header. The PageId in the page header = %S_PGID.
5257 10 %.*ls: File ID %d of database ID %d was skipped because the file size was changed in the middle of shrink operation.
5258 10 %.*ls: Heap page %d:%d could not be moved because building computed column expression failed.
5259 10 %.*ls: Heap page %d:%d could not be moved because populating computed column expression failed.
5260 16 Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls): At least one record on page %S_PGID contains versioning information, but the VERSION_INFO bit in the page header is not set. 5261 10 %.*ls: Page %d:%d could not be moved because it has not been formatted.
5262 16 Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d: Row contains a NULL versioning timestamp, but its version chain pointer is not NULL. Version chain points to page %S_PGID, slot %d.
5263 10 Found incorrect count(s) for table ‘%.*ls’, index ‘%.*ls’, partition %ld:
5264 10 DATA pages %.*ls: From system table – %I64d pages; Actual – %I64d pages.
5265 10 USED pages %.*ls: From system table – %I64d pages; Actual – %I64d pages.
5266 10 RSVD pages %.*ls: From system table – %I64d pages; Actual – %I64d pages.
5267 10 ROWS count: From system table – %I64d rows; Actual – %I64d rows.
5268 10 DBCC %.*ls is performing an exhaustive search of indexes for possible inconsistencies. This is an informational message only. No user action is required.
5301 16 Bulk load failed. User does not have ALTER TABLE permission on table ‘%.*ls’. ALTER TABLE permission is required on the target table of a bulk load if the target table contains triggers or check constraints, but the ‘FIRE_TRIGGERS’ or ‘CHECK_CONSTRAINTS’ bulk hints are not specified. ALTER TABLE permission is also required if the ‘KEEPIDENTITY’ bulk hint is specified.
5302 16 Mutator ‘%.*ls’ on ‘%.*ls’ cannot be called on a null value. 5303 16 The result of applying mutator ‘%.*ls’ on udt ‘%.*ls’ cannot be a null value.
5304 16 Bulk copy failed. User does not have ALTER TABLE permission on table ‘%.*ls’. ALTER TABLE permission is required on the target table of a bulk copy operation if the table has triggers or check constraints, but ‘FIRE_TRIGGERS’ or ‘CHECK_CONSTRAINTS’ bulk hints are not specified as options to the bulk copy command.
5305 16 The rowdump and lockres columns are only valid on tables and indexed views on which the NOEXPAND hint is specified.
5306 16 Cursor parameters are not allowed for functions. Variable ‘%.*ls’ is of type cursor.
5307 16 Invalid parameter specified for sp_cursoropen.
5308 16 Windowed functions do not support integer indices as ORDER BY clause expressions.
5309 16 Windowed functions do not support constants as ORDER BY clause expressions.
5501 16 The FILESTREAM filegroup was dropped before the table can be created.
5502 16 The FILESTREAM container is inaccessible.
5503 10 Unable to find entry in sys.database_files for FILESTREAM file ‘%.*ls’.
5504 15 ‘PRIMARY’ can only be specified for FILESTREAM log filegroup in a ‘CONTAINS’ clause.
5505 16 A table with filestream column(s) must have a non-NULL unique ROWGUID column.
5506 15 FILESTREAM data or log file cannot be named ‘DEFAULT’. 5507 15 DEFAULT cannot be specified for FILESTREAM log filegroup ‘%.*ls’.
5508 15 FILESTREAM can only be declared for VARBINARY columns. 5509 15 Size, Maxsize or Growth cannot be specified for a FILESTREAM data file ‘%.*ls’.
5510 15 LOG ON cannot be used for non-FILESTREAM file group ‘%.*ls’. 5511 23 FILESTREAM’s file system log record ‘%.*ls’ under log folder ‘%.*ls’ is corrupted.
5512 16 Error 0x%x (%ls) was encountered while truncating the directory ‘%.*ls’.
5513 16 The FILESTREAM filegroup ‘%.*ls”s associated log filegroup is invalid.
5514 16 Transactional replication cannot proceed because
Transactional File System Resource Manager at ‘%.*ls’ is not started. 5515 20 The FILESTREAM file’s container directory ‘%.*ls’ cannot be opened. The operating system has returned NT status code 0x%x. 5516 16 The FILESTREAM log filegroup ‘%.*ls’ cannot be referred to by more than one filestream data filegroup.
5517 16 Too few or too many files specified for FILESTREAM(LOG) filegroup ‘%.*ls’.
5518 16 FILESTREAM path ‘%.*ls’ is too long.
5519 16 A database must have primary FILESTREAM log filegroup and log file in order for it to contain other FILESTREAM filegroups. 5520 16 FILESTREAM file ‘%.*ls’ cannot be added because its
destination filegroup cannot have more than one file.
5521 16 Error 0x%x (NT status code) was encountered when SQL server attempts to retrieve ‘%.*ls’ from the Transaction File System Resource Manager located at ‘%.*ls’.
5522 16 FILESTREAM data file cannot be removed because its log file has not been backed up.
5523 16 FILESTREAM data file group cannot be added to refer to an empty FILESTREAM log file group.
5524 16 Default FILESTREAM data filegroup cannot be removed unless it’s the last FILESTREAM data filegroup left.
5525 16 ‘READONLY/READWRITE/ONLINE/OFFLINE’ properties cannot be modified on a FILESTREAM log filegroup
5526 16 The FILESTREAM log file ‘%.*ls’ cannot be removed because it’s referred to by a FILESTREAM data filegroup.
5527 16 The primary FILESTREAM log file cannot be dropped because of the existence of other filestream filegroups.
5528 16 A database can have at most one primary FILESTREAM log filegroup and log file.
5529 16 Setting FILESTREAM files offline is not supported.
5530 16 FILESTREAM file’s physical file path cannot be changed. 5531 16 Error 0x%x (NT status code) was encountered when SQL server attempts to change the logging mode of Transaction File System Resource Manager located at ‘%.*ls’ from ‘%.*ls’ to ‘%.*ls’.
5532 16 SQL server cannot obtain the Kernel Transaction Manager’s transaction context to perform file system operation.
5533 23 FILESTREAM’s file system log record with an LSN ‘%d:%d:%d’ is missing. Log folder ‘%.*ls’ is corrupted.
5534 23 SQL log record at LSN ‘%d:%d:%d’ for database ‘%.*ls’ is corrupted. Database cannot recover.
5535 23 FILESTREAM data container ‘%.*ls’ is corrupted. Database cannot recover.
5536 23 FILESTREAM deleted folder ‘%.*ls’ is corrupted. Database cannot recover.
5550 16 Operating system error 0x%x was encountered during
Filestream operation.
5552 16 FILESTREAM file named with GUID ‘%.*ls’ that belongs to FILESTREAM data file ID 0x%x does not exist or cannot be opened. 5553 16 SQL Server internal error. The FileStream manager cannot continue with the current command.
5554 16 The file system’s maximum limit of total versions for a single file has been reached.
5555 16 The operation has failed because the FILESTREAM data cannot be renamed.
5590 16 FILESTREAM operations are not supported on the platform. 5591 16 FILESTREAM feature is disabled.
5600 16 The Cross Database Chaining option cannot be set to the specified value on the specified database.
5601 16 The service master key could not be force regenerated as requested by the -F startup option. The error number is %ld. 5602 16 The service master key regeneration was successful.
5603 16 The password for SA could not be force regenerated as requested by the -F startup option. The error number is %ld. 5604 16 The password regeneration attempt for SA was successful. 5701 10 Changed database context to ‘%.*ls’.
5702 10 SQL Server is terminating this process.
5703 10 Changed language setting to %.*ls.
5803 10 Unknown config number (%d) in sysconfigures.
5804 16 Character set, sort order, or collation cannot be changed at the server level because at least one database is not writable. Make the database writable, and retry the operation.
5805 16 Too few locks specified. Minimum %d.
5807 16 Recovery intervals above %d minutes not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration. 5808 16 Ad hoc update to system catalogs is not supported.
5810 16 Valid values for the fill factor are 0 to 100.
5812 14 You do not have permission to run the RECONFIGURE statement. 5828 16 User connections are limited to %d.
5829 16 The specified user options value is invalid.
5831 16 Minimum server memory value (%d) must be less than or equal to the maximum value (%d).
5832 16 The affinity mask specified does not match the CPU mask on this system.
5833 16 The affinity mask specified is greater than the number of CPUs supported or licensed on this edition of SQL Server.
5834 16 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration. 5835 16 Failed to start CPUs with the mask 0x%lx on the system. 5836 16 Lightweight pooling is not supported on this platform or in this edition of SQL Server.
5837 16 The service broker listen port cannot be dynamic. Valid port values are 1024-32767.
5838 16 The service broker connection authentication value is invalid.
5839 16 The service broker message forward store size cannot be set to 0.
5840 16 The service broker message forward mode is invalid.
5841 16 The default full-text language is not supported by the full-text search component.
5842 16 Too few worker threads are specified. The minimum is %d. 5843 16 Address Windowing Extensions (AWE) is not supported in this edition of SQL Server.
5844 16 User Instances are not supported in this edition of SQL Server.
5845 16 Address Windowing Extensions (AWE) requires the ‘lock pages in memory’ privilege which is not currently present in the access token of the process.
5846 16 Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: “clr enabled” or “lightweight pooling”.
5847 16 Execution of .NET Framework code is disabled. Set “clr enabled” configuration option and restart the server.
5904 17 Unable to issue checkpoint: there are not enough locks available. Background checkpoint process will remain suspended until locks are available. To free up locks, list transactions and their locks, and terminate transactions with the highest number of locks.
6001 10 SHUTDOWN is waiting for %d process(es) to complete.
6004 10 User does not have permission to perform this action. 6005 10 SHUTDOWN is in progress.
6006 10 Server shut down by %.*ls from login %.*ls.
6007 10 The SHUTDOWN statement cannot be executed within a
transaction or by a stored procedure.
6101 16 Process ID %d is not a valid process ID. Choose a number between 1 and %d.
6102 14 User does not have permission to use the KILL statement. 6104 16 Cannot use KILL to kill your own process.
6106 16 Process ID %d is not an active process ID.
6107 14 Only user processes can be killed.
6108 16 KILL SPID WITH COMMIT/ABORT is not supported by Microsoft SQL Server 2000. Use Microsoft Distributed Transaction Coordinator to resolve distributed transactions.
6109 10 SPID %d: transaction rollback in progress. Estimated rollback completion: %d%%. Estimated time remaining: %d seconds. 6110 16 The distributed transaction with UOW %s does not exist. 6111 16 Another user has decided a different outcome for the distributed transaction associated with UOW %s.
6112 16 Distributed transaction with UOW %s is in prepared state. Only Microsoft Distributed Transaction Coordinator can resolve this transaction. KILL command failed.
6113 16 The distributed transaction associated with UOW %s is in PREPARE state. Use KILL UOW WITH COMMIT/ABORT syntax to kill the transaction instead.
6114 16 Distributed transaction with UOW %s is being used by another user. KILL command failed.
6115 16 KILL command cannot be used inside user transactions. 6117 16 There is a connection associated with the distributed transaction with UOW %s. First, kill the connection using KILL SPID syntax. 6118 16 The distributed transaction associated with UOW %s is not in PREPARED state. Use KILL UOW to kill the transaction instead. 6119 10 Distributed transaction with UOW %s is rolling back: estimated rollback completion: %d%%, estimated time left %d seconds. 6120 16 Status report cannot be obtained. Rollback operation for Process ID %d is not in progress.
6121 16 Status report cannot be obtained. Rollback operation for UOW %s is not in progress.
6200 16 Method “%ls” of type “%ls” in assembly “%.*ls” is marked as a mutator. Mutators cannot be used in the read-only portion of the query. 6201 16 Method “%ls” of type “%ls” in assembly “%.*ls” is not marked as a mutator. Only mutators can be used to update the value of a user-defined type.
6202 16 Method “%ls” of type “%ls” in assembly “%.*ls” does not return a value.
6203 16 Method ‘%ls’ of type ‘%ls’ in assembly ‘%.*ls’ cannot be marked as a mutator. A mutator method must be non-static, public, and returns void type.
6204 16 Invalid ResultSetOptions “%ld” was specified.
6205 16 %s ASSEMBLY failed because assembly ‘%.*ls’ was compiled with /UNSAFE option, but the assembly was not registered with the required PERMISSION_SET = UNSAFE option.
6206 16 Request submitted with too many parameters. The maximum number is %ld.
6207 16 Error converting %.*ls to fixed length binary type. The result would be padded and cannot be converted back.
6208 16 %s failed because the parameter count for the FillRow method should be one more than the SQL declaration for the table valued CLR function.
6209 16 Unsound ordering on user-defined type “%.*ls”: returning NULL on non-NULL inputs.
6210 16 User defined type ‘%.*ls’ is not fully comparable.
6211 16 %s ASSEMBLY failed because type ‘%.*ls’ in %.*ls assembly ‘%.*ls’ has a static field ‘%.*ls’. Attributes of static fields in %.*ls assemblies must be marked readonly in Visual C#, ReadOnly in Visual Basic, or initonly in Visual C++ and intermediate language.
6212 16 %s ASSEMBLY failed because method ‘%.*ls’ on type ‘%.*ls’ in %.*ls assembly ‘%.*ls’ is storing to a static field. Storing to a static field is not allowed in %.*ls assemblies.
6213 16 %s ASSEMBLY failed because method “%.*ls” on type “%.*ls” in %.*ls assembly “%.*ls” has a synchronized attribute. Explicit synchronization is not allowed in %.*ls assemblies.
6214 16 %s ASSEMBLY failed because assembly “%.*ls” has an unmanaged entry point.
6215 16 %s ASSEMBLY failed because method ‘%.*ls’ on type ‘%.*ls’ in %.*ls assembly ‘%.*ls’ has invalid attribute 0x%x.
6216 16 %s ASSEMBLY failed because type “%.*ls” in %.*ls assembly “%.*ls” has a finalizer. Finalizers are not allowed in %.*ls assemblies. 6218 16 %s ASSEMBLY for assembly ‘%.*ls’ failed because assembly ‘%.*ls’ failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message%.*ls 6219 16 %s ASSEMBLY failed because assembly source parameter %d has an unmanaged entry point.
6220 16 SELECT INTO failed because user-defined type “%.*ls” does not exist in the target database.
6221 16 The cursor operation generated more than one row of
different column metadata.
6222 16 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” is not valid for native serialization. 6223 16 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” is of type “%.*ls.%.*ls”, which is not marked with “LayoutKind.Sequential”. Native serialization requires the type to be marked with “LayoutKind.Sequential”.
6224 16 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” is marked with
“System.NonSerializedAttribute”. Native serialization types cannot have fields marked with “System.NonSerializedAttribute”.
6225 16 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” is of type “%.*ls.%.*ls” which is a non-value type. Native serialization types can only have fields of blittable types. If you wish to have a field of any other type, consider using different kind of serialization format, such as User Defined Serialization. 6226 16 Type “%.*ls.%.*ls” is marked for user-defined serialization, but does not implement the “%.*ls.%.*ls” interface.
6227 16 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” is of type “%.*ls.%.*ls”, which is not blittable.
6228 16 Type “%.*ls.%.*ls” is marked for native serialization, but it contains non-blittable fields.
6229 16 Type “%.*ls.%.*ls” is marked for native serialization. It is not marked with “LayoutKind.Sequential”. Native serialization requires the type to be marked with “LayoutKind.Sequential”.
6230 16 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” has field marshallers. Native serialization types cannot have field marshallers.
6231 16 Type “%.*ls.%.*ls” is marked for native serialization, but one of its base types “%.*ls.%.*ls” is not valid for native serialization. 6232 16 Type “%.*ls.%.*ls” is marked for native serialization, but base type “%.*ls.%.*ls” is not marked with “LayoutKind.Sequential”. Native serialization requires the type to be marked with “LayoutKind.Sequential”. 6233 16 In proc data access is not allowed in an impersonated state. 6234 16 Data truncation error. Length (%d) exceeds maximum length (%d) for type ‘%.*ls’.
6235 16 Data serialization error. Length (%d) is less than fixed length (%d) for type ‘%.*ls’.
6236 16 %s ASSEMBLY failed because filename ‘%.*ls’ is too long. 6237 16 %s ASSEMBLY failed because method “%.*ls” on type “%.*ls” in assembly “%.*ls” has an invalid custom attribute “%.*ls”.
6238 16 %s ASSEMBLY failed because field “%.*ls” in type “%.*ls” in assembly “%.*ls” has an invalid custom attribute “%.*ls”.
6239 16 %s ASSEMBLY failed because type “%.*ls” in assembly “%.*ls” has an invalid custom attribute “%.*ls”.
6242 16 CREATE ASSEMBLY failed because the user “%.*ls” specified in the authorization clause does not exist.
6243 16 ‘%.*ls.%.*ls’ is marked for native serialization, and has the MaxByteSize property specified in the ‘%.*ls’ attribute. Native serialization objects can not specify MaxByteSize property, it is calculated by SQL Server.
6244 16 The size (%d) for “%.*ls.%.*ls” is not in the valid range (1-8000).
6245 16 Invalid serialization format (%d) for type “%.*ls.%.*ls”. 6246 16 Assembly “%.*ls” already exists in database “%.*ls”. 6248 16 %s failed because the type ‘%s’ contains a method ‘%s’ specified by SqlUserDefinedType.ValidateMethodName that does not conform to the required specification because it has an invalid signature. 6249 16 The associated file “%.*ls” already exists for assembly “%.*ls”.
6250 11 Assembly “%.*ls” does not have an associated file “%.*ls”. 6251 16 ALTER ASSEMBLY failed because the assembly file parameter %d is not a valid expression.
6252 16 ALTER ASSEMBLY failed because a file name was not specified for the inline assembly file parameter %d.
6253 10 Common language runtime (CLR) functionality initialized using CLR version %ls from %ls.
6254 10 Common language runtime (CLR) functionality initialized. 6255 16 %s failed because type “%s” does not conform to the %s specification: missing custom attribute “%.*ls”.
6258 16 Function signature of “FillRow” method (as designated by SqlFunctionAttribute.FillRowMethodName) does not match SQL declaration for table valued CLR function’%.*ls’ due to column %d.
6260 16 An error occurred while getting new row from user defined Table Valued Function : %.*ls.
6261 16 The user-defined type referenced by column “%.*ls” of table variable “%.*ls” has been dropped during the execution of the batch. Run the batch again.
6262 16 Assembly was not found in current database or version did not match.
6263 16 Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option.
6264 16 Data access failed because the .NET Framework routine is not marked with “DataAccessKind.Read” or “SystemDataAccessKind.Read”. 6265 16 %s ASSEMBLY failed because type “%.*ls” in %.*ls assembly “%.*ls” has a pinvokeimpl method. P/Invoke is not allowed in %.*ls assemblies.
6266 10 Warning: Assembly “%.*ls” was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s.
6267 16 Assembly “%.*ls” does not exist, or the user does not have permission to reference it.
6268 16 Attempt to perform native server operation (%ls) outside of its valid scope.
6269 16 ALTER ASSEMBLY failed because the user-defined aggregate “%s” does not exist or is not correctly defined in the updated assembly. 6270 16 ALTER ASSEMBLY failed because the required method “%s” in type “%s” was not found with the same signature in the updated assembly. 6271 16 ALTER ASSEMBLY failed because the required field “%s” in type “%s” was not found with the same signature in the updated assembly. 6272 16 ALTER ASSEMBLY failed because required property ‘%s’ in type ‘%s’ was not found with the same signature in the updated assembly. 6273 16 ALTER ASSEMBLY failed because required type ‘%s’ does not exist or is not correctly defined in the updated assembly.
6274 16 ALTER ASSEMBLY failed because the serialization format of type ‘%s’ would change in the updated assembly. Persisted types are not allowed to change serialization formats.
6275 16 ALTER ASSEMBLY failed because the IsByteOrdered attribute of type ‘%s’ would change in the updated assembly.
6276 16 ALTER ASSEMBLY failed because serialization data of type ‘%s’ would change in the updated assembly. Persisted types are not allowed to change serialization data.
6277 16 ALTER ASSEMBLY failed because the MaxLen attribute of type ‘%s’ would change in the updated assembly. Persisted types are not allowed to change MaxLen attribute.
6278 16 ALTER ASSEMBLY failed because the IsFixedLen attribute of type ‘%s’ would change in the updated assembly. Persisted types are not allowed to change IsFixedLen attribute.
6279 16 ALTER ASSEMBLY failed because the mutator attribute of method ‘%s’ in type ‘%s’ would change in the updated assembly, and the method is in use by the schema-bound function or view ‘%s’.
6280 16 ALTER ASSEMBLY failed because table, view or constraint ‘%s’ depends on this assembly. Use WITH UNCHECKED DATA to skip checking for persisted data.
6281 16 ALTER ASSEMBLY failed because only members of the sysadmin role can use WITH UNCHECKED DATA.
6282 16 ALTER ASSEMBLY failed because the referenced assemblies would change. The referenced assembly list must remain the same. 6283 16 ALTER ASSEMBLY failed because only the assembly revision version number is allowed to change.
6284 16 ALTER ASSEMBLY failed because it is referenced by object ‘%.*ls’. Assemblies that are referenced by SQL objects cannot be made invisible.
6285 16 %s ASSEMBLY failed because the source assembly is, according to MVID, identical to an assembly that is already registered under the name “%.*ls”.
6286 16 ‘%s’ ASSEMBLY failed because a different version of assembly ‘%s’, referenced by assembly ‘%s’, is already in the database. 6287 16 ALTER ASSEMBLY failed because the function ‘%s’ of type ‘%s’ no longer satisfies indexability requirements, and is used for the persisted computed column ‘%s’ of table ‘%s’.
6288 16 ALTER ASSEMBLY has marked data as unchecked in one or more objects in database “%.*ls”. Refer to column “has_unchecked_assembly_data” from system views “sys.tables” and “sys.views” to locate all such objects. 6289 16 Failed to allocate memory for common language runtime (CLR) functionality.
6290 10 AppDomain %i (%.*ls) unloaded.
6291 16 AppDomain %i (%.*ls) failed to unload with error code 0x%x. 6292 16 The transaction that is associated with this operation has been committed or rolled back. Retry with a different transaction. 6293 16 %.*ls.%.*ls.%.*ls: SqlFacetAttribute is invalid on a non-public member.
6294 16 %.*ls.%.*ls.%.*ls: %.*ls property of SqlFacetAttribute cannot be used in this context.
6295 16 %.*ls.%.*ls.%.*ls: %.*ls property of SqlFacetAttribute has an invalid value.
6296 16 %.*ls.%.*ls.%.*ls : SqlFacetAttribute cannot be applied to a property getter or a property setter. It should be applied to the property itself.
6297 16 %.*ls.%.*ls.%.*ls: The SqlFacetAttribute property
IsFixedLength cannot be set to true when MaxSize is set to -1. 6298 16 %.*ls.%.*ls.%.*ls: The SqlFacetAttribute properties
Precision and Scale have to be used together.
6299 10 AppDomain %i (%.*ls) created.
6302 16 The argument of CREATE or ALTER XML SCHEMA COLLECTION statement must be a string expression.
6303 16 XML parsing: Document parsing required too much memory 6304 16 XML parsing: An unexpected error has occurred in the MS-XML parser
6305 16 XQuery data manipulation expression required in XML data type method.
6306 16 Invalid XQuery expression passed to XML data type method. 6307 16 XML well-formedness check: Attribute cannot appear outside of element declaration. Rewrite your XQuery so it returns well-formed XML. 6308 16 XML well-formedness check: Duplicate attribute ‘%.*ls’. Rewrite your XQuery so it returns well-formed XML.
6309 16 XML well-formedness check: the data for node ‘%.*ls’ contains a character (0x%04X) which is not allowed in XML.
6310 16 Altering existing schema components is not allowed. There was an attempt to modify an existing XML Schema component, component namespace: ‘%.*ls’ component name: ‘%.*ls’ component kind:%.*ls 6311 16 An internal XMLDB schema processor error occurred. Contact Technical Support for assistance.
6312 16 Could not find schema components with target namespace ‘%.*ls’ in collection ‘%.*ls’.
6314 16 Collection specified does not exist in metadata : ‘%.*ls’ 6315 16 XQuery: Cannot update with value ‘%.*ls’ as the canonical form of type ‘{%.*ls}%.*ls’ violates the required pattern. It is recommended that you not use pattern facets on non-string types.
6316 16 Specified component ‘%s’ can not be dropped because it is used by component:’%s’
6317 16 XQuery: Cannot update with value ‘%.*ls’ because it failed validation against type ‘{%.*ls}%.*ls’
6318 16 XQuery: String conversion failed during UPDATE validation 6319 16 The maximum length of the URI within wildcard component is 4000 characters
6320 16 XQuery: Only nillable elements or text nodes can be updated with empty sequence
6321 16 xml:space attribute must have a value of ‘preserve’ or ‘default’. ‘%.*ls’ is not valid.
6322 16 Too many attributes or namespace definitions
6323 16 The xml schema collection for variable ‘%.*ls’ has been altered while the batch was being executed. Remove all XML schema collection DDL operations it is dependent on from the batch, and re-run the batch. 6324 16 DROP XML INDEX does not support any options.
6325 16 XQuery: Replacing the value of a node with an empty sequence is allowed only if ‘()’ is used as the new value expression. The new value expression evaluated to an empty sequence but it is not ‘()’. 6326 16 XML well-formedness check: XML namespace declaration cannot appear outside of element declaration. Rewrite your XQuery so it returns well-formed XML.
6327 16 The specified xml schema collection ID is not valid: %d 6328 16 Specified collection ‘%.*ls’ cannot be dropped because it is used by %S_MSG ‘%ls’.
6329 16 Unsupported usage of a QName typed value in node ‘%.*ls’ 6330 16 Column ‘%.*ls’ on table ‘%.*ls’ is not of type XML, which is required to create an XML index on it.
6331 16 Primary XML Index ‘%.*ls’ already exists on column ‘%.*ls’ on table ‘%.*ls’, and multiple Primary XML Indexes per column are not allowed.
6332 16 Table ‘%.*ls’ needs to have a clustered primary key with less than %d columns in it in order to create a primary XML index on it. 6333 16 Could not find%ls XML index named ‘%.*ls’ on table ‘%.*ls’ 6334 16 Could not create XML index on object ‘%.*ls’ because that object is not a table.
6335 16 XML datatype instance has too many levels of nested nodes. Maximum allowed depth is %d levels.
6336 16 Maximum size of primary index of table ‘%.*ls’ is %d bytes. CREATE XML INDEX requires that such size should be limited to %d bytes 6337 16 ‘%.*ls’ is not a valid XML Index name because it starts with ‘%c’ character. XML Index name should not start with ‘#’ or ‘@’ 6338 10 XML DTD has been stripped from one or more XML fragments. External subsets, if any, have been ignored.
6339 16 Specified collection ‘%.*ls’ cannot be modified because it is SQL Server built-in XML Schema Collection.
6340 16 Xml schema collection ‘%.*ls’ referenced by table variable ‘%.*ls’ has been dropped or altered during the execution of the batch. Please re-run the batch.
6341 16 Xml schema collection referenced by column ‘%.*ls’ of table variable ‘%.*ls’ has been dropped or altered during the execution of the batch. Please re-run the batch.
6342 16 Cannot create primary xml index ‘%.*ls’ on table ‘%.*ls’, column ‘%.*ls’, because the column is computed.
6343 16 Cannot create secondary xml index ‘%.*ls’ without a USING XML INDEX clause.
6344 16 The primary xml index ‘%.*ls’ does not exist on table ‘%.*ls’ column ‘%.*ls’.
6346 16 Cannot convert a primary XML index to a secondary XML index using the DROP_EXISTING option. ‘%.*ls’ is a primary XML index. 6347 16 Specified collection ‘%.*ls’ cannot be altered because it does not exist or you do not have permission.
6348 16 Specified collection ‘%.*ls’ cannot be created because it already exists or you do not have permission.
6350 16 The definition for xml schema collection ‘%.*ls’ has changed.
6351 16 The xml schema collection for return parameter of module ‘%.*ls’ has been altered while the batch was being executed. Please re-run the batch.
6352 16 Invalid parameter specified. XML Schema Collections can only be created from a string literal, or from a variable typed as a string or untyped XML.
6353 16 Serialization of built-in schemata is not supported. 6354 16 Target string size is too small to represent the XML instance
6355 16 Conversion of one or more characters from XML to target collation impossible
6356 16 Failed to load DLL. Make sure xmlrw.dll exists in the SQL Server installation.
6357 16 Internal error: cannot locate CreateInfoSetReaderEx in xmlrw.dll. You may have an incorrect version of xmlrw.dll.
6358 16 %d is not a valid style number when converting to XML. 6359 16 Parsing XML with internal subset DTDs not allowed. Use CONVERT with style option 2 to enable limited internal subset DTD support. 6360 16 %d is not a valid style number when converting from XML. 6361 16 Invalid null parameter specified. XML Schema Collections can only be created from a non-null value.
6401 16 Cannot roll back %.*ls. No transaction or savepoint of that name was found.
6500 16 %ls failed because method ‘%ls’ of class ‘%ls’ in assembly ‘%ls’ returns %ls, but CLR Triggers must return void.
6501 16 %s ASSEMBLY failed because it could not open the physical file “%.*ls”: %ls.
6502 16 %s ASSEMBLY failed because it could not read from the physical file ‘%.*ls’: %ls.
6503 16 Assembly ‘%.*ls’ was not found in the SQL catalog.
6504 16 The value returned from %.*ls.%.*ls is not allowed to be NULL.
6505 16 Could not find Type ‘%s’ in assembly ‘%s’.
6506 16 Could not find method ‘%s’ for type ‘%s’ in assembly ‘%s’ 6507 16 Failed to open malformed assembly ‘%ls’ with HRESULT 0x%x. 6508 16 Could not find field ‘%s’ for type ‘%s’ in assembly ‘%s’. 6509 16 An error occurred while gathering metadata from assembly ‘%ls’ with HRESULT 0x%x.
6510 16 Common Language Runtime (CLR) %ls not installed properly. The CLR is required to use SQL/CLR features.
6511 16 Failed to initialize the Common Language Runtime (CLR) %ls with HRESULT 0x%x. You may fix the problem and try again later. 6512 16 Failed to initialize the Common Language Runtime (CLR) %ls with HRESULT 0x%x. You need to restart SQL server to use CLR integration features.
6513 16 Failed to initialize the Common Language Runtime (CLR) %ls due to memory pressure. Please restart SQL server in Address Windowing Extensions (AWE) mode to use CLR integration features.
6514 16 Cannot use ‘%s’ column in the result table of a streaming user-defined function (column ‘%.*ls’).
6515 16 Schema collection database ‘%.*ls’ does not exist or you do not have permission.
6516 16 There is no collection ‘%.*ls’ in metadata ‘%.*ls’.
6517 16 Failed to create AppDomain “%.*ls”. %.*ls
6518 16 Could not open system assembly ”%.*ls”: %ls.
6519 16 Type ‘%.*ls’ is not yet supported for CLR operations. 6520 16 A .NET Framework error occurred during statement execution. 6521 16 A .NET Framework error occurred during statement execution: %.*ls.
6522 16 A .NET Framework error occurred during execution of
user-defined routine or aggregate “%.*ls”: %ls.
6523 16 Method, property or field ‘%ls’ of class ‘%ls’ in assembly ‘%.*ls’ is static.
6524 16 Cannot use computed column in the result table of a
streaming user-defined function (column ‘%.*ls’).
6525 16 Cannot use ‘%s’ constraint in the result table of a
streaming user-defined function.
6526 16 Cannot use ‘%s’ constraint in the result table of a
streaming user-defined function (column ‘%.*ls’).
6527 10 .NET Framework runtime has been stopped.
6528 16 Assembly ‘%.*ls’ was not found in the SQL catalog of database ‘%.*ls’.
6529 16 ALTER ASSEMBLY failed because the identity of referenced assembly ‘%.*ls’ has changed. Make sure the version, name, and public key have not changed.
6530 16 Cannot perform alter on ‘%.*ls’ because it is an
incompatible object type.
6531 16 %ls failed because the function ‘%ls’ of class ‘%ls’ of assembly ‘%.*ls’ takes one or more parameters but CLR Triggers do not accept parameters.
6532 16 .NET Framework execution was aborted by escalation policy because of out of memory. %.*ls
6533 16 AppDomain %.*ls was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource. %.*ls
6534 16 AppDomain %.*ls was unloaded by escalation policy to ensure the consistency of your application. Application failed to release a managed lock. %.*ls
6535 16 .NET Framework execution was aborted. Another query caused the AppDomain %.*ls to be unloaded or an unhandled .NET exception happened. %.*ls
6536 16 A fatal error occurred in the .NET Framework common language runtime. SQL Server is shutting down. If the error recurs after the server is restarted, contact Customer Support Services.
6537 16 The .NET Framework common language runtime was shut down by user code, such as in a user-defined function or user-defined type. SQL Server is shutting down. Environment.Exit should not be used to exit the process. If the intent is to return an integer to indicate failure, use a scalar function or an output parameter instead.
6538 16 .NET Framework execution was aborted because of stack overflow. %.*ls
6539 16 Invalid serialization format (Format.Unknown) for type ‘%.*ls.%.*ls’.
6540 16 The assembly name ‘%.*ls’ being registered has an illegal name that duplicates the name of a system assembly.
6541 16 ALTER ASSEMBLY failed because assembly ‘%.*ls’ has more then one file associated with it. Use ALTER ASSEMBLY DROP FILE to remove extra files.
6542 16 Can not create object because %ls is a generic type. 6543 16 .NET Framework execution was aborted. The UDP/UDF/UDT did not end thread affinity.
6544 16 %s ASSEMBLY for assembly ‘%.*ls’ failed because assembly ‘%.*ls’ is malformed or not a pure .NET assembly. %.*ls
6545 16 Enabling of execution statistics SET options is not allowed from within CLR procedure or function.
6546 16 Could not impersonate the execution context during the execution of ‘%.*ls’.
6547 16 An error occurred while getting method, property or field information for “%ls” of class “%ls” in assembly “%.*ls”.
6548 16 CREATE ASSEMBLY failed because the assembly references assembly ‘%.*ls’, which is owned by another user.
6549 16 A .NET Framework error occurred during execution of user defined routine or aggregate ‘%.*ls’: %ls. User transaction, if any, will be rolled back.
6550 16 %s failed because parameter counts do not match.
6551 16 %s for “%.*ls” failed because T-SQL and CLR types for return value do not match.
6552 16 %s for “%.*ls” failed because T-SQL and CLR types for parameter “%.*ls” do not match.
6553 16 %s failed because of an invalid .NET Framework calling convention. Use the default .NET Framework calling convention. 6554 16 SQL assembly name ‘%.*ls’, and .NET Framework assembly name ‘%.*ls’ do not match. Assembly names must match.
6555 16 Assembly ‘%.*ls’ already exists for owner ‘%.*ls’ in database ‘%.*ls’.
6556 16 %s failed because it could not find type ‘%s’ in assembly ‘%s’.
6557 16 %s failed because type ‘%s’ does not conform to %s
specification due to field ‘%s’.
6558 16 %s failed because type ‘%s’ does not conform to %s
specification due to method ‘%s’.
6559 20 Could not find type ID %d in database %.*ls. This is due to a schema inconsistency.
6560 16 %s failed because type ‘%s’ does not conform to %s
specification due to its invalid size: %d.
6561 16 Could not find file ‘%s’ in directory ‘%s%s’.
6562 16 Version mismatch between files ‘%s’ (%d.%d.%d) and ‘%s’ (%d.%d.%d).
6563 16 Method, property or field ‘%ls’ in class ‘%ls’ in assembly ‘%.*ls’ has invalid return type.
6564 16 The method ‘%ls’ in class ‘%ls’ in assembly ‘%.*ls’ has some invalid arguments.
6565 16 %s ASSEMBLY failed because the assembly source parameter %d is not a valid assembly.
6566 16 %s ASSEMBLY failed because the assembly source parameter %d is not a valid expression.
6567 16 %s failed because a CLR Procedure may only be defined on CLR methods that return either SqlInt32, System.Int32, void.
6568 16 A .NET Framework error occurred while getting information from class “%.*ls” in assembly “%.*ls”: %ls.
6569 16 ‘%.*ls’ failed because parameter %d is not allowed to be null and is not an output parameter.
6570 16 Method ‘%ls’ of class ‘%ls’ in assembly ‘%.*ls’ is generic. Generic methods are not supported.
6571 16 Class ‘%ls’ in assembly ‘%.*ls’ is generic. Generic types are not supported.
6572 16 More than one method, property or field was found with name ‘%ls’ in class ‘%ls’ in assembly ‘%.*ls’. Overloaded methods, properties or fields are not supported.
6573 16 Method, property or field ‘%ls’ of class ‘%ls’ in assembly ‘%.*ls’ is not static.
6574 16 Method, property or field ‘%ls’ of class ‘%ls’ in assembly ‘%.*ls’ is not public.
6575 16 Assembly names should be less than %d characters. Assembly name ‘%.*ls’ is too long.
6576 16 Type ‘%ls’ in assembly ‘%ls’ is not public.
6577 16 CREATE TYPE failed because type ‘%s’ does not conform to user defined type specification due to interface ‘%s’.
6578 16 Invalid attempt to continue operation after a severe error. 6579 16 Alter assembly from ‘%ls’ to ‘%ls’ is not a compatible upgrade.
6580 16 Declarations do not match for parameter %d. .NET Framework reference and T-SQL OUTPUT parameter declarations must match. 6581 16 Could not find assembly ‘%.*ls’ in directory ‘%.*ls’. 6582 16 Assembly ‘%.*s’ is not visible for creating SQL objects. Use ALTER ASSEMBLY to change the assembly visibility.
6584 16 Property or field ‘%ls’ for type ‘%ls’ in assembly ‘%ls’ is not static
6585 16 Could not impersonate the client during assembly file operation.
6586 16 Assembly ‘%.*ls’ could not be installed because existing policy would keep it from being used.
6587 16 Assembly reference ‘%ls’ was redirected by external policy to ‘%ls’
6588 16 Assembly file operations are not allowed for Windows NT users activated by SETUSER.
6589 16 DROP ASSEMBLY failed because the specified assemblies are referenced by assembly ‘%ls’.
6590 16 DROP ASSEMBLY failed because ‘%ls’ is referenced by object ‘%ls’.
6591 16 %s for “%.*ls” failed because first parameter of “%.*ls” method must be of type System.Object.
6592 16 Could not find property or field ‘%ls’ for type ‘%ls’ in assembly ‘%ls’.
6593 16 Property or field ‘%ls’ for type ‘%ls’ in assembly ‘%ls’ is static.
6594 16 Could not read from property ‘%ls’ for type ‘%ls’ in assembly ‘%ls’ because it does not have a get accessor.
6595 16 Could not assign to property ‘%ls’ for type ‘%ls’ in assembly ‘%ls’ because it is read only.
6596 16 %s ASSEMBLY failed because assembly ‘%ls’ is a system assembly. Consider creating a user assembly to wrap desired functionality. 6597 16 CREATE %s failed.
6598 16 DROP ASSEMBLY failed because ‘%ls’ is referenced by user defined type ‘%ls’.
6599 16 Found an empty native serialization class ‘%.*ls’. Empty native serialization classes are not allowed.
6600 16 XML error: %.*ls
6601 10 The XML parse error 0x%x occurred on line number %d, near the XML text “%.*ls”.
6602 16 The error description is ‘%.*ls’.
6603 16 XML parsing error: %.*ls
6605 16 %.*ls: Failed to obtain an IPersistStream interface on the XML text.
6607 16 %.*ls: The value supplied for parameter number %d is invalid.
6608 16 Failed to instantiate class “%ls”. Verify that Msxmlsql.dll exists in the SQL Server installation.
6609 16 Invalid data type for the column “%ls”. Allowed data types are CHAR/VARCHAR, NCHAR/NVARCHAR, TEXT/NTEXT, and XML.
6610 17 Failed to load Msxmlsql.dll.
6611 16 The XML data type is damaged.
6613 16 Specified value ‘%ls’ already exists.
6621 16 XML encoding or decoding error occurred with object name ‘%.*ls’.
6622 16 Invalid data type for column “%ls”. The data type cannot be text, ntext, image, binary, varchar(max), nvarchar(max), varbinary(max), or xml.
6623 16 Column ‘%ls’ contains an invalid data type. Valid data types are char, varchar, nchar, and nvarchar.
6624 16 XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents.
6625 16 Could not convert the value for OPENXML column ‘%ls’ to sql_variant data type. The value is too long. Change the data type of this column to text, ntext or image.
6626 16 Unexpected end of data stream.
6627 16 The size of the data chunk that was requested from the stream exceeds the allowed limit.
6628 16 %.*ls can only process untyped XML. Cast the input value to XML or to a string type.
6629 16 The result of the column expression for column “%ls” is not compatible with the requested type “XML”. The result must be an element, text node, comment node, processing instruction, or document node. 6630 16 Element-centric mapping must be used with OPENXML when one of the columns is of type XML.
6631 16 The requested OpenXML document is currently in use by another thread, and cannot be used.
6632 16 Invalid data type for the column “%ls”. User-defined types cannot be used in an OpenXML WITH clause.
6633 16 The version of MSXMLSQL.DLL that was found is older than the minimum required version. Found version “%d.%d.%d”. Require version “%d.%d.%d”.
6700 16 XQuery: The ‘ %ls’ operation is not supported.
6701 16 The version of the XML index that you are trying to use is not supported anymore. Please drop and recreate the XML index. 6716 16 XML Node ID is invalid. Re-build the database if the problem persists.
6717 16 XQuery: The document tree is too deep. If the problem persists you must simplify the XML hierarchy.
6718 16 XQuery: Invalid ordpath string: “%s”
6739 16 XQuery: SQL type ‘%s’ is not supported in XQuery.
6742 16 XQuery: Query too complex. Try reducing the number of query nesting levels. Example: combine several ‘/’ operations using a single ‘//’ operation.
6743 16 XQuery: The maximum allowed depth in XML instances is %d levels. One of the paths in the query tries to access nodes at a lower level.
6744 16 XQuery: One of the paths specified in the query is too deep. The maximum allowed depth is %d levels.
6745 16 XQuery: Internal compiler error.
6800 16 FOR XML AUTO requires at least one table for generating XML tags. Use FOR XML RAW or add a FROM clause with a table name. 6801 16 FOR XML EXPLICIT requires at least three columns, including the tag column, the parent column, and at least one data column. 6802 16 FOR XML EXPLICIT query contains the invalid column name ‘%.*ls’. Use the TAGNAME!TAGID!ATTRIBUTENAME[!..] format where TAGID is a positive integer.
6803 16 FOR XML EXPLICIT requires the first column to hold positive integers that represent XML tag IDs.
6804 16 FOR XML EXPLICIT requires the second column to hold NULL or nonnegative integers that represent XML parent tag IDs.
6805 16 FOR XML EXPLICIT stack overflow occurred. Circular parent tag relationships are not allowed.
6806 16 Undeclared tag ID %d is used in a FOR XML EXPLICIT query. 6807 16 Undeclared parent tag ID %d is used in a FOR XML EXPLICIT query.
6808 16 XML tag ID %d could not be added. The server memory
resources may be low.
6809 16 Unnamed tables cannot be used as XML identifiers as well as unnamed columns cannot be used for attribute names. Name unnamed columns/tables using AS in the SELECT statement.
6810 16 Column name ‘%.*ls’ is repeated. The same attribute cannot be generated more than once on the same XML tag.
6811 16 FOR XML is incompatible with COMPUTE expressions. Remove the COMPUTE expression.
6812 16 XML tag ID %d that was originally declared as ‘%.*ls’ is being redeclared as ‘%.*ls’.
6813 16 FOR XML EXPLICIT cannot combine multiple occurrences of ID, IDREF, IDREFS, NMTOKEN, and/or NMTOKENS in column name ‘%.*ls’. 6814 16 In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS require attribute names in ‘%.*ls’.
6815 16 In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS attributes cannot be hidden in ‘%.*ls’.
6816 16 In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS attributes cannot be generated as CDATA, XML, or XMLTEXT in ‘%.*ls’.
6817 16 FOR XML EXPLICIT cannot combine multiple occurrences of ELEMENT, XML, XMLTEXT, and CDATA in column name ‘%.*ls’.
6819 16 The FOR XML clause is not allowed in a %ls statement. 6820 16 FOR XML EXPLICIT requires column %d to be named ‘%ls’ instead of ‘%.*ls’.
6821 16 GROUP BY and aggregate functions are currently not supported with FOR XML AUTO.
6824 16 In the FOR XML EXPLICIT clause, mode ‘%.*ls’ in a column name is invalid.
6825 16 ELEMENTS option is only allowed in RAW, AUTO, and PATH modes of FOR XML.
6826 16 Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which they belong.
6827 16 FOR XML EXPLICIT queries allow only one XMLTEXT column per tag. Column ‘%.*ls’ declares another XMLTEXT column that is not permitted. 6828 16 XMLTEXT column ‘%.*ls’ must be of a string data type or of type XML.
6829 16 FOR XML EXPLICIT and RAW modes currently do not support addressing binary data as URLs in column ‘%.*ls’. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the ‘dbobject/TABLE[@PK1="V1"]/@COLUMN’ syntax.
6830 16 FOR XML AUTO could not find the table owning the following column ‘%.*ls’ to create a URL address for it. Remove the column, or use the BINARY BASE64 mode, or create the URL directly using the
‘dbobject/TABLE[@PK1="V1"]/@COLUMN’ syntax.
6831 16 FOR XML AUTO requires primary keys to create references for ‘%.*ls’. Select primary keys, or use BINARY BASE64 to obtain binary data in encoded form if no primary keys exist.
6832 16 FOR XML AUTO cannot generate a URL address for binary data if a primary key is also binary.
6833 16 Parent tag ID %d is not among the open tags. FOR XML EXPLICIT requires parent tags to be opened first. Check the ordering of the result set.
6834 16 XMLTEXT field ‘%.*ls’ contains an invalid XML document. Check the root tag and its attributes.
6835 16 FOR XML EXPLICIT field ‘%.*ls’ can specify the directive HIDE only once.
6836 16 FOR XML EXPLICIT requires attribute-centric IDREFS or NMTOKENS field ‘%.*ls’ to precede element-centric IDREFS/NMTOKEN fields. 6838 16 Attribute-centric IDREFS or NMTOKENS field not supported on tags having element-centric field ‘%.*ls’ of type TEXT/NTEXT or IMAGE. Either specify ELEMENT on IDREFS/NMTOKENS field or remove the ELEMENT directive.
6839 16 FOR XML EXPLICIT does not support XMLTEXT field on tag ‘%.*ls’ that has IDREFS or NMTOKENS fields.
6840 16 Neither XMLDATA nor XMLSCHEMA supports namespace elements or attributes such as ‘%.*ls’. Run the SELECT FOR XML statement without it or remove the namespace prefix declaration.
6841 16 FOR XML could not serialize the data for node ‘%.*ls’ because it contains a character (0x%04X) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.
6842 16 Could not serialize the data for node ‘%.*ls’ because it contains a character (0x%04X) which is not allowed in XML. To retrieve this data convert it to binary, varbinary or image data type
6843 16 FOR XML EXPLICIT: XML data types and CLR user defined types cannot be processed as CDATA in column name ‘%.*ls’. Consider converting XML to a string type. Consider converting CLR types to XML and then to a string type.
6844 16 Two (or more) elements named ‘%.*ls’ are of different types and not direct siblings in the same level.
6845 16 Two (or more) elements named ‘%.*ls’ are optional in the same level. Consider making them direct siblings or map NULL to xsi:nil 6846 16 XML name space prefix ‘%.*ls’ declaration is missing for FOR XML %.*ls name ‘%.*ls’.
6847 16 The column ‘%.*ls’ is of type sql_variant, which is not supported in attribute-centric FOR XML, with XML Schema.
6848 16 XMLDATA does not support the mapping of the type of column ‘%.*ls’ to an XDR type. Please use XMLSCHEMA instead for AUTO and RAW mode. 6849 16 FOR XML PATH error in column ‘%.*ls’ – ‘//’ and leading and trailing ‘/’ are not allowed in simple path expressions.
6850 16 %.*ls name ‘%.*ls’ contains an invalid XML identifier as required by FOR XML; ‘%c’(0x%04X) is the first character at fault. 6851 16 Column ‘%.*ls’ has invalid data type for attribute-centric XML serialization in FOR XML PATH.
6852 16 Attribute-centric column ‘%.*ls’ must not come after a non-attribute-centric sibling in XML hierarchy in FOR XML PATH. 6853 16 Column ‘%.*ls’: the last step in the path can’t be applied to XML data type or CLR UDT in FOR XML PATH.
6854 16 Invalid column alias ‘%.*ls’ for formatting column as XML processing instruction in FOR XML PATH – it must be in
‘processing-instruction(target)’ format.
6855 16 Inline schema is not supported with FOR XML PATH.
6856 16 FOR XML row XML tag name contains an invalid XML identifier; ‘%c’(0x%04X) is the first character at fault.
6857 16 FOR XML root XML tag name contains an invalid XML
identifier; ‘%c’(0x%04X) is the first character at fault.
6858 16 XML schema URI contains character ‘%c’(0x%04X) which is not allowed in XML.
6859 16 Row tag name is only allowed with RAW or PATH mode of FOR XML.
6860 16 FOR XML directive XMLDATA is not allowed with ROOT directive or row tag name specified.
6861 16 Empty root tag name can’t be specified with FOR XML. 6862 16 Empty FOR XML target inline schema URI is not allowed. 6863 16 Row tag omission (empty row tag name) is not compatible with XMLSCHEMA FOR XML directive.
6864 16 Row tag omission (empty row tag name) cannot be used with attribute-centric FOR XML serialization.
6865 16 FOR XML does not support CLR User Defined Types – cast CLR UDT explicitly into one of the supported types in FOR XML queries. 6866 16 Use of a system reserved XML schema URI is not allowed. 6867 16 ‘xmlns’ is invalid in XML tag name in FOR XML PATH, or when WITH XMLNAMESPACES is used with FOR XML.
6868 16 The following FOR XML features are not supported with WITH XMLNAMESPACES list: EXPLICIT mode, XMLSCHEMA and XMLDATA directives. 6869 16 Attempt to redefine namespace prefix ‘%.*ls’
6870 16 Prefix ‘%.*ls’ used in WITH XMLNAMESPACES clause contains an invalid XML identifier. ‘%c’(0x%04X) is the first character at fault. 6871 16 Prefix ‘%.*ls’ used in WITH XMLNAMESPACES is reserved and cannot be used as a user-defined prefix.
6872 16 XML namespace prefix ‘xml’ can only be associated with the URI http://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes.
6873 16 Redefinition of ‘xsi’ XML namespace prefix is not supported with ELEMENTS XSINIL option of FOR XML.
6874 16 Empty URI is not allowed in WITH XMLNAMESPACES clause. 6875 16 URI ‘%.*ls’ used in WITH XMLNAMESPACES is invalid.
‘%c’(0x%04X) is the first character at fault.
6876 16 URI used in WITH XMLNAMESPACES is too long. The maximum length is %d characters.
6877 16 Empty namespace prefix is not allowed in WITH XMLNAMESPACES clause.
6878 16 FORXML XMLSCHEMA cannot be used with a typed XML column whose schema collection is empty.
6901 16 XML Validation: XML instance must be a document.
6902 16 XML Validation: Invalid definition for type ‘%ls’. SQL Server does not currently support the use of the pattern or enumeration facet on lists of type QName.
6903 16 XML Validation: Invalid definition for type ‘%ls’. SQL Server does not currently support inclusion of ID, QName, or list of QName among the member types of a union type.
6904 16 XML Validation: Found duplicate attribute ‘%s’. Location: %s 6905 16 XML Validation: Attribute ‘%s’ is not permitted in this context. Location: %s
6906 16 XML Validation: Required attribute ‘%s’ is missing.
Location: %s
6907 16 Namespace URI too long: ‘%.*ls’.
6908 10 XML Validation: Invalid content. Expected element(s): %s. Location: %s
6909 16 XML Validation: Text node is not allowed at this location, the type was defined with element only content or with simple content. Location: %s
6910 16 XML Validation: Invalid definition for type ‘%ls’. SQL Server does not currently support restriction of union types. 6911 16 XML Validation: Found duplicate element ‘%s’ in all content model. Location: %s
6912 16 XML Validation: Element ‘%s’ found in text only content model. Location: %s
6913 16 XML Validation: Declaration not found for element ‘%s’. Location: %s
6914 16 XML Validation: Type definition for type ‘%s’ was not found, type definition is required before use in a type cast. Location: %s 6915 16 Element or attribute name too long: ‘%.*ls’.
6916 16 XML Validation: The content model of type or model group ‘%s’ is ambiguous and thus violates the unique particle attribution constraint. Consult SQL Server Books Online for more information. 6917 16 XML Validation: Element ‘%ls’ may not have xsi:nil=”true” because it was not defined as nillable or because it has a fixed value constraint. Location: %ls
6918 16 XML Validation: Element ‘%s’ must not have character or element children, because xsi:nil was set to true. Location: %s 6919 16 XML Validation: The type of element ‘%s’ is abstract. Instantiation requires the use of xsi:type to specify a non-abstract type. Location: %s
6920 16 Invalid definition for type ‘%ls’. Cannot specify
use=”prohibited” for attribute ‘%ls’ because there is no corresponding attribute in the base type.
6921 16 XML Validation: Element or attribute ‘%s’ was defined as fixed, the element value has to be equal to value of ‘fixed’ attribute specified in definition. Location: %s
6922 16 XML Validation: Not able to resolve namespace for
prefix:’%.*ls’
6923 16 XML Validation: Unexpected element(s): %s. Location: %s 6924 16 XML Validation: Text ‘%.*ls’ found in attribute-only content model. Location: %s
6925 16 Invalid definition for element ‘%ls’. SQL Server does not currently permit additions to existing substitution groups via ALTER XML SCHEMA COLLECTION.
6926 16 XML Validation: Invalid simple type value: ‘%s’. Location: %s
6927 16 XML Validation: Invalid simple type value: ‘%ls’.
6928 16 XML Validation: XML instances of the content model of type or model group ‘%ls’ can be validated in multiple ways and are not supported.
6929 16 XML Validation: Invalid QName for xsi:type attribute ‘%.*ls’.
6930 16 XML Validation: ID constraint check failed. Found attribute named ‘%.*ls’ with duplicate ID value ‘%.*ls’. Location: %s
6931 16 XML Validation: IDREF constraint check failed. Found attribute named ‘%.*ls’ with reference to ID value ‘%.*ls’, which does not exist
6932 16 Invalid definition for element or attribute ‘%s’. Value constraints on components of type ID are not allowed.
6933 16 XML Validation: Invalid simple type operation, inserting into simple type is not permitted. Location: %s
6934 16 XML Validation: Element ‘%s’ requires substitution, because it was defined as abstract. Location: %s
6935 16 XML Validation: ID or IDREF attribute exceeded the allowed maximum length. Location: %s
6936 16 XML Validation: Invalid cast for element ‘%s’ from type ‘%s’ to type ‘%s’. Location: %s
6937 16 XML Validation: The canonical form of the value ‘%ls’ is not valid according to the specified type. This can result from the use of pattern facets on non-string types or range restrictions or enumerations on floating-point types. Location: %ls
6938 16 XML Validation: The canonical form of the value ‘%ls’ is not valid according to the specified type. This can result from the use of pattern facets on non-string types or range restrictions or enumerations on floating-point types.
6940 16 Invalid component named ‘%s’ found in global scope. Only elements, attributes, types and groups can be defined in global context 6941 16 Invalid type definition for type ‘%s’, types with complex content can only be derived from base types which have complex content 6942 16 Invalid type definition for type ‘%s’, types with simple content can only be derived from base types which have simple content 6943 16 Invalid type definition for type ‘%s’, the derivation was illegal because ‘final’ attribute was specified on the base type 6944 16 Invalid type definition for type ‘%s’, ‘%s’ facet is not restricting the value space
6945 16 Invalid facet value for facet ‘%s’ in type definition ‘%s’ 6946 16 Invalid type definition for type ‘%s’, ‘minLength’ can not be greater than ‘maxLength’
6947 16 XML Validation: Multiple ID attributes found on a single element. Location: %s
6948 16 Invalid type definition for type ‘%s’, ‘minLength’ can not be greater than ‘Length’
6949 16 Invalid type definition for type ‘%s’, ‘Length’ can not be greater than ‘maxLength’
6950 16 Invalid type definition for type ‘%s’, ‘fractionDigits’ can not be greater than ‘totalDigits’
6951 16 Invalid type definition for type ‘%s’, ‘minInclusive’ must be less than or equal to ‘maxInclusive’ and less than ‘maxExclusive’ 6952 16 Invalid type definition for type ‘%s’, ‘minExclusive’ must be less than or equal to ‘maxExclusive’ and less than ‘maxInclusive’ 6953 16 Invalid type definition for type ‘%s’, recursive type definitions are not allowed
6954 16 Invalid group definition for group ‘%s’, recursive group definitions are not allowed
6955 16 Invalid attribute definition for attribute ‘%s’, attributes type has to be simple type
6956 16 Invalid type definition, fixed facets can not be redefined 6957 16 Invalid element definition, element ‘%s’ is not valid derivation of element ‘%s’
6958 16 Invalid definition for type ‘%s’. An ‘all’ group may not appear as the child or parent of any other model group, it must have minOccurs = maxOccurs = 1, its child elements must have maxOccurs = 1 6959 16 Invalid definition, top level group definitions can not have model groups as siblings
6960 16 Component ‘%s’ is outside of allowed range. Maximum for ‘fractionDigits’ is 10 and maximum number of digits for non fractional part is 28
6961 16 The system limit on the number of XML types has been reached. Redesign your database to use fewer XML types.
6962 16 ‘default’ and ‘fixed’ values are not allowed on element of this type: ‘%s’
6963 16 ‘Default’ or ‘Fixed’ value is longer than allowed, maximum length allowed is 4000 characters : ‘%s’
6964 16 Facet value is longer than allowed, maximum length allowed is 4000 characters : ‘%s’
6965 10 XML Validation: Invalid content. Expected element(s):%s where element ‘%s’ was specified. Location: %s
6966 10 Warning: Type ‘%s’ is restricted by a facet ‘%s’ that may impede full round-tripping of instances of this type
6967 16 Invalid type definition for type ‘%s’. The base and derived types must have the same value for ‘mixed’ unless deriving by restriction, in which case ‘false’ is always permitted for the derived type. 6968 16 Invalid type definition for type ‘%s’. Complex types cannot restrict simple types
6969 16 ID/IDREF validation consumed too much memory. Try reducing the number of ID and IDREF attributes. Rearranging the file so that elements with IDREF attributes appear after the elements which they reference may also be helpful.
6970 16 Invalid type definition for type ‘%s’. No type may have more than one attribute of any type derived from ID.
6971 16 Invalid type definition for type ‘%s’. Type contains attribute ‘%s’ which is not allowed in base type.
6972 16 Invalid redefinition of attribute ‘%s’ in type ‘%s’. Must be of a type which is a valid restriction of the corresponding attribute in the base type.
6973 16 Invalid redefinition of attribute ‘%s’ in type ‘%s’. Must be required in the derived type if it is required in the base type. 6974 16 Invalid redefinition of attribute ‘%s’ in type ‘%s’. Must be prohibited in the derived type if it is prohibited in the base type. 6975 16 Invalid redefinition of attribute ‘%s’ in type ‘%s’. Must be fixed to the same value as in the derived type.
6976 16 Invalid redefinition of attribute ‘%s’ in type ‘%s’. Derivation by extension may not redefine attributes.
6977 16 Invalid member type ‘%s’ in union type ‘%s’. Unions may not have complex member types.
6978 16 Invalid item type for list type ‘%s’. The item type of a list may not itself be a list, and union types and types derived from ID may not be used as item types in this release.
6979 16 Invalid restriction for type ‘%s’. The element in the restricted type must have the same name as and a more restrictive type than the corresponding element in the base type.
6980 16 Invalid restriction for type ‘%s’. The particle in the restricted type may not have an occurrence range more permissive than that of the corresponding particle in the base type.
6981 16 Invalid restriction for type ‘%s’. The element in the restricted type may not be nillable if the corresponding element in the base type is not.
6982 16 Invalid restriction for type ‘%s’. The element in the restricted type must be fixed to the same value as the corresponding element in the derived type.
6983 16 Invalid restriction for type ‘%s’. The element in the restricted type may not have a ‘block’ value more permissive than the corresponding element in the base type.
6984 16 Invalid restriction for type ‘%s’. The element in the restricted type must be in one of the namespaces allowed by the base type’s wildcard.
6985 16 Invalid restriction for type ‘%s’. The Wildcard in the restricted type must be a valid subset of the corresponding wildcard in the base type, and the processContents may not be more permissive. 6986 16 Invalid restriction for type ‘%s’. The effective total range of the model group in the restricted type must be a valid restriction of the occurrence range of the wildcard in the base type.
6987 16 Invalid restriction for type ‘%s’. An ‘all’ particle may be restricted only by ‘all’, ‘element’, or ‘sequence’.
6988 16 Invalid restriction for type ‘%s’. A ‘choice’ particle may be restricted only by ‘element’, ‘choice’, or ‘sequence’.
6989 16 Invalid restriction for type ‘%s’. A ‘sequence’ particle may be restricted only by ‘element’ or ‘sequence’.
6990 16 Invalid restriction for type ‘%s’. Invalid model group restriction.
6991 16 Invalid restriction for type ‘%s’. If the base type has empty content, then the derived type must as well, and if the derived type has empty content, then the base type must be emptiable.
6992 16 The content model of type ‘%s’ contains two elements with the same name ‘%s’ and different types, nillability, or value constraints. 6993 16 Value constraint on use of attribute ‘%s’ must be consistent with value constraint on its declaration.
6994 16 Invalid restriction for type ‘%s’. The attribute wildcard in the restricted type must be a valid subset of the corresponding attribute wildcard in the base type, and the processContents may not be more permissive.
6995 16 Invalid definition for type or element ‘%s’. SQL Server does not permit the built-in XML Schema types ‘ID’ and ‘IDREF’ or types derived from them to be used as the type of an element or as the basis for derivation by extension.
6996 16 Invalid type definition for type ‘%s’. A type may not have both ‘minInclusive’ and ‘minExclusive’ or ‘maxInclusive’ and ‘maxExclusive’ facets.
6997 16 Invalid definition for element ‘%s’. An element which has a fixed value may not also be nillable.
6998 16 Invalid type definition: Type or content model ‘%s’ is too complicated. It may be necessary to reduce the number of enumerations or the size of the content model.
6999 16 Invalid definition for element or attribute ‘%s’. Value constraints on components of type QName are not supported in this release. 7000 16 OPENXML document handle parameter must be of data type int. 7001 16 OPENXML flags parameter must be of data type int.
7002 16 OPENXML XPath must be of a string data type, such as nvarchar.
7003 16 Only one OPENXML column can be of type %ls.
7004 16 OPENXML does not support retrieving schema from remote tables, as in ‘%.*ls’.
7005 16 OPENXML requires a metaproperty namespace to be declared if ‘mp’ is used for another namespace in sp_xml_preparedocument. 7006 16 OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement.
7007 16 OPENXML encountered unknown metaproperty ‘%.*ls’.
7008 16 The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.
7009 16 OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument.
7101 16 You need an active user transaction in order to use text pointers for a table with the option “text in row” set to ON. 7102 20 Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.
7104 16 Offset or size of data type is not valid. Data type must be of type int or smallint.
7105 22 The Database ID %d, Page %S_PGID, slot %d for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
7106 16 Internal error: An attempt was made to update a LOB data type using a read-only text pointer.
7107 16 You can have only 1,024 in-row text pointers in one
transaction
7116 16 Offset %d is not in the range of available LOB data. 7117 16 Error reading large object (LOB) data from the tabular data stream (TDS).
7118 16 Only complete replacement is supported when assigning a large object (LOB) to itself.
7119 16 Attempting to grow LOB beyond maximum allowed size of 2,147,483,647 bytes.
7122 16 Invalid text, ntext, or image pointer type. Must be
binary(16).
7123 16 Invalid text, ntext, or image pointer value %hs.
7124 16 The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
7125 16 The text, ntext, or image pointer value conflicts with the column name specified.
7133 16 NULL textptr (text, ntext, or image pointer) passed to %ls function.
7135 16 Deletion length %ld is not in the range of available text, ntext, or image data.
7137 16 %s is not allowed because the column is being processed by a concurrent snapshot and is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS). 7138 16 The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS).
7139 16 Length of LOB data (%ld) to be replicated exceeds configured maximum %ld.
7140 16 Cannot create additional orphans with the stored procedure sp_createorphan. Free up some of the orphan handles that you have created by inserting or deleting them.
7141 16 Must create orphaned text inside a user transaction. 7143 16 Invalid locator de-referenced.
7144 16 A text/ntext/image column referenced by a persisted or indexed computed column cannot be updated
7151 16 Insufficient buffer space to perform write operation. 7201 17 Could not execute procedure on remote server ‘%.*ls’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access. 7202 11 Could not find server ‘%.*ls’ in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. 7212 16 Could not execute procedure ‘%.*ls’ on remote server ‘%.*ls’.
7213 20 The attempt by the provider to pass remote stored procedure parameters to remote server ‘%.*ls’ failed. Verify that the number of parameters, the order, and the values passed are correct.
7214 16 Remote procedure time out of %d seconds exceeded. Remote procedure ‘%.*ls’ is canceled.
7215 16 Could not execute statement on remote server ‘%.*ls’. 7221 16 Could not relay results of procedure ‘%.*ls’ from remote server ‘%.*ls’.
7301 16 Cannot obtain the required interface (“%ls”) from OLE DB provider “%ls” for linked server “%ls”.
7302 16 Cannot create an instance of OLE DB provider “%ls” for linked server “%ls”.
7303 16 Cannot initialize the data source object of OLE DB provider “%ls” for linked server “%ls”.
7304 16 Cannot connect using OLE DB provider “%ls” to linked server “%ls”. Verify the connection parameters or login credentials associated with this linked server.
7305 16 Cannot create a statement object using OLE DB provider “%ls” for linked server “%ls”.
7306 16 Cannot open the table “%ls” from OLE DB provider “%ls” for linked server “%ls”. %ls
7307 16 Cannot obtain the data source of a session from OLE DB provider “%ls” for linked server “%ls”. This action must be supported by the provider.
7308 16 OLE DB provider ‘%ls’ cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode. 7310 16 Cannot obtain the set of schema rowsets supported by OLE DB provider “%ls” for linked server “%ls”. The provider supports the interface, but returns a failure code when it is used.
7311 16 Cannot obtain the schema rowset “%ls” for OLE DB provider “%ls” for linked server “%ls”. The provider supports the interface, but returns a failure code when it is used.
7312 16 Invalid use of schema or catalog for OLE DB provider “%ls” for linked server “%ls”. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. 7313 16 An invalid schema or catalog was specified for the provider “%ls” for linked server “%ls”.
7314 16 The OLE DB provider “%ls” for linked server “%ls” does not contain the table “%ls”. The table either does not exist or the current user does not have permissions on that table.
7315 16 The OLE DB provider “%ls” for linked server “%ls” contains multiple tables that match the name “%ls”.
7316 16 Cannot use qualified table names (schema or catalog) with the OLE DB provider “%ls” for linked server “%ls” because it does not implement required functionality.
7317 16 The OLE DB provider “%ls” for linked server “%ls” returned an invalid schema definition.
7318 16 The OLE DB provider “%ls” for linked server “%ls” returned an invalid column definition for table “%ls”.
7319 16 The OLE DB provider “%ls” for linked server “%ls” returned a “%ls” index “%ls” with the incorrect bookmark ordinal %d.
7320 16 Cannot execute the query “%ls” against OLE DB provider “%ls” for linked server “%ls”. %ls
7321 16 An error occurred while preparing the query “%ls” for execution against OLE DB provider “%ls” for linked server “%ls”. %ls 7322 16 A failure occurred while giving parameter information to OLE DB provider “%ls” for linked server “%ls”.
7323 16 An error occurred while submitting the query text to OLE DB provider “%ls” for linked server “%ls”.
7324 16 A failure occurred while setting parameter properties with OLE DB provider “%ls” for linked server “%ls”.
7325 16 Objects exposing columns with user-defined types are not allowed in distributed queries. Please use a pass-through query to access remote object ‘%ls’.
7330 16 Cannot fetch a row from OLE DB provider “%ls” for linked server “%ls”.
7331 16 Rows from OLE DB provider “%ls” for linked server “%ls” cannot be released.
7332 16 Cannot rescan the result set from OLE DB provider “%ls” for linked server “%ls”. %ls
7333 16 Cannot fetch a row using a bookmark from OLE DB provider “%ls” for linked server “%ls”.
7339 16 OLE DB provider ‘%ls’ for linked server ‘%ls’ returned invalid data for column ‘%ls.%ls’.
7340 16 Cannot create a column accessor for OLE DB provider “%ls” for linked server “%ls”.
7341 16 Cannot get the current row value of column “%ls.%ls” from OLE DB provider “%ls” for linked server “%ls”. %ls
7342 16 An unexpected NULL value was returned for column “%ls.%ls” from OLE DB provider “%ls” for linked server “%ls”. This column cannot be NULL.
7343 16 The OLE DB provider “%ls” for linked server “%ls” could not %ls table “%ls”. %ls
7344 16 The OLE DB provider “%ls” for linked server “%ls” could not %ls table “%ls” because of column “%ls”. %ls
7345 16 The OLE DB provider “%ls” for linked server “%ls” could not delete from table “%ls”. %ls
7346 16 Cannot get the data of the row from the OLE DB provider “%ls” for linked server “%ls”. %ls
7347 16 OLE DB provider ‘%ls’ for linked server ‘%ls’ returned data that does not match expected data length for column ‘%ls.%ls’. The (maximum) expected data length is %ls, while the returned data length is %ls. 7348 16 The OLE DB provider “%ls” for linked server “%ls” could not set the range for table “%ls”. %ls. For possible cause of this issue, see the extended error message.
7349 16 The OLE DB provider “%ls” for linked server “%ls” could not set the range for table “%ls” because of column “%ls”. %ls
7350 16 Cannot get the column information from OLE DB provider “%ls” for linked server “%ls”.
7351 16 The OLE DB provider “%ls” for linked server “%ls” could not map ordinals for one or more columns of object “%ls”.
7352 16 The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata. The object “%ls” was missing the expected column “%ls”.
7353 16 The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
7354 16 The OLE DB provider “%ls” for linked server “%ls” supplied invalid metadata for column “%ls”. %ls
7355 16 The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata for a column. The name was changed at execution time. 7356 16 The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata for a column. The column “%ls” (compile-time ordinal %hd) of object “%ls” was reported to have a “%ls” of %ld at compile time and %ld at run time.
7357 16 Cannot process the object “%ls”. The OLE DB provider “%ls” for linked server “%ls” indicates that either the object has no columns or the current user does not have permissions on that object.
7358 16 Cannot execute the query. The OLE DB provider “%ls” for linked server “%ls” did not provide an appropriate interface to access the text, ntext, or image column “%ls.%ls”.
7359 16 The OLE DB provider “%ls” for linked server “%ls” reported a change in schema version between compile time (“%ls”) and run time (“%ls”) for table “%ls”.
7360 16 Cannot get the length of a storage object from OLE DB provider “%ls” for linked server “%ls” for table “%ls”, column “%ls”. 7361 16 Cannot read a storage object from OLE DB provider “%ls” for linked server “%ls”, for table “%ls”, column “%ls”.
7362 16 The OLE DB provider “%ls” for linked server “%ls” reported different metadata at run time for table “%ls”, column “%ls”. 7365 16 Cannot obtain optional metadata columns of columns rowset from OLE DB provider “%ls” for linked server “%ls”.
7366 16 Cannot obtain columns rowset from OLE DB provider “%ls” for linked server “%ls”.
7367 16 The OLE DB provider “%ls” for linked server “%ls” supports column level collation, but failed to provide the metadata column “%ls” at run time.
7368 16 The OLE DB provider “%ls” for linked server “%ls” supports column level collation, but failed to provide collation data for column “%ls”.
7369 16 The OLE DB provider ‘%ls’ for linked server ‘%ls’ provided invalid collation. LCID = %08x, Compflags = %08x, SortOrder = ‘%.*ls’. 7370 16 One or more properties could not be set on the query for OLE DB provider “%ls” for linked server “%ls”. %ls
7371 16 The server option ‘collation name’ in linked server ‘%ls’ for OLE DB provider ‘%ls’ has collation id %08x which is not supported by SQL Server.
7372 16 Cannot get properties from OLE DB provider “%ls” for linked server “%ls”.
7373 16 Cannot set the initialization properties for OLE DB provider “%ls” for linked server “%ls”.
7374 16 Cannot set the session properties for OLE DB provider “%ls” for linked server “%ls”.
7375 16 Cannot open index “%ls” on table “%ls” from OLE DB provider “%ls” for linked server “%ls”. %ls
7376 16 Could not enforce the remote join hint for this query. 7377 16 Cannot specify an index hint for a remote data source. 7390 16 The requested operation could not be performed because OLE DB provider “%ls” for linked server “%ls” does not support the required transaction interface.
7391 16 The operation could not be performed because OLE DB provider “%ls” for linked server “%ls” was unable to begin a distributed transaction. 7392 16 Cannot start a transaction for OLE DB provider “%ls” for linked server “%ls”.
7393 16 The OLE DB provider “%ls” for linked server “%ls” reported an error 0x%08X aborting the current transaction.
7394 16 The OLE DB provider “%ls” for linked server “%ls” reported an error committing the current transaction.
7395 16 Unable to start a nested transaction for OLE DB provider “%ls” for linked server “%ls”. A nested transaction was required because the XACT_ABORT option was set to OFF.
7396 16 Varchar(max), nvarchar(max) and varbinary(max) data types are not supported as return value or output parameter to remote queries. 7397 16 Remote function returned varchar(max), nvarchar(max) or varbinary(max) value which is not supported.
7399 16 The OLE DB provider “%ls” for linked server “%ls” reported an error. %ls
7401 16 The OLE DB provider “%ls” returned invalid literal
prefix/suffix string.
7403 16 The OLE DB provider “%ls” has not been registered.
7404 16 The server could not load DCOM.
7405 16 Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. 7409 16 Could not start distributed query using integrated login because the user is logged in using SQL Server authentication. Provide remote server login user ID and password in the connection string. 7410 16 Remote access is not allowed for impersonated security context.
7411 16 Server ‘%.*ls’ is not configured for %ls.
7412 16 OLE DB provider “%ls” for linked server “%ls” returned message “%ls”.
7413 16 Could not connect to linked server ‘%ls’ (OLE DB Provider ‘%ls’). Enable delegation or use a remote SQL Server login for the current user.
7414 16 Invalid number of parameters. Rowset ‘%ls’ expects %d parameter(s).
7415 16 Ad hoc access to OLE DB provider ‘%ls’ has been denied. You must access this provider through a linked server.
7416 16 Access to the remote server is denied because no
login-mapping exists.
7417 16 GROUP BY ALL is not supported in queries that access remote tables if there is also a WHERE clause in the query.
7418 16 Text, image, or ntext column was too large to send to the remote data source due to the storage interface used by the provider. 7419 16 Lazy schema validation error. Linked server schema version has changed. Re-run the query.
7420 16 Remote access is not supported for transaction isolation level “%ls”.
7421 10 Cannot fetch the rowset from OLE DB provider “%ls” for linked server “%ls”. %ls.
7422 16 OLE DB provider “%ls” for linked server “%ls” returned an invalid index definition for table “%ls”.
7423 16 The ‘%ls’ OLE DB provider for the ‘%ls’ linked server returned an invalid user-defined type definition for the ‘%ls’ table. 7424 10 OLE DB provider “%ls” for linked server “%ls” returned “%ls” with data type “%ls”, which should be type “%ls”.
7425 10 OLE DB provider “%ls” for linked server “%ls” returned an incorrect value for “%ls”, which should be “%ls”.
7426 10 OLE DB provider “%ls” for linked server “%ls” returned “%ls” without “%ls” being supported.
7427 10 OLE DB provider “%ls” for linked server “%ls” returned “%ls” for “%ls” during statistics gathering.
7428 10 OLE DB provider “%ls” for linked server “%ls” supported the schema lock interface, but returned “%ls” for “%ls”.
7429 10 %hsSQL Server Remote Metadata Gather Time for Table
%s.%s:%hs, CPU time = %lu ms, elapsed time = %lu ms.
7430 16 Out-of-process use of OLE DB provider “%ls” with SQL Server is not supported.
7431 16 Unable to delete OLE DB parameter properties.
7432 16 Heterogeneous queries and use of OLEDB providers are not supported in fiber mode.
7601 16 Cannot use a CONTAINS or FREETEXT predicate on %S_MSG ‘%.*ls’ because it is not full-text indexed.
7602 16 The full-text service (msftesql%ls%ls) is not available. The system administrator must start this service.
7604 17 Full-text operation failed due to a time out.
7606 17 Could not find full-text index for database ID %d, table or indexed view ID %d.
7607 17 Search on full-text catalog ‘%ls’ for database ID %d, table or indexed view ID %d with search condition ‘%ls’ failed with unknown result (0x%x).
7608 16 An unknown full-text failure (0x%x) occurred during “%hs”. 7609 17 Full-Text Search is not installed, or a full-text component cannot be loaded.
7610 16 Access is denied to “%.*ls”, or the path is invalid. 7613 16 Cannot drop index ‘%.*ls’ because it enforces the full-text key for table or indexed view ‘%.*ls’.
7614 16 Cannot alter or drop column ‘%.*ls’ because it is enabled for Full-Text Search.
7615 16 A CONTAINS or FREETEXT predicate can only operate on one table or indexed view. Qualify the use of * with a table or indexed view name.
7616 16 Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. The functionality to disable and enable full-text search for a database is deprecated. Please change your application.
7617 16 Query does not reference the full-text indexed table or indexed view.
7619 16 The execution of a full-text query failed. “%ls”
7620 16 The conversion to data type %ls failed for the full-text search key.
7621 16 Invalid use of full-text predicate in the HAVING clause. 7622 17 There is not sufficient disk space to complete this
operation for the full-text catalog “%ls”.
7624 16 Full-text catalog ‘%ls’ is in an unusable state. Drop and re-create this full-text catalog.
7625 16 Full-text table or indexed view has more than one LCID among its full-text indexed columns.
7626 15 The top_n_by_rank argument (‘%d’) must be greater than zero. 7627 16 Cannot create the full-text catalog in the directory “%.*ls” for the clustered server. Only directories on a disk in the cluster group of the server can be used.
7629 17 Cannot open or query the full-text default path registry key. The full-text default catalog path is invalid.
7630 15 Syntax error near ‘%.*ls’ in the full-text search condition ‘%.*ls’.
7632 15 The value of the Weight argument must be between 0.0 and 1.0.
7636 10 Warning: Request to start a full-text index population on table or indexed view ‘%.*ls’ is ignored because a population is currently active for this table or indexed view.
7638 10 Warning: Request to stop change tracking has deleted all changes tracked on table or indexed view ‘%ls’.
7640 10 Warning: Request to stop tracking changes on table or indexed view ‘%.*ls’ will not stop population currently in progress on the table or indexed view.
7641 16 Full-Text catalog ‘%ls’ does not exist in database ‘%.*ls’ or user does not have permission to perform this action.
7642 16 A full-text catalog named ‘%ls’ already exists in this database. Use a different name.
7644 16 Full-text crawl manager has not been initialized. Any crawl started before the crawl manager was fully initialized will need to be restarted. Please restart SQL Server and retry the command. You should also check the error log to fix any failures that might have caused the crawl manager to fail.
7645 16 Null or empty full-text predicate.
7646 16 Fulltext predicate references columns from two different tables or indexed views ‘%.*ls’ and ‘%.*ls’ which is not allowed. 7647 10 Warning: Configuration of full-text catalog at ‘%ls’ could not be saved during detach database.
7648 10 Warning: Failed to attach full-text catalog ‘%ls’.
7649 10 Warning: Failed to dismount full-text catalog at ‘%ls’. 7650 10 Warning: Failed to drop full-text catalog at ‘%ls’.
7651 10 Warning: The ongoing population is necessary to ensure an up-to-date index. If needed, stop change tracking first, and then deactivate the full-text index population.
7652 16 A full-text index for table or indexed view ‘%.*ls’ has already been created.
7653 16 ‘%ls’ is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, and has maximum size of %d bytes. Choose another index for the full-text key.
7654 16 Unable to obtain the population status of the table or indexed view ‘%.*ls’.
7655 16 TYPE COLUMN option must be specified with column of image or varbinary(max) type.
7656 16 Full-text index for table or indexed view ‘%.*ls’ cannot be populated because the database is in single-user access mode. 7657 10 Warning: Table or indexed view ‘%.*ls’ has full-text indexed columns that are of type image, text, or ntext. Full-text change tracking cannot track WRITETEXT or UPDATETEXT operations performed on these columns. 7658 16 Table or indexed view ‘%.*ls’ does not have a full-text index or user does not have permission to perform this action. 7659 16 Cannot activate full-text search for table or indexed view ‘%.*ls’ because no columns have been enabled for full-text search. 7660 16 Full-text search must be activated on table or indexed view ‘%.*ls’ before this operation can be performed.
7661 10 Warning: Full-text change tracking is currently enabled for table or indexed view ‘%.*ls’.
7662 10 Warning: Full-text auto propagation is currently enabled for table or indexed view ‘%.*ls’.
7663 16 Option ‘WITH NO POPULATION’ should not be used when change tracking is enabled.
7664 16 Full-text change tracking must be started on table or indexed view ‘%.*ls’ before the changes can be flushed.
7665 16 Full Crawl must be executed on table or indexed view ‘%.*ls’. Columns affecting the index have been added or dropped since the last index full population.
7666 16 User does not have permission to perform this action. 7668 16 Cannot drop full-text catalog ‘%ls’ because it contains a full-text index.
7669 10 Warning: Full-text index for table or indexed view ‘%.*ls’ cannot be populated because the database is in single-user access mode. Change tracking is stopped for this table or indexed view.
7670 16 Column ‘%.*ls’ cannot be used for full-text search because it is not a character-based, image, or varbinary(max) type column. 7671 16 Column ‘%.*ls’ cannot be used as full-text type column for image column. It must be a character-based column with a size less or equal than %d characters.
7672 16 A full-text index cannot be created on the table or indexed view because duplicate column ‘%.*ls’ is specified.
7673 10 Warning: Full-text change tracking is currently disabled for table or indexed view ‘%.*ls’.
7674 10 Warning: The fulltext catalog ‘%.*ls’ is being dropped and is currently set as default.
7676 10 Warning: Full-text auto propagation is on. Stop crawl request is ignored.
7677 16 Column “%.*ls” is not full-text indexed.
7678 16 The following string is not defined as a language alias in syslanguages: %.*ls.
7679 16 Full-text index language of column “%.*ls” is not a language supported by full-text search.
7680 16 Default full-text index language is not a language supported by full-text search.
7681 10 Warning: Directory ‘%ls’ does not have a valid full-text catalog. Full-text catalog header file or attach state file either is missing or corrupted. The full-text catalog cannot be attached. 7682 10 The component ‘%ls’ reported error while indexing. Component path ‘%ls’.
7683 16 Errors were encountered during full-text index population for table or indexed view ‘%ls’, database ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’). Please see full-text crawl logs for details. 7684 10 Error ‘%ls’ occurred during full-text index population for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’), full-text key value 0x%ls. Failed to index the row.
7685 10 Error ‘%ls’ occurred during full-text index population for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’), full-text key value 0x%ls. Attempt will be made to reindex it. 7689 16 Execution of a full-text operation failed. ‘%ls’
7690 16 Full-text operation failed because database is read only. 7691 16 Access is denied to full-text log path. Full-text logging is disabled for database ‘%ls’, catalog ‘%ls’ (database ID ‘%d’, catalog ID ‘%d’).
7692 16 Full-text catalog path ‘%.*ls’ exceeded %d character limit. 7693 16 Full-text initialization failed to create a memory clerk. 7694 16 Failed to pause full-text catalog for backup. Backup was aborted. Check to make sure Microsoft Full-text Service is running properly and SQL server service have access to full-text service.
7695 16 Operation failed. Full-text catalog backup in progress. Retry after backup operation has completed.
7696 16 Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed. 7697 10 Warning: Full-text index on table or indexed view ‘%.*ls’ in database ‘%.*ls’ has been changed after full-text catalog files backup. A full population is required to bring full-text index to a consistent state. 7698 16 GROUP BY ALL cannot be used in full text search queries. 7699 16 TYPE COLUMN option is not allowed for column types other than image or varbinary(max).
7702 16 Empty Partition function type-parameter-list is not allowed when defining a partition function.
7703 16 Can not create RANGE partition function with multiple parameter types.
7704 16 The type ‘%.*ls’ is not valid for this operation.
7705 16 Could not implicitly convert range values type specified at ordinal %d to partition function parameter type.
7706 16 Partition function ‘%ls’ is being used by one or more partition schemes.
7707 16 The associated partition function ‘%ls’ generates more partitions than there are file groups mentioned in the scheme ‘%ls’. 7708 16 Duplicate range boundary values are not allowed in partition function boundary values list. Partition boundary values at ordinal %d and %d are equal.
7709 10 Warning: Range value list for partition function ‘%.*ls’ is not sorted by value. Mapping of partitions to filegroups during CREATE PARTITION SCHEME will use the sorted boundary values if the function ‘%.*ls’ is referenced in CREATE PARTITION SCHEME.
7710 10 Warning: The partition scheme ‘%.*ls’ does not have any next used filegroup. Partition scheme has not been changed.
7712 10 Partition scheme ‘%.*ls’ has been created successfully. ‘%.*ls’ is marked as the next used filegroup in partition scheme ‘%.*ls’. 7713 10 %d filegroups specified after the next used filegroup are ignored.
7714 16 Partition range value is missing.
7715 16 The specified partition range value could not be found. 7716 16 Can not create or alter a partition function to have zero partitions.
7717 16 The partition scheme “%.*ls” is currently being used to partition one or more tables.
7718 16 Partition range value cannot be specified for hash
partitioning.
7719 16 CREATE/ALTER partition function failed as only a maximum of %d partitions can be created.
7720 16 Data truncated when converting range values to the partition function parameter type. The range value at ordinal %d requires data truncation.
7721 16 Duplicate range boundary values are not allowed in partition function boundary values list. The boundary value being added is already present at ordinal %d of the boundary value list.
7722 16 Invalid partition number %I64d specified for %S_MSG ‘%.*ls’, partition number can range from 1 to %d.
7723 16 Only a single filegroup can be specified while creating partition scheme using option ALL to specify all the filegroups. 7724 16 Computed column cannot be used as a partition key if it is not persisted. Partition key column ‘%.*ls’ in table ‘%.*ls’ is not persisted.
7725 16 Alter partition function statement failed. Cannot
repartition table ‘%.*ls’ by altering partition function ‘%.*ls’ because its clustered index ‘%.*ls’ is disabled.
7726 16 Partition column ‘%.*ls’ has data type %s which is different from the partition function ‘%.*ls’ parameter data type %s.
7727 16 Collation of partition column ‘%.*ls’ does not match collation of corresponding parameter in partition function ‘%.*ls’. 7729 16 Cannot specify partition number in the alter index statement as the index ‘%.*ls’ is not partitioned.
7730 16 Alter index statement failed because partition number %d does not exist in index ‘%.*ls’.
7731 16 Cannot specify partition number in Alter index statement to rebuild or reorganize a partition of %S_MSG ‘%.*ls’.
7732 16 Cannot specify partition number in Alter index statement along with keyword ALL to rebuild partitions of table ‘%.*ls’ when the table does not have any regular indexes.
7733 16 ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ is partitioned while %S_MSG ‘%.*ls’ is not partitioned.
7734 10 The %S_MSG ‘%.*ls’ specified for the clustered index ‘%.*ls’ was used for table ‘%.*ls’ even though %S_MSG ‘%.*ls’ is specified for it. 7735 16 Cannot specify partition number in Alter index statement to reorganize a partition of %S_MSG ‘%.*ls’ as %S_MSG is not partitioned. 7736 16 Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning. 7801 15 The required parameter %.*ls was not specified.
7802 16 Functions that have a return type of “%.*ls” are unsupported through SOAP invocation.
7803 15 The clause %.*ls can not be used in the %.*ls statement. 7804 15 %.*ls and %.*ls can not share the same value.
7805 16 The parameter SITE can not be prefixed by a scheme such as ‘http://’. Valid values for SITE include {‘*’ | ‘+’ | ‘site_name’}. 7806 16 The URL specified by endpoint ‘%.*ls’ is already registered to receive requests or is reserved for use by another service. 7807 16 An error (’0x%x’) occurred while attempting to register the endpoint ‘%.*ls’.
7808 10 The endpoint ‘%.*ls’ could not be unregistered.
7809 10 Cannot find the object ‘%.*ls’, because it does not exist or you do not have permission.
7810 15 The value ‘%d’ is not within range for the ‘%.*ls’
parameter.
7811 16 COMPUTE BY queries are not supported over SOAP.
7812 10 The endpoint ‘%.*ls’ has been established in metadata, but HTTP listening has not been enabled because HTTP support did not start successfully. Verify that the operating system supports native HTTP access. Check the SQL Server error log for any errors while starting HTTP support. 7813 16 The parameter PATH must be supplied in its canonical form. An acceptable PATH is ‘%.*ls’.
7814 10 The specified value ‘%.*ls’ already exists.
7815 10 The specified value ‘%.*ls’ does not exist.
7816 15 A duplicate parameter was specified, ‘%.*ls’.
7817 16 The Base64 encoded input data was malformed for the
parameter “%.*ls”.
7818 16 The request exceeds an internal limit. Simplify or reduce the size of the request.
7819 15 The SOAP method object ‘%.*ls’ must be specified using a fully qualified three-part name.
7820 16 SOAP namespaces beginning with ‘%.*ls’ are disallowed because they are reserved for system use.
7821 10 Cannot find the database ‘%.*ls’, because it does not exist or you do not have permission.
7822 16 An unexpected XML node “%.*ls” (in the namespace “%.*ls”) was found in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
7823 16 The “%.*ls” XML element (in the “%.*ls” namespace) was expected in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
7824 16 The “%.*ls” XML element (in the “%.*ls” namespace) was expected as the topmost node of the SOAP request.
7825 16 A SOAP method element was expected in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
7826 16 Unexpected character data was found in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
7827 14 The user does not have permission to reserve and unreserve HTTP namespaces.
7828 11 The statement is not supported on this version of the operating system. Could not find Httpapi.dll in the path.
7829 11 The statement is not supported on this version of the operating system. Could not find function entry point ‘%.*ls’ in Httpapi.dll.
7830 16 Unable to complete the operation because of an unexpected error.
7831 16 A reservation for this HTTP namespace (%.*ls) already exists.
7832 16 A reservation for this HTTP namespace (%.*ls) does not exist.
7833 16 The HTTP namespace (%.*ls) is in an invalid format. Specify the namespace in its canonical form.
7834 10 The reservation for the HTTP namespace (%.*ls) has been deleted. If there are any endpoints associated with this namespace, they will continue to receive and process requests until the server is restarted. 7835 16 Endpoint ‘%.*ls’ has been disabled because it is insecurely configured. For a more information, attempt to start the endpoint using the ALTER ENDPOINT statement.
7847 16 Xml data was found in the parameter ‘%.*ls’ which is not an Xml parameter. Please entitize any invalid Xml character data in this parameter, or pass the parameter in typed as xsd:anyType or sqltypes:xml 7848 15 An invalid or unsupported localeId was specified for parameter “%.*ls”.
7849 15 Invalid sqlCompareOptions were specified for parameter “%.*ls”.
7850 16 The user ‘%.*ls’ does not have permission to register endpoint ‘%.*ls’ on the specified URL. Please ensure the URL refers to a namespace that is reserved for listening by SQL.
7851 15 The %.*ls attribute must be specified on the %.*ls element of the parameter “%.*ls” because it is of type %.*ls.
7852 15 Parameter “%.*ls”: If the %.*ls attribute appears on a parameter value node of type “%.*ls” (in the namespace “%.*ls”), it must refer to a .NET user-defined type.
7853 16 The URL specified as the path (“%.*ls”) is not in an absolute format, and must begin with “%.*ls”.
7854 16 The URL value specified for the “%.*ls” parameter is too long.
7855 15 Reading from HTTP input stream failed.
7856 16 XML parameters do not support non-unicode element or attribute values.
7857 16 Parameter “%.*ls”: Function or procedure parameters with improperly formatted or deprecated names are not supported through Native SOAP access. Refer to documentation for rules concerning the proper naming of parameters.
7858 16 The “%.*ls” XML element (in the “%.*ls” namespace) in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request contained an invalid binary type.
7859 15 Parameter “%.*ls”: Parameter collation cannot be specified on the “%.*ls” node (in the namespace “%.*ls”).
7860 15 An endpoint’s transport or content cannot be changed through the ALTER ENDPOINT statement. Use DROP ENDPOINT and execute the CREATE ENDPOINT statement to make these changes.
7861 15 “%.*ls” endpoints can only be of the “FOR %.*ls” type. 7862 16 An endpoint of the requested type already exists. Only one endpoint of this type is supported. Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.
7863 16 The endpoint was not changed. The ALTER ENDPOINT statement did not contain any values to modify or update.
7864 16 CREATE/ALTER ENDPOINT cannot be used to update the endpoint with this information. The Dedicated Administrator Connection endpoint is reserved and cannot be updated.
7865 16 Web Services Description Language (WSDL) generation failed because the system was unable to query the metadata for the endpoint. 7866 16 XML attribute and element values larger than 4000 characters are only allowed within the SOAP Body node.
7867 15 An invalid sqlCollationVersion was specified for parameter “%.*ls”.
7868 15 An invalid sqlSortId was specified for parameter “%.*ls”. 7869 16 The endpoint name ‘%.*ls’ is reserved for used by SQL. Endpoint names cannot begin with ‘%.*ls’.
7870 16 The AFFINITY clause is not supported for endpoints of this type.
7871 16 The clause “%.*ls” is not valid for this endpoint type. 7872 16 “%.*ls” is not a parameter for procedure “%.*ls”, or it was supplied out of order.
7873 16 The endpoint “%.*ls” is a built-in endpoint and cannot be dropped. Use the protocol configuration utilities to ADD or DROP Transact-SQL endpoints.
7874 16 An endpoint already exists with the bindings specified. Only one endpoint supported for a specific binding. Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement. 7875 16 An unexpected XML construct was found in the character data of the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request. 7876 16 Anonymous support is not supported on HTTP endpoints. 7877 16 ANONYMOUS support is not available on HTTP endpoints in conjunction with any other authentication scheme.
7878 16 This “%.*ls ENDPOINT” statement is not supported on this edition of SQL Server.
7879 10 SQL Server is waiting for %d remaining sessions and
connections to close. If these sessions are not closed within a reasonable amount of time, “polite” shutdown will be aborted. This message may appear several times before SQL Server is shutdown.
7880 10 SQL Server has successfully finished closing sessions and connections.
7881 10 SQL Server was unable to close sessions and connections in a reasonable amount of time and is aborting “polite” shutdown. 7882 16 OUTPUT was requested for parameter ‘%.*ls’, which is not supported for a WEBMETHOD with FORMAT=NONE.
7883 16 User-defined functions cannot be used for a WEBMETHOD with FORMAT=NONE.
7884 20 Violation of tabular data stream (TDS) protocol. This is most often caused by a previous exception on this task. The last exception on the task was error %d, severity %d, address 0x%p. This connection will be terminated.
7885 20 Network error 0x%lx occurred while sending data to the client. A common cause for this error is if the client disconnected without reading the entire response from the server. This connection will be terminated.
7886 20 A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated. 7887 20 The IPv6 address specified is not supported. Only addresses that are in their numeric, canonical form are supported for listening. 7888 20 The IPv6 address specified is not supported. The server may not configured to allow for IPv6 connectivity, or the address may not be in a recognized IPv6 format.
7889 16 The SOAP headers on the request have exceeded the size limits established for this endpoint. The endpoint owner may increase these limits via ALTER ENDPOINT.
7890 16 An error occurred while attempting to register the endpoint ‘%.*ls’. One or more of the ports specified in the CREATE ENDPOINT statement may be bound to another process. Attempt the statement again with a different port or use netstat to find the application currently using the port and resolve the conflict.
7891 10 Creation of a TSQL endpoint will result in the revocation of any ‘Public’ connect permissions on the ‘%.*ls’ endpoint. If ‘Public’ access is desired on this endpoint, reapply this permission using ‘GRANT CONNECT ON ENDPOINT::[%.*ls] to [public]‘.

7892 16 Internal subset DTDs inside SOAP requests are not allowed. 7893 15 Parameter ‘%.*ls’: Incompatible XML attributes were present. The ‘%.*ls’ attribute and the ‘%.*ls’ attribute may not both be present on a parameter value node of type ‘%.*ls’ (in the namespace ‘%.*ls’).
7894 16 Listening has not been started on the endpoint ‘%.*ls’ found in metadata. Endpoint operations are disabled on this edition of SQL Server.
7895 14 Only a system administrator can specify a custom WSDL stored procedure on the endpoint.
7901 16 The repair statement was not processed. This level of repair is not supported when the database is in emergency mode.
7902 16 Temporary: The FileStream check found a problem in object ID %d, index ID %d, partition ID %I64d.
7903 16 Table error: The orphaned file “%.*ls” was found in the FileStream directory for object ID %d, index ID %d, partition ID %I64d, column ID %d.
7904 16 Table error: The FileStream file for column ID %d, ROWGUID %.*ls, in object ID %d, index ID %d, partition ID %I64d was not found. 7905 16 Database error: The directory “%.*ls” is not a valid FileStream directory.
7906 16 Database error: The file “%.*ls” is not a valid FileStream file.
7907 16 Table error: The directory “%.*ls” in partition ID %I64d is not a valid FileStream directory.
7908 16 Table error: The file “%.*ls” in the partition ID %I64d is not a valid FileStream file.
7909 20 The emergency-mode repair failed.You must restore from backup.
7910 10 Repair: The page %S_PGID has been allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). 7911 10 Repair: The page %S_PGID has been deallocated from object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). 7912 10 Repair: The extent %S_PGID has been allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). 7913 10 Repair: The extent %S_PGID has been deallocated from object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). 7914 10 Repair: %ls page at %S_PGID has been rebuilt.
7915 10 Repair: IAM chain for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), has been truncated before page %S_PGID and will be rebuilt.
7916 10 Repair: Deleted record for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), on page %S_PGID, slot %d. Indexes will be rebuilt.
7917 10 Repair: Converted forwarded record for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), at page %S_PGID, slot %d to a data row.
7918 10 Repair: Page %S_PGID next and %S_PGID previous pointers have been set to match each other in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
7919 16 Repair statement not processed. Database needs to be in single user mode.
7920 10 Processed %ld entries in system catalog for database ID %d. 7921 16 Repair statement not processed. Database cannot be a snapshot.
7922 16
*************************************************************** 7923 10 Table %.*ls Object ID %ld.
7924 10 Index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). FirstIAM %S_PGID. Root %S_PGID. Dpages %I64d.
7925 10 Index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). %I64d pages used in %I64d dedicated extents.
7926 16 Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
7927 10 Total number of extents is %I64d.
7928 16 The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
7929 16 Check statement aborted. Database contains deferred transactions.
7930 16 Mirroring must be removed from the database for this DBCC command.
7931 16 Database error: The FileStream directory for partition ID %I64d was seen twice. Possible internal error.
7932 16 Table error: The FileStream directory for object ID %d, index ID %d, partition ID %I64d is in filegroup %d, but should be in filegroup %d.
7933 16 Table error: A FileStream directory exists for the partition ID %I64d, but that partition does not exist in the database. 7934 16 Table error: The FileStream directory for object ID %d, index ID %d, partition ID %I64d was not found.
7935 16 Table error: A FileStream directory exists for column ID %d of object ID %d, index ID %d, partition ID %I64d, but that column does not exist in the partition.
7936 16 Table error: The FileStream directory exists for column ID %d of object ID %d, index ID %d, partition ID %I64d, but that column is not a FileStream column.
7937 16 Table error: The FileStream directory for column ID %d of object ID %d, index ID %d, partition ID %I64d was not found. 7939 16 Cannot detach database ‘%.*ls’ because it does not exist. 7940 16 System databases master, model, msdb, and tempdb cannot be detached.
7942 10 DBCC %ls scanning ‘%.*ls’ table…
7943 10 Table: ‘%.*ls’ (%d); index ID: %d, database ID: %d
7944 10 %ls level scan performed.
7945 10 - Pages Scanned…………………………..: %I64d 7946 10 - Extents Scanned…………………………: %I64d 7947 10 - Extent Switches…………………………: %I64d 7948 10 - Avg. Pages per Extent……………………: %3.1f 7949 10 - Scan Density [Best Count:Actual Count]…….: %4.2f%ls [%I64d:%I64d]
7950 10 - Logical Scan Fragmentation ………………: %4.2f%ls 7952 10 - Extent Scan Fragmentation ……………….: %4.2f%ls 7953 10 - Avg. Bytes Free per Page…………………: %3.1f 7954 10 - Avg. Page Density (full)…………………: %4.2f%ls 7955 10 Invalid SPID %d specified.
7957 10 Cannot display the specified SPID’s buffer; in transition. 7958 10 The specified SPID does not process input/output data streams.
7960 10 An invalid server process identifier (SPID) %d or batch ID %d was specified.
7961 16 Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) , page ID %S_PGID, row ID %d. Column ‘%.*ls’ is a var column with a NULL value and non-zero data length
7962 10 Invalid BATCHID %d specified.
7965 16 Table error: Could not check object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) due to invalid allocation (IAM) page(s).
7966 10 Warning: NO_INDEX option of %ls being used. Checks on non-system indexes will be skipped.
7968 10 Transaction information for database ‘%.*ls’.
7969 10 No active open transactions.
7970 10 %hsOldest active transaction:
7971 10 SPID (server process ID): %d%s
7972 10 UID (user ID) : %d
7974 10 Name : %.*ls
7975 10 LSN : (%d:%d:%d)
7977 10 Start time : %.*ls
7978 10 SID : %.*ls
7979 10 %hsReplicated Transaction Information:
7980 10 Oldest distributed LSN : (%d:%d:%d)
7982 10 Oldest non-distributed LSN : (%d:%d:%d)
7983 14 User ‘%.*ls’ does not have permission to run DBCC %ls for database ‘%.*ls’.
7984 16 System table pre-checks: Object ID %d. Page %S_PGID has unexpected page type %d. Check statement terminated due to unrepairable error.
7985 16 System table pre-checks: Object ID %d. Could not read and latch page %S_PGID with latch type %ls. Check statement terminated due to unrepairable error.
7986 16 System table pre-checks: Object ID %d has cross-object chain linkage. Page %S_PGID points to %S_PGID in alloc unit ID %I64d (should be %I64d). Check statement terminated due to unrepairable error. 7987 16 System table pre-checks: Object ID %d has chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->prev = %S_PGID. Check statement terminated due to unrepairable error.
7988 16 System table pre-checks: Object ID %d. Loop in data chain detected at %S_PGID. Check statement terminated due to unrepairable error. 7992 16 Cannot shrink ‘read only’ database ‘%.*ls’.
7993 10 Cannot shrink file ‘%d’ in database ‘%.*ls’ to %u pages as it only contains %u pages.
7995 16 Database ‘%.*ls’: consistency errors in system catalogs prevent further DBCC %ls processing.
7996 16 Extended stored procedures can only be created in the master database.
7997 16 ‘%.*ls’ does not contain an identity column.
7998 16 Checking identity information: current identity value ‘%.*hs’, current column value ‘%.*hs’.

About these ads

One Response to SQL Server Error Messages

  1. Dwayne says:

    Heya this is kinda of off topic but I was wondering if blogs
    use WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding experience so I wanted to get advice from someone with experience. Any help would be enormously appreciated!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: