SQL Server System Errors: 6000 - 6999
List of error messages between 6000 and 6999 in SQL Server 2017.
These error messages are all available by querying the sys.messages
catalog view on the master
database.
message_id | severity | is_event_logged | text |
---|---|---|---|
6001 | 10 | 0 | SHUTDOWN is waiting for %d process(es) to complete. |
6004 | 10 | 0 | User does not have permission to perform this action. |
6005 | 10 | 0 | SHUTDOWN is in progress. |
6006 | 10 | 1 | Server shut down by %.*ls from login %.*ls. |
6007 | 10 | 0 | The SHUTDOWN statement cannot be executed within a transaction or by a stored procedure. |
6101 | 16 | 0 | Session ID %d is not valid. |
6102 | 14 | 0 | User does not have permission to use the KILL statement. |
6104 | 16 | 0 | Cannot use KILL to kill your own process. |
6106 | 16 | 0 | Process ID %d is not an active process ID. |
6107 | 14 | 0 | Only user processes can be killed. |
6108 | 16 | 0 | KILL SPID WITH COMMIT/ROLLBACK is not supported by Microsoft SQL Server. Use KILL UOW WITH COMMIT/ROLLBACK to resolve in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). |
6109 | 10 | 0 | SPID %d: transaction rollback in progress. Estimated rollback completion: %d%%. Estimated time remaining: %d seconds. |
6110 | 16 | 0 | The distributed transaction with UOW %s does not exist. |
6111 | 16 | 0 | Another user has decided a different outcome for the distributed transaction associated with UOW %s. |
6112 | 16 | 0 | Distributed transaction with UOW %s is in prepared state. Only Microsoft Distributed Transaction Coordinator can resolve this transaction. KILL command failed. |
6113 | 16 | 0 | The distributed transaction associated with UOW %s is in PREPARE state. Use KILL UOW WITH COMMIT/ROLLBACK syntax to kill the transaction instead. |
6114 | 16 | 0 | Distributed transaction with UOW %s is being used by another user. KILL command failed. |
6115 | 16 | 0 | KILL command cannot be used inside user transactions. |
6117 | 16 | 0 | There is a connection associated with the distributed transaction with UOW %s. First, kill the connection using KILL SPID syntax. |
6118 | 16 | 0 | The distributed transaction associated with UOW %s is not in PREPARED state. Use KILL UOW to kill the transaction instead. |
6119 | 10 | 0 | Distributed transaction with UOW %s is rolling back: estimated rollback completion: %d%%, estimated time left %d seconds. |
6120 | 16 | 0 | Status report cannot be obtained. Rollback operation for Process ID %d is not in progress. |
6121 | 16 | 0 | Status report cannot be obtained. Rollback operation for UOW %s is not in progress. |
6200 | 16 | 0 | 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 | 0 | 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 CLR type. |
6202 | 16 | 0 | Method "%ls" of type "%ls" in assembly "%.*ls" does not return a value. |
6203 | 16 | 0 | 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 | 0 | Trying to send a record with %d columns(s) in a result set with %d column(s). |
6205 | 16 | 0 | %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 | 0 | Request submitted with too many parameters. The maximum number is %ld. |
6207 | 16 | 0 | Error converting %.*ls to fixed length binary type. The result would be padded and cannot be converted back. |
6208 | 16 | 0 | %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 | 0 | Unsound ordering on CLR type "%.*ls": returning NULL on non-NULL inputs. |
6210 | 16 | 0 | CLR type '%.*ls' is not fully comparable. |
6211 | 16 | 0 | %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 | 0 | %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 | 0 | %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 | 0 | %s ASSEMBLY failed because assembly "%.*ls" has an unmanaged entry point. |
6215 | 16 | 0 | %s ASSEMBLY failed because method '%.*ls' on type '%.*ls' in %.*ls assembly '%.*ls' has invalid attribute 0x%x. |
6216 | 16 | 0 | %s ASSEMBLY failed because type "%.*ls" in %.*ls assembly "%.*ls" has a finalizer. Finalizers are not allowed in %.*ls assemblies. |
6217 | 16 | 0 | ALTER ASSEMBLY ADD FILE failed because the file, "%.*ls", being added is empty. |
6218 | 16 | 0 | %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 | 0 | %s ASSEMBLY failed because assembly source parameter %d has an unmanaged entry point. |
6220 | 16 | 0 | SELECT INTO failed because CLR type "%.*ls" does not exist in the target database. |
6221 | 16 | 0 | The cursor operation generated more than one row of different column metadata. |
6222 | 16 | 0 | Type "%.*ls.%.*ls" is marked for native serialization, but field "%.*ls" of type "%.*ls.%.*ls" is not valid for native serialization. |
6223 | 16 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | Type "%.*ls.%.*ls" is marked for user-defined serialization, but does not implement the "%.*ls.%.*ls" interface. |
6227 | 16 | 0 | Type "%.*ls.%.*ls" is marked for native serialization, but field "%.*ls" of type "%.*ls.%.*ls" is of type "%.*ls.%.*ls", which is not blittable, or type "%.*ls.%.*ls" has a recursive definition. |
6228 | 16 | 0 | Type "%.*ls.%.*ls" is marked for native serialization, but it contains non-blittable fields. |
6229 | 16 | 0 | 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 | 0 | 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 | 0 | Type "%.*ls.%.*ls" is marked for native serialization, but one of its base types "%.*ls.%.*ls" is not valid for native serialization. |
6232 | 16 | 0 | 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 | 0 | In proc data access is not allowed in an impersonated state. |
6234 | 16 | 0 | Data truncation error. Length (%d) exceeds maximum length (%d) for type '%.*ls'. |
6235 | 16 | 0 | Data serialization error. Length (%d) is less than fixed length (%d) for type '%.*ls'. |
6236 | 16 | 0 | %s ASSEMBLY failed because filename '%.*ls' is too long. |
6237 | 16 | 0 | %s ASSEMBLY failed because method "%.*ls" on type "%.*ls" in assembly "%.*ls" has an invalid custom attribute "%.*ls". |
6238 | 16 | 0 | %s ASSEMBLY failed because field "%.*ls" in type "%.*ls" in assembly "%.*ls" has an invalid custom attribute "%.*ls". |
6239 | 16 | 0 | %s ASSEMBLY failed because type "%.*ls" in assembly "%.*ls" has an invalid custom attribute "%.*ls". |
6240 | 16 | 0 | ALTER ASSEMBLY failed because the function '%s' of type '%s' no longer satisfies indexability requirements, and is used for the indexed view '%s'. |
6241 | 16 | 0 | Trying to send a record with type or name of column %d differing from the type or name of the corresponding column of the result set. |
6242 | 16 | 0 | CREATE ASSEMBLY failed because the user "%.*ls" specified in the authorization clause does not exist. |
6243 | 16 | 0 | '%.*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 | 0 | The size (%d) for "%.*ls.%.*ls" is not in the valid range. Size must be -1 or a number between 1 and 8000. |
6245 | 16 | 0 | Invalid serialization format (%d) for type "%.*ls.%.*ls". |
6246 | 16 | 0 | Assembly "%.*ls" already exists in database "%.*ls". |
6247 | 16 | 0 | Cannot create type because '%.*ls.%.*ls' cannot have fixed length if it has MaxByteSize set to -1. |
6248 | 16 | 0 | %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 | 0 | The associated file "%.*ls" already exists for assembly "%.*ls". |
6250 | 11 | 0 | Assembly "%.*ls" does not have an associated file "%.*ls". |
6251 | 16 | 0 | ALTER ASSEMBLY failed because the assembly file parameter %d is not a valid expression. |
6252 | 16 | 0 | ALTER ASSEMBLY failed because a file name was not specified for the inline assembly file parameter %d. |
6253 | 10 | 1 | Common language runtime (CLR) functionality initialized using CLR version %ls from %ls. |
6254 | 10 | 1 | Common language runtime (CLR) functionality initialized. |
6255 | 16 | 0 | %s failed because type "%s" does not conform to the %s specification: missing custom attribute "%.*ls". |
6256 | 16 | 0 | SqlPipe request submitted with too many columns. The maximum number is %d. |
6257 | 16 | 0 | CREATE ASSEMBLY for assembly '%.*ls' failed because the assembly is built for an unsupported version of the Common Language Runtime. |
6258 | 16 | 0 | 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. |
6259 | 16 | 0 | Assembly '%.*ls' could not be loaded because it failed verification. %.*ls |
6260 | 16 | 0 | An error occurred while getting new row from user defined Table Valued Function : %.*ls. |
6261 | 16 | 0 | The CLR type referenced by column "%.*ls" of table variable "%.*ls" has been dropped during the execution of the batch. Run the batch again. |
6262 | 16 | 0 | Assembly was not found in current database or version did not match. |
6263 | 16 | 0 | Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option. |
6264 | 16 | 0 | Data access failed because the .NET Framework routine is not marked with "DataAccessKind.Read" or "SystemDataAccessKind.Read". |
6265 | 16 | 0 | %s ASSEMBLY failed because type "%.*ls" in %.*ls assembly "%.*ls" has a pinvokeimpl method. P/Invoke is not allowed in %.*ls assemblies. |
6266 | 10 | 0 | Warning: Assembly "%.*ls" was built using version %.*ls of the .NET Framework. SQL Server currently uses version %s. |
6267 | 16 | 0 | Assembly "%.*ls" does not exist, or the user does not have permission to reference it. |
6269 | 16 | 0 | ALTER ASSEMBLY failed because the user-defined aggregate "%s" does not exist or is not correctly defined in the updated assembly. |
6270 | 16 | 0 | ALTER ASSEMBLY failed because the required method "%s" in type "%s" was not found with the same signature in the updated assembly. |
6271 | 16 | 0 | ALTER ASSEMBLY failed because the required field "%s" in type "%s" was not found with the same signature in the updated assembly. |
6272 | 16 | 0 | ALTER ASSEMBLY failed because required property '%s' in type '%s' was not found with the same signature in the updated assembly. |
6273 | 16 | 0 | ALTER ASSEMBLY failed because required type '%s' does not exist or is not correctly defined in the updated assembly. |
6274 | 16 | 0 | 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 | 0 | ALTER ASSEMBLY failed because the IsByteOrdered attribute of type '%s' would change in the updated assembly. |
6276 | 16 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | ALTER ASSEMBLY failed because only users with ALTER ANY SCHEMA permissions can use WITH UNCHECKED DATA. |
6282 | 16 | 0 | ALTER ASSEMBLY failed because the referenced assemblies would change. The referenced assembly list must remain the same. |
6283 | 16 | 0 | ALTER ASSEMBLY failed because only the assembly revision version number is allowed to change. |
6284 | 16 | 0 | ALTER ASSEMBLY failed because it is referenced by object '%.*ls'. Assemblies that are referenced by SQL objects cannot be made invisible. |
6285 | 16 | 0 | %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 | 0 | '%s' ASSEMBLY failed because a different version of assembly '%s', referenced by assembly '%s', is already in the database. |
6287 | 16 | 0 | 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 | 0 | 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 | 1 | Failed to allocate memory for common language runtime (CLR) functionality. |
6290 | 10 | 1 | AppDomain %i (%.*ls) unloaded. |
6291 | 16 | 1 | AppDomain %i (%.*ls) failed to unload with error code 0x%x. |
6292 | 16 | 0 | The transaction that is associated with this operation has been committed or rolled back. Retry with a different transaction. |
6293 | 16 | 0 | %.*ls.%.*ls.%.*ls: SqlFacetAttribute is invalid on a non-public member. |
6294 | 16 | 0 | %.*ls.%.*ls.%.*ls: %.*ls property of SqlFacetAttribute cannot be used in this context. |
6295 | 16 | 0 | %.*ls.%.*ls.%.*ls: %.*ls property of SqlFacetAttribute has an invalid value. |
6296 | 16 | 0 | %.*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 | 0 | %.*ls.%.*ls.%.*ls: The SqlFacetAttribute property IsFixedLength cannot be set to true when MaxSize is set to -1. |
6298 | 16 | 0 | %.*ls.%.*ls.%.*ls: The SqlFacetAttribute properties Precision and Scale have to be used together. |
6299 | 10 | 0 | AppDomain %i (%.*ls) created. |
6302 | 16 | 0 | The argument of CREATE or ALTER XML SCHEMA COLLECTION statement must be a string expression. |
6303 | 16 | 0 | XML parsing: Document parsing required too much memory |
6304 | 16 | 0 | XML parsing: An unexpected error has occurred in the XML parser. |
6305 | 16 | 0 | XQuery data manipulation expression required in XML data type method. |
6306 | 16 | 0 | Invalid XQuery expression passed to XML data type method. |
6307 | 16 | 0 | XML well-formedness check: Attribute cannot appear outside of element declaration. Rewrite your XQuery so it returns well-formed XML. |
6308 | 16 | 0 | XML well-formedness check: Duplicate attribute '%.*ls'. Rewrite your XQuery so it returns well-formed XML. |
6309 | 16 | 0 | XML well-formedness check: the data for node '%.*ls' contains a character (0x%04X) which is not allowed in XML. |
6310 | 16 | 0 | 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 | 0 | An internal XMLDB schema processor error occurred. Contact Technical Support for assistance. |
6312 | 16 | 0 | Could not find schema components with target namespace '%.*ls' in collection '%.*ls'. |
6314 | 16 | 0 | Collection specified does not exist in metadata : '%.*ls' |
6315 | 16 | 0 | 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 | 0 | Specified component '%s' can not be dropped because it is used by component:'%s' |
6317 | 16 | 0 | XQuery: Cannot update with value '%.*ls' because it failed validation against type '{%.*ls}%.*ls' |
6318 | 16 | 0 | XQuery: String conversion failed during UPDATE validation |
6320 | 16 | 0 | XQuery: Only nillable elements or text nodes can be updated with empty sequence |
6321 | 16 | 0 | xml:space attribute must have a value of 'preserve' or 'default'. '%.*ls' is not valid. |
6322 | 16 | 0 | XML Parser ran out of memory. This could be caused by too many attributes or namespace declarations. |
6323 | 16 | 0 | 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 | 0 | DROP XML INDEX does not support any options. |
6325 | 16 | 0 | 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 | 0 | XML well-formedness check: XML namespace declaration cannot appear outside of element declaration. Rewrite your XQuery so it returns well-formed XML. |
6327 | 16 | 0 | The specified xml schema collection ID is not valid: %d |
6328 | 16 | 0 | Specified collection '%.*ls' cannot be dropped because it is used by %S_MSG '%ls'. |
6329 | 16 | 0 | Unsupported usage of a QName typed value in node '%.*ls' |
6330 | 16 | 0 | Column '%.*ls' on table '%.*ls' is not of type XML, which is required to create an XML index on it. |
6331 | 16 | 0 | Primary XML Index '%.*ls' already exists on column '%.*ls' on table '%.*ls', and multiple Primary XML Indexes per column are not allowed. |
6332 | 16 | 0 | 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 | 0 | Could not find%ls XML index named '%.*ls' on table '%.*ls' |
6334 | 16 | 0 | Could not create the XML or spatial index on object '%.*ls' because that object is not a table. Create the index on the base table column. |
6335 | 16 | 0 | XML datatype instance has too many levels of nested nodes. Maximum allowed depth is %d levels. |
6336 | 16 | 0 | 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 | 0 | '%.*ls' is not a valid XML Index name because it starts with '%c' character. XML Index name should not start with '#' or '@' |
6338 | 10 | 0 | XML DTD has been stripped from one or more XML fragments. External subsets, if any, have been ignored. |
6339 | 16 | 0 | Specified collection '%.*ls' cannot be modified because it is SQL Server built-in XML Schema Collection. |
6340 | 16 | 0 | 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 | 0 | 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 | 0 | Cannot create primary xml, selective xml or spatial index '%.*ls' on table '%.*ls', column '%.*ls', because the column is computed. |
6343 | 16 | 0 | Cannot create secondary xml or secondary selective xml index '%.*ls' without a USING XML INDEX clause. |
6344 | 16 | 0 | The primary xml index '%.*ls' does not exist on table '%.*ls' column '%.*ls'. |
6345 | 16 | 0 | The sparse column set '%.*ls' in the table '%.*ls' cannot be indexed by an XML index. |
6346 | 16 | 0 | Cannot convert a primary XML index to a secondary XML index using the DROP_EXISTING option. '%.*ls' is a primary XML index. |
6347 | 16 | 0 | Specified collection '%.*ls' cannot be altered because it does not exist or you do not have permission. |
6348 | 16 | 0 | Specified collection '%.*ls' cannot be created because it already exists or you do not have permission. |
6350 | 16 | 0 | The definition for xml schema collection '%.*ls' has changed. |
6351 | 16 | 0 | 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 | 0 | 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 | 0 | Serialization of built-in schemata is not supported. |
6354 | 16 | 0 | Target string size is too small to represent the XML instance |
6355 | 16 | 0 | Conversion of one or more characters from XML to target collation impossible |
6356 | 16 | 0 | Failed to load DLL. Make sure xmlrw.dll exists in the SQL Server installation. |
6357 | 16 | 0 | Internal error: cannot locate CreateInfoSetReaderEx in xmlrw.dll. You may have an incorrect version of xmlrw.dll. |
6358 | 16 | 0 | %d is not a valid style number when converting to XML. |
6359 | 16 | 0 | Parsing XML with internal subset DTDs not allowed. Use CONVERT with style option 2 to enable limited internal subset DTD support. |
6360 | 16 | 0 | %d is not a valid style number when converting from XML. |
6361 | 16 | 0 | Invalid null parameter specified. XML Schema Collections can only be created from a non-null value. |
6362 | 16 | 0 | Alter schema collection cannot be performed because the current schema has a lax wildcard or an element of type xs:anyType. |
6363 | 16 | 0 | ALTER SCHEMA COLLECTION failed. It cannot be performed on a schema collection that allows laxly validated content and is schema bound. Remove the schema binding before trying to alter the collection. |
6364 | 16 | 0 | ALTER SCHEMA COLLECTION failed. Revalidation of XML columns in table '%.*ls' did not succeed due to the following reason: '%.*ls'. Either the schema or the specified data should be altered so that validation does not find any mismatches. |
6365 | 16 | 0 | An XML operation resulted an XML data type exceeding 2GB in size. Operation aborted. |
6366 | 16 | 0 | Invalid type for 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. %S_MSG %s |
6367 | 16 | 0 | XSD data type '%.*ls' is not allowed for selective XML index '%.*ls'. |
6368 | 16 | 0 | It is not allowed to specify an XSD type for selective XML index '%.*ls' because the column '%.*ls' of table '%.*ls' is associated with an XML Schema collection. |
6369 | 16 | 0 | MAX_LENGTH option for selective XML index '%.*ls' can be specified only for the types that support maxLength facet. |
6370 | 16 | 0 | MAX_LENGTH option is not allowed in combination with 'node()' for selective XML index '%.*ls'. |
6371 | 16 | 0 | The same name cannot be assigned to more than one path for selective XML index '%.*ls'. |
6372 | 16 | 0 | The same path expression cannot be mapped twice using SQL data types for selective XML index '%.*ls'. |
6373 | 16 | 0 | The expression specified for path '%.*ls' is not allowed for selective XML index '%.*ls'. It is only allowed to index simple path expressions without predicates. |
6374 | 16 | 0 | Specifying path which contains '%.*ls' is not allowed for selective XML index '%.*ls'. |
6375 | 16 | 0 | The data type '%.*ls' is not allowed for selective XML index '%.*ls'. |
6376 | 16 | 0 | For selective XML index '%.*ls', MAX_LENGTH optimization hint cannot be specified if length or maxLength facet is specified in schema for an element. |
6377 | 16 | 0 | Specifying a path which contains '*' in the last step is not allowed for selective XML index '%.*ls'. |
6378 | 16 | 0 | Table '%.*ls' needs to have a clustered primary key with less than %d columns in it in order to create a selective XML index on it. |
6379 | 16 | 0 | selective XML index '%.*ls' already exists on column '%.*ls' in table '%.*ls'. Multiple selective XML indexes per column are not allowed. |
6380 | 16 | 0 | Path '%.*ls'. Multiple values found when SINGLETON option is specified for selective XML index '%.*ls'. |
6381 | 16 | 0 | Could not find path '%.*ls' in selective XML index '%.*ls'. |
6382 | 16 | 0 | Could not find selective XML index named '%.*ls' on table '%.*ls' |
6383 | 16 | 0 | For selective XML index '%.*ls', SINGLETON option can be specified only for untyped XML. |
6384 | 16 | 0 | It is not allowed to specify a path which contains '*' only for the URI or only for the name of the node for selective XML index '%.*ls'. |
6385 | 16 | 0 | The selective XML index '%.*ls' does not exist on table '%.*ls' column '%.*ls'. |
6386 | 16 | 0 | Cannot convert a selective XML index to a secondary selective XML index using the DROP_EXISTING option. '%.*ls' is a selective XML index. |
6387 | 16 | 0 | You cannot remove all paths for selective XML index '%.*ls'. A selective XML index must have at least one path specified. |
6388 | 16 | 0 | Version of Selective DG stored in database is different than version of Selective DG on server for index '%.*ls'. |
6389 | 16 | 0 | Inserted value exceeded maxlength %d for path '%.*ls' for selective XML index '%.*ls'. |
6390 | 16 | 0 | ALTER SCHEMA COLLECTION failed because path '%.*ls' indexed with selective XML index '%.*ls' on table '%.*ls' would be invalidated. Either the schema or the specified path should be altered so that validation does not find any mismatches. |
6391 | 16 | 0 | Path '%.*ls' is promoted to a type that is invalid for use as a key column in a secondary selective XML index. |
6392 | 16 | 0 | It is not allowed to create secondary selective XML index on the path '%.*ls' because 'node()' is specified. |
6393 | 16 | 0 | The same path expression cannot be mapped twice with same XSD types for selective XML index '%.*ls'. |
6394 | 16 | 0 | Found non leaf element indexed for the value with path '%.*ls' for selective XML index '%.*ls'. |
6395 | 16 | 0 | The maximum key length is %d bytes. The secondary selective XML index '%.*ls' over path '%.*ls' has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail. |
6396 | 16 | 0 | The number of promoted paths for selective XML index '%.*ls' exceeds the maximum of %d. |
6397 | 16 | 0 | Path '%.*ls' specified for selective XML index '%.*ls' is too deep. The maximum allowed depth is %d levels. |
6398 | 16 | 0 | The MAXLENGTH option value specified for the path '%.*ls' for Selective XML Index '%.*ls' is not allowed. The value should be in the range %d - %d. |
6399 | 16 | 0 | The XML path '%.*ls' of selective XML index '%.*ls' cannot be dropped because it is used by secondary selective XML Index '%.*ls'. |
6401 | 16 | 0 | Cannot roll back %.*ls. No transaction or savepoint of that name was found. |
6500 | 16 | 0 | %ls failed because method '%ls' of class '%ls' in assembly '%ls' returns %ls, but CLR Triggers must return void. |
6501 | 16 | 0 | %s ASSEMBLY failed because it could not open the physical file '%.*ls': %ls. |
6502 | 16 | 0 | %s ASSEMBLY failed because it could not read from the physical file '%.*ls': %ls. |
6503 | 16 | 0 | Assembly '%.*ls' was not found in the SQL catalog. |
6504 | 16 | 0 | The value returned from %.*ls.%.*ls is not allowed to be NULL. |
6505 | 16 | 0 | Could not find Type '%s' in assembly '%s'. |
6506 | 16 | 0 | Could not find method '%s' for type '%s' in assembly '%s' |
6507 | 16 | 0 | Failed to open malformed assembly '%ls' with HRESULT 0x%x. |
6508 | 16 | 0 | Could not find field '%s' for type '%s' in assembly '%s'. |
6509 | 16 | 0 | An error occurred while gathering metadata from assembly '%ls' with HRESULT 0x%x. |
6510 | 16 | 1 | This functionality requires .NET Framework 4. Please install .NET Framework 4 to use this functionality. |
6511 | 16 | 1 | Failed to initialize the Common Language Runtime (CLR) %ls with HRESULT 0x%x. You may fix the problem and try again later. |
6512 | 16 | 1 | 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 | 1 | Failed to initialize the Common Language Runtime (CLR) %ls due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online. |
6514 | 16 | 0 | Cannot use '%s' column in the result table of a streaming user-defined function (column '%.*ls'). |
6515 | 16 | 0 | Schema collection database '%.*ls' does not exist or you do not have permission. |
6516 | 16 | 0 | There is no collection '%.*ls' in metadata '%.*ls'. |
6517 | 16 | 1 | Failed to create AppDomain "%.*ls". %.*ls |
6518 | 16 | 0 | Could not open system assembly ''%.*ls'': %ls. |
6519 | 16 | 0 | Type '%.*ls' is not yet supported for CLR operations. |
6520 | 16 | 0 | A .NET Framework error occurred during statement execution. |
6521 | 16 | 0 | A .NET Framework error occurred during statement execution: %.*ls. |
6522 | 16 | 0 | A .NET Framework error occurred during execution of user-defined routine or aggregate "%.*ls": %ls. |
6523 | 16 | 0 | Method, property or field '%ls' of class '%ls' in assembly '%.*ls' is static. |
6524 | 16 | 0 | Cannot use computed column in the result table of a streaming user-defined function (column '%.*ls'). |
6525 | 16 | 0 | Cannot use '%s' constraint in the result table of a streaming user-defined function. |
6526 | 16 | 0 | Cannot use '%s' constraint in the result table of a streaming user-defined function (column '%.*ls'). |
6527 | 10 | 1 | .NET Framework runtime has been stopped. |
6528 | 16 | 0 | Assembly '%.*ls' was not found in the SQL catalog of database '%.*ls'. |
6529 | 16 | 0 | 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 | 0 | Cannot perform alter on '%.*ls' because it is an incompatible object type. |
6531 | 16 | 0 | %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 | 1 | .NET Framework execution was aborted by escalation policy because of out of memory. %.*ls |
6533 | 16 | 1 | 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 | 1 | AppDomain %.*ls was unloaded by escalation policy to ensure the consistency of your application. Application failed to release a managed lock. %.*ls |
6535 | 16 | 0 | .NET Framework execution was aborted. Another query caused the AppDomain %.*ls to be unloaded. %.*ls |
6536 | 16 | 1 | 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 | 1 | The .NET Framework common language runtime was shut down by user code, such as in a user-defined function or CLR 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 | 1 | .NET Framework execution was aborted because of stack overflow. %.*ls |
6539 | 16 | 0 | Invalid serialization format (Format.Unknown) for type '%.*ls.%.*ls'. |
6540 | 16 | 0 | The assembly name '%.*ls' being registered has an illegal name that duplicates the name of a system assembly. |
6541 | 16 | 0 | ALTER ASSEMBLY failed because assembly '%.*ls' has more than one file associated with it. Use ALTER ASSEMBLY DROP FILE to remove extra files. |
6542 | 16 | 0 | Can not create object because %ls is a generic type. |
6543 | 16 | 0 | .NET Framework execution was aborted. The UDP/UDF/CLR type did not end thread affinity. |
6544 | 16 | 0 | %s ASSEMBLY for assembly '%.*ls' failed because assembly '%.*ls' is malformed or not a pure .NET assembly. %.*ls |
6545 | 16 | 0 | Enabling of execution statistics SET options is not allowed from within CLR procedure or function. |
6546 | 16 | 0 | Could not impersonate the execution context during the execution of '%.*ls'. |
6547 | 16 | 0 | An error occurred while getting method, property or field information for "%ls" of class "%ls" in assembly "%.*ls". |
6548 | 16 | 0 | CREATE ASSEMBLY failed because the assembly references assembly '%.*ls', which is owned by another user. |
6549 | 16 | 0 | 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 | 0 | %s failed because parameter counts do not match. |
6551 | 16 | 0 | %s for "%.*ls" failed because T-SQL and CLR types for return value do not match. |
6552 | 16 | 0 | %s for "%.*ls" failed because T-SQL and CLR types for parameter "%.*ls" do not match. |
6553 | 16 | 0 | %s failed because of an invalid .NET Framework calling convention. Use the default .NET Framework calling convention. |
6554 | 16 | 0 | SQL assembly name '%.*ls', and .NET Framework assembly name '%.*ls' do not match. Assembly names must match. |
6555 | 16 | 0 | Assembly '%.*ls' already exists for owner '%.*ls' in database '%.*ls'. |
6556 | 16 | 0 | %s failed because it could not find type '%s' in assembly '%s'. |
6557 | 16 | 0 | %s failed because type '%s' does not conform to %s specification due to field '%s'. |
6558 | 16 | 0 | %s failed because type '%s' does not conform to %s specification due to method '%s'. |
6559 | 20 | 1 | Could not find type ID %d in database %.*ls. This is due to a schema inconsistency. |
6560 | 16 | 0 | Assembly "%.*ls" is a system assembly. This operation is permitted only with user assemblies. |
6561 | 16 | 0 | Could not find file '%s' in directory '%s%s'. |
6562 | 16 | 0 | Version mismatch between files '%ls' (%d.%d.%d) and '%ls' (%d.%d.%d). |
6563 | 16 | 0 | Method, property or field '%ls' in class '%ls' in assembly '%.*ls' has invalid return type. |
6564 | 16 | 0 | The method '%ls' in class '%ls' in assembly '%.*ls' has some invalid parameter declaration for parameter number %d. |
6565 | 16 | 0 | %s ASSEMBLY failed because the assembly source parameter %d is not a valid assembly. |
6566 | 16 | 0 | %s ASSEMBLY failed because the assembly source parameter %d is not a valid expression. |
6567 | 16 | 0 | %s failed because a CLR Procedure may only be defined on CLR methods that return either SqlInt32, System.Int32, System.Nullable |
6568 | 16 | 0 | A .NET Framework error occurred while getting information from class "%.*ls" in assembly "%.*ls": %ls. |
6569 | 16 | 0 | '%.*ls' failed because parameter %d is not allowed to be null. |
6570 | 16 | 0 | Method '%ls' of class '%ls' in assembly '%.*ls' is generic. Generic methods are not supported. |
6571 | 16 | 0 | Class '%ls' in assembly '%.*ls' is generic. Generic types are not supported. |
6572 | 16 | 0 | 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 | 0 | Method, property or field '%ls' of class '%ls' in assembly '%.*ls' is not static. |
6574 | 16 | 0 | Method, property or field '%ls' of class '%ls' in assembly '%.*ls' is not public. |
6575 | 16 | 0 | Assembly names should be less than %d characters. Assembly name '%.*ls' is too long. |
6576 | 16 | 0 | Type '%ls' in assembly '%ls' is not public. |
6577 | 16 | 0 | CREATE TYPE failed because type '%s' does not conform to CLR type specification due to interface '%s'. |
6578 | 16 | 0 | Invalid attempt to continue operation after a severe error. |
6579 | 16 | 0 | Alter assembly from '%ls' to '%ls' is not a compatible upgrade. |
6580 | 16 | 0 | Declarations do not match for parameter %d. .NET Framework reference and T-SQL OUTPUT parameter declarations must match. |
6581 | 16 | 0 | Could not find assembly '%.*ls' in directory '%.*ls'. |
6582 | 16 | 0 | Assembly '%.*s' is not visible for creating SQL objects. Use ALTER ASSEMBLY to change the assembly visibility. |
6583 | 16 | 0 | Assembly '%.*s' cannot be used for creating SQL objects because it is a system assembly. |
6584 | 16 | 0 | Property or field '%ls' for type '%ls' in assembly '%ls' is not static |
6585 | 16 | 0 | Could not impersonate the client during assembly file operation. |
6586 | 16 | 0 | Assembly '%.*ls' could not be installed because existing policy would keep it from being used. |
6587 | 16 | 0 | Assembly reference '%ls' was redirected by external policy to '%ls' |
6588 | 16 | 0 | Assembly file operations are not allowed for logins that use integration authentication activated by SETUSER. |
6589 | 16 | 0 | DROP ASSEMBLY failed because the specified assemblies are referenced by assembly '%ls'. |
6590 | 16 | 0 | DROP ASSEMBLY failed because '%ls' is referenced by object '%ls'. |
6591 | 16 | 0 | %s for "%.*ls" failed because first parameter of "%.*ls" method must be of type System.Object. |
6592 | 16 | 0 | Could not find property or field '%ls' for type '%ls' in assembly '%ls'. |
6593 | 16 | 0 | Property or field '%ls' for type '%ls' in assembly '%ls' is static. |
6594 | 16 | 0 | Could not read from property '%ls' for type '%ls' in assembly '%ls' because it does not have a get accessor. |
6595 | 16 | 0 | Could not assign to property '%ls' for type '%ls' in assembly '%ls' because it is read only. |
6596 | 16 | 0 | %s ASSEMBLY failed because assembly '%ls' is a system assembly. Consider creating a user assembly to wrap desired functionality. |
6597 | 16 | 0 | CREATE %s failed. |
6598 | 16 | 0 | DROP ASSEMBLY failed because '%ls' is referenced by CLR type '%ls'. |
6599 | 16 | 0 | Found an empty native serialization class '%.*ls'. Empty native serialization classes are not allowed. |
6600 | 16 | 0 | XML error: %.*ls |
6601 | 10 | 0 | The XML parse error 0x%x occurred on line number %d, near the XML text "%.*ls". |
6602 | 16 | 0 | The error description is '%.*ls'. |
6603 | 16 | 0 | XML parsing error: %.*ls |
6605 | 16 | 0 | %.*ls: Failed to obtain an IPersistStream interface on the XML text. |
6607 | 16 | 0 | %.*ls: The value supplied for parameter number %d is invalid. |
6608 | 16 | 0 | Failed to instantiate class "%ls". Verify that Msxmlsql.dll exists in the SQL Server installation. |
6609 | 16 | 0 | Invalid data type for the column "%ls". Allowed data types are CHAR/VARCHAR, NCHAR/NVARCHAR, TEXT/NTEXT, and XML. |
6610 | 17 | 0 | Failed to load Msxmlsql.dll. |
6611 | 16 | 0 | The XML data type is damaged. |
6613 | 16 | 0 | Specified value '%ls' already exists. |
6621 | 16 | 0 | XML encoding or decoding error occurred with object name '%.*ls'. |
6622 | 16 | 0 | 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 | 0 | Column '%ls' contains an invalid data type. Valid data types are char, varchar, nchar, and nvarchar. |
6624 | 16 | 0 | XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents. |
6625 | 16 | 0 | 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 | 0 | Unexpected end of data stream. |
6627 | 16 | 0 | The size of the data chunk that was requested from the stream exceeds the allowed limit. |
6628 | 16 | 0 | %.*ls can only process untyped XML. Cast the input value to XML or to a string type. |
6629 | 16 | 0 | 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 | 0 | Element-centric mapping must be used with OPENXML when one of the columns is of type XML. |
6631 | 16 | 0 | The requested OpenXML document is currently in use by another thread, and cannot be used. |
6632 | 16 | 0 | Invalid data type for the column "%ls". CLR types cannot be used in an OpenXML WITH clause. |
6633 | 16 | 0 | 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". |
6634 | 16 | 0 | OpenXML cannot be used as the target of a DML or OUTPUT INTO operation. |
6635 | 16 | 0 | The compressed showplan xml stream is corrupted. |
6700 | 16 | 0 | XQuery: The ' %ls' operation is not supported. |
6701 | 16 | 0 | 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 | 0 | XML Node ID is invalid. Re-build the database if the problem persists. |
6717 | 16 | 0 | XQuery: The document tree is too deep. If the problem persists you must simplify the XML hierarchy. |
6718 | 16 | 0 | XQuery: Invalid ordpath string: "%s" |
6739 | 16 | 0 | XQuery: SQL type '%s' is not supported in XQuery. |
6743 | 16 | 0 | 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 | 0 | XQuery: One of the paths specified in the query is too deep. The maximum allowed depth is %d levels. |
6745 | 16 | 0 | XQuery: Internal compiler error. |
6800 | 16 | 0 | 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 | 0 | FOR XML EXPLICIT requires at least three columns, including the tag column, the parent column, and at least one data column. |
6802 | 16 | 0 | FOR XML EXPLICIT query contains the invalid column name '%.*ls'. Use the TAGNAME!TAGID!ATTRIBUTENAME[!..] format where TAGID is a positive integer. |
6803 | 16 | 0 | FOR XML EXPLICIT requires the first column to hold positive integers that represent XML tag IDs. |
6804 | 16 | 0 | FOR XML EXPLICIT requires the second column to hold NULL or nonnegative integers that represent XML parent tag IDs. |
6805 | 16 | 0 | FOR XML EXPLICIT stack overflow occurred. Circular parent tag relationships are not allowed. |
6806 | 16 | 0 | Undeclared tag ID %d is used in a FOR XML EXPLICIT query. |
6807 | 16 | 0 | Undeclared parent tag ID %d is used in a FOR XML EXPLICIT query. |
6808 | 16 | 0 | XML tag ID %d could not be added. The server memory resources may be low. |
6809 | 16 | 0 | 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 | 0 | Column name '%.*ls' is repeated. The same attribute cannot be generated more than once on the same XML tag. |
6812 | 16 | 0 | XML tag ID %d that was originally declared as '%.*ls' is being redeclared as '%.*ls'. |
6813 | 16 | 0 | FOR XML EXPLICIT cannot combine multiple occurrences of ID, IDREF, IDREFS, NMTOKEN, and/or NMTOKENS in column name '%.*ls'. |
6814 | 16 | 0 | In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS require attribute names in '%.*ls'. |
6815 | 16 | 0 | In the FOR XML EXPLICIT clause, ID, IDREF, IDREFS, NMTOKEN, and NMTOKENS attributes cannot be hidden in '%.*ls'. |
6816 | 16 | 0 | 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 | 0 | FOR XML EXPLICIT cannot combine multiple occurrences of ELEMENT, XML, XMLTEXT, and CDATA in column name '%.*ls'. |
6819 | 16 | 0 | The FOR XML clause is not allowed in a %ls statement. |
6820 | 16 | 0 | FOR XML EXPLICIT requires column %d to be named '%ls' instead of '%.*ls'. |
6821 | 16 | 0 | GROUP BY and aggregate functions are currently not supported with FOR XML AUTO. |
6824 | 16 | 0 | In the FOR XML EXPLICIT clause, mode '%.*ls' in a column name is invalid. |
6825 | 16 | 0 | ELEMENTS option is only allowed in RAW, AUTO, and PATH modes of FOR XML. |
6826 | 16 | 0 | 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 | 0 | FOR XML EXPLICIT queries allow only one XMLTEXT column per tag. Column '%.*ls' declares another XMLTEXT column that is not permitted. |
6828 | 16 | 0 | XMLTEXT column '%.*ls' must be of a string data type or of type XML. |
6829 | 16 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | FOR XML AUTO cannot generate a URL address for binary data if a primary key is also binary. |
6833 | 16 | 0 | 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 | 0 | XMLTEXT field '%.*ls' contains an invalid XML document. Check the root tag and its attributes. |
6835 | 16 | 0 | FOR XML EXPLICIT field '%.*ls' can specify the directive HIDE only once. |
6836 | 16 | 0 | FOR XML EXPLICIT requires attribute-centric IDREFS or NMTOKENS field '%.*ls' to precede element-centric IDREFS/NMTOKEN fields. |
6838 | 16 | 0 | 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 | 0 | FOR XML EXPLICIT does not support XMLTEXT field on tag '%.*ls' that has IDREFS or NMTOKENS fields. |
6840 | 16 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | FOR XML EXPLICIT: XML data types and CLR 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 | 0 | Two (or more) elements named '%.*ls' are of different types and not direct siblings in the same level. |
6845 | 16 | 0 | 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 | 0 | XML name space prefix '%.*ls' declaration is missing for FOR XML %.*ls name '%.*ls'. |
6847 | 16 | 0 | The column '%.*ls' is of type sql_variant, which is not supported in attribute-centric FOR XML, with XML Schema. |
6848 | 16 | 0 | 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 | 0 | FOR XML PATH error in column '%.*ls' - '//' and leading and trailing '/' are not allowed in simple path expressions. |
6850 | 16 | 0 | %.*ls name '%.*ls' contains an invalid XML identifier as required by FOR XML; '%c'(0x%04X) is the first character at fault. |
6851 | 16 | 0 | Column '%.*ls' has invalid data type for attribute-centric XML serialization in FOR XML PATH. |
6852 | 16 | 0 | Attribute-centric column '%.*ls' must not come after a non-attribute-centric sibling in XML hierarchy in FOR XML PATH. |
6853 | 16 | 0 | Column '%.*ls': the last step in the path can't be applied to XML data type or CLR type in FOR XML PATH. |
6854 | 16 | 0 | 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 | 0 | Inline schema is not supported with FOR XML PATH. |
6856 | 16 | 0 | FOR XML row XML tag name contains an invalid XML identifier; '%c'(0x%04X) is the first character at fault. |
6857 | 16 | 0 | FOR XML root XML tag name contains an invalid XML identifier; '%c'(0x%04X) is the first character at fault. |
6858 | 16 | 0 | XML schema URI contains character '%c'(0x%04X) which is not allowed in XML. |
6859 | 16 | 0 | Row tag name is only allowed with RAW or PATH mode of FOR XML. |
6860 | 16 | 0 | FOR XML directive XMLDATA is not allowed with ROOT directive or row tag name specified. |
6861 | 16 | 0 | Empty root tag name can't be specified with FOR XML. |
6862 | 16 | 0 | Empty FOR XML target inline schema URI is not allowed. |
6863 | 16 | 0 | Row tag omission (empty row tag name) is not compatible with XMLSCHEMA FOR XML directive. |
6864 | 16 | 0 | Row tag omission (empty row tag name) cannot be used with attribute-centric FOR XML serialization. |
6865 | 16 | 0 | FOR XML does not support CLR types - cast CLR types explicitly into one of the supported types in FOR XML queries. |
6866 | 16 | 0 | Use of a system reserved XML schema URI is not allowed. |
6867 | 16 | 0 | 'xmlns' is invalid in XML tag name in FOR XML PATH, or when WITH XMLNAMESPACES is used with FOR XML. |
6868 | 16 | 0 | The following FOR XML features are not supported with WITH XMLNAMESPACES list: EXPLICIT mode, XMLSCHEMA and XMLDATA directives. |
6869 | 16 | 0 | Attempt to redefine namespace prefix '%.*ls' |
6870 | 16 | 0 | Prefix '%.*ls' used in WITH XMLNAMESPACES clause contains an invalid XML identifier. '%c'(0x%04X) is the first character at fault. |
6871 | 16 | 0 | Prefix '%.*ls' used in WITH XMLNAMESPACES is reserved and cannot be used as a user-defined prefix. |
6872 | 16 | 0 | 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 | 0 | Redefinition of 'xsi' XML namespace prefix is not supported with ELEMENTS XSINIL option of FOR XML. |
6874 | 16 | 0 | Empty URI is not allowed in WITH XMLNAMESPACES clause. |
6875 | 16 | 0 | URI '%.*ls' used in WITH XMLNAMESPACES is invalid. '%c'(0x%04X) is the first character at fault. |
6876 | 16 | 0 | URI used in WITH XMLNAMESPACES is too long. The maximum length is %d characters. |
6877 | 16 | 0 | Empty namespace prefix is not allowed in WITH XMLNAMESPACES clause. |
6878 | 16 | 0 | FORXML XMLSCHEMA cannot be used with a typed XML column whose schema collection is empty. |
6879 | 16 | 0 | 'xml' is an invalid XML processing instruction target. Possible attempt to construct XML declaration using XML processing instruction constructor. XML declaration construction with FOR XML is not supported. |
6901 | 16 | 0 | XML Validation: XML instance must be a document. |
6902 | 16 | 0 | 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 | 0 | 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 | 0 | XML Validation: Found duplicate attribute '%s'. %S_MSG %s |
6905 | 16 | 0 | XML Validation: Attribute '%s' is not permitted in this context. %S_MSG %s |
6906 | 16 | 0 | XML Validation: Required attribute '%s' is missing. %S_MSG %s |
6907 | 16 | 0 | Namespace URI too long: '%.*ls'. |
6908 | 10 | 0 | XML Validation: Invalid content. Expected element(s): %s. %S_MSG %s |
6909 | 16 | 0 | XML Validation: Text node is not allowed at this location, the type was defined with element only content or with simple content. %S_MSG %s |
6910 | 16 | 0 | XML Validation: Invalid definition for type '%ls'. SQL Server does not currently support restriction of union types. |
6911 | 16 | 0 | XML Validation: Found duplicate element '%s' in all content model. %S_MSG %s |
6912 | 16 | 0 | XML Validation: Element '%s' found in text only content model. %S_MSG %s |
6913 | 16 | 0 | XML Validation: Declaration not found for element '%s'. %S_MSG %s |
6914 | 16 | 0 | XML Validation: Type definition for type '%s' was not found, type definition is required before use in a type cast. %S_MSG %s |
6915 | 16 | 0 | Element or attribute name too long: '%.*ls'. |
6916 | 16 | 0 | 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 | 0 | 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. %S_MSG %ls |
6918 | 16 | 0 | XML Validation: Element '%s' must not have character or element children, because xsi:nil was set to true. %S_MSG %s |
6919 | 16 | 0 | XML Validation: The type of element '%s' is abstract. Instantiation requires the use of xsi:type to specify a non-abstract type. %S_MSG %s |
6920 | 16 | 0 | Invalid definition for type '%ls'. Cannot specify use="prohibited" for attribute '%ls' because there is no corresponding attribute in the base type. |
6921 | 16 | 0 | 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. %S_MSG %s |
6922 | 16 | 0 | XML Validation: Not able to resolve namespace for prefix:'%.*ls' |
6923 | 16 | 0 | XML Validation: Unexpected element(s): %s. %S_MSG %s |
6924 | 16 | 0 | XML Validation: Text '%.*ls' found in attribute-only content model. %S_MSG %s |
6925 | 16 | 0 | Invalid definition for element '%ls'. SQL Server does not currently permit additions to existing substitution groups via ALTER XML SCHEMA COLLECTION. |
6926 | 16 | 0 | XML Validation: Invalid simple type value: '%s'. %S_MSG %s |
6927 | 16 | 0 | XML Validation: Invalid simple type value: '%ls'. |
6928 | 16 | 0 | 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 | 0 | XML Validation: Invalid QName for xsi:type attribute '%.*ls'. |
6930 | 16 | 0 | XML Validation: ID constraint check failed. Found attribute named '%.*ls' with duplicate ID value '%.*ls'. %S_MSG %s |
6931 | 16 | 0 | XML Validation: IDREF constraint check failed. Found attribute named '%.*ls' with reference to ID value '%.*ls', which does not exist |
6932 | 16 | 0 | Invalid definition for element or attribute '%s'. Value constraints on components of type ID are not allowed. |
6933 | 16 | 0 | XML Validation: Invalid simple type operation, inserting into simple type is not permitted. %S_MSG %s |
6934 | 16 | 0 | XML Validation: Element '%s' requires substitution, because it was defined as abstract. %S_MSG %s |
6935 | 16 | 0 | XML Validation: ID or IDREF attribute exceeded the allowed maximum length. %S_MSG %s |
6936 | 16 | 0 | XML Validation: Invalid cast for element '%s' from type '%s' to type '%s'. %S_MSG %s |
6937 | 16 | 0 | 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. %S_MSG %ls |
6938 | 16 | 0 | 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. |
6939 | 16 | 0 | XML Validation: The element '%ls' is mixed content with a fixed value and therefore not allowed to have element content. %S_MSG %ls |
6940 | 16 | 0 | Invalid component named '%s' found in global scope. Only elements, attributes, types and groups can be defined in global context |
6941 | 16 | 0 | Invalid type definition for type '%s', types with complex content can only be derived from base types which have complex content |
6942 | 16 | 0 | Invalid type definition for type '%s', types with simple content can only be derived from base types which have simple content |
6943 | 16 | 0 | Invalid type definition for type '%s', the derivation was illegal because 'final' attribute was specified on the base type |
6944 | 16 | 0 | Invalid type definition for type '%s', '%s' facet is not restricting the value space |
6945 | 16 | 0 | Invalid facet value for facet '%s' in type definition '%s' |
6946 | 16 | 0 | Invalid type definition for type '%s', 'minLength' can not be greater than 'maxLength' |
6947 | 16 | 0 | XML Validation: Multiple ID attributes found on a single element. %S_MSG %s |
6948 | 16 | 0 | Invalid type definition for type '%s', 'minLength' can not be greater than 'Length' |
6949 | 16 | 0 | Invalid type definition for type '%s', 'Length' can not be greater than 'maxLength' |
6950 | 16 | 0 | Invalid type definition for type '%s', 'fractionDigits' can not be greater than 'totalDigits' |
6951 | 16 | 0 | Invalid type definition for type '%s', 'minInclusive' must be less than or equal to 'maxInclusive' and less than 'maxExclusive' |
6952 | 16 | 0 | Invalid type definition for type '%s', 'minExclusive' must be less than or equal to 'maxExclusive' and less than 'maxInclusive' |
6953 | 16 | 0 | Invalid type definition for type '%s', recursive type definitions are not allowed |
6954 | 16 | 0 | Invalid group definition for group '%s', recursive group definitions are not allowed |
6955 | 16 | 0 | Invalid attribute definition for attribute '%s', attributes type has to be simple type |
6956 | 16 | 0 | Invalid type definition for type '%s', fixed facet '%s' can not be redefined to a different value. |
6957 | 16 | 0 | Invalid element definition, element '%s' is not valid derivation of element '%s' |
6958 | 16 | 0 | 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 | 0 | Invalid definition, top level group definitions can not have model groups as siblings |
6960 | 16 | 0 | 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 | 0 | The system limit on the number of XML types has been reached. Redesign your database to use fewer XML types. |
6962 | 16 | 0 | 'default' and 'fixed' values are not allowed on element of this type: '%s' |
6963 | 16 | 0 | 'Default' or 'Fixed' value is longer than allowed, maximum length allowed is 4000 characters : '%s' |
6964 | 16 | 0 | Facet value is longer than allowed, maximum length allowed is 4000 characters : '%s' |
6965 | 10 | 0 | XML Validation: Invalid content. Expected element(s): %s. Found: element '%s' instead. %S_MSG %s. |
6966 | 10 | 0 | Warning: Type '%s' is restricted by a facet '%s' that may impede full round-tripping of instances of this type |
6967 | 16 | 0 | 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 | 0 | Invalid type definition for type '%s'. Complex types cannot restrict simple types |
6969 | 16 | 0 | 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 | 0 | Invalid type definition for type '%s'. No type may have more than one attribute of any type derived from ID. |
6971 | 16 | 0 | Invalid type definition for type '%s'. Type contains attribute '%s' which is not allowed in base type. |
6972 | 16 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | Invalid redefinition of attribute '%s' in type '%s'. Must be fixed to the same value as in the derived type. |
6976 | 16 | 0 | Invalid redefinition of attribute '%s' in type '%s'. Derivation by extension may not redefine attributes. |
6977 | 16 | 0 | Invalid member type '%s' in union type '%s'. Unions may not have complex member types. |
6978 | 16 | 0 | Invalid item type for list type '%s'. The item type of a list may not itself be a list, and types derived from ID may not be used as item types in this release. |
6979 | 16 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | 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 | 0 | Invalid restriction for type '%s'. An 'all' particle may be restricted only by 'all', 'element', or 'sequence'. |
6988 | 16 | 0 | Invalid restriction for type '%s'. A 'choice' particle may be restricted only by 'element', 'choice', or 'sequence'. |
6989 | 16 | 0 | Invalid restriction for type '%s'. A 'sequence' particle may be restricted only by 'element' or 'sequence'. |
6990 | 16 | 0 | Invalid restriction for type '%s'. Invalid model group restriction. |
6991 | 16 | 0 | 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 | 0 | The content model of type '%s' contains two elements with the same name '%s' and different types, nullability, or value constraints. |
6993 | 16 | 0 | Value constraint on use of attribute '%s' must be consistent with value constraint on its declaration. |
6994 | 16 | 0 | 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 | 0 | Invalid definition for type '%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 | 0 | Invalid type definition for type '%s'. A type may not have both 'minInclusive' and 'minExclusive' or 'maxInclusive' and 'maxExclusive' facets. |
6997 | 16 | 0 | Invalid definition for element '%s'. An element which has a fixed value may not also be nillable. |
6998 | 16 | 0 | 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 | 0 | Invalid definition for element or attribute '%s'. Value constraints on components of type QName are not supported in this release. |