552 The XML format received requires a more recent version of Microsoft SQL Server Native Client (SQLNCLI10.DLL)
553 XMLTEXT field contains an XML attribute that exceeds the limit of 128 characters.
554 The XML document contains an attribute or element name which exceeds the limit of 1792 characters.
555 The specified output stream is invalid
556 Streaming not supported over the selected column type
557 Streaming not supported over multiple column result
558 Unknown output encoding
561 URL paths are not allowed for schema or XSL files
564 The root value specified is not a valid xml name.
1106 sqlncli10.dll
1125 select substring('NY',status/1024&1+1,1) from master..sysdatabases where name=DB_NAME()
1177 03.52
1274 1995
40000 Cannot drop the index
40001 Microsoft SQL Server Login
40002 table
40003 owner
40004 database
40005 stored procedure
40006 (local)
40007 Microsoft SQL Server Login
40009 %1!s! cannot be used as a data source name.
40011 Help is not available
40012 Microsoft SQL Server DSN Configuration
40013 %1!s! is already a data source name.\nOverwrite?
40014 Invalid character in data source name.
40015 %1!s! is not an existing data source name.
40016 Do you want to convert your SQL Server 16 bit DSNs to 32 bit?
40017 Filling listbox requires a valid Login Id and Password or Use Trusted Connection
40018 Filling listbox failed:\nSQLState: '%1!s!'\n SQL Server Error: %2!ld!\n%3!s!
40019 Connection failed:\nSQLState: '%1!s!'\nSQL Server Error: %2!ld!\n%3!s!\n
40020 &Server:
40021 (Default)
40022 Unknown Translator
40023 Select Log File
40024 Log Files(*.log)|*.log|All Files(*.*)|*.*|
40025 Query Logging Threshold field must be numeric
40026 At %1!s! the following query executed in %2!lu! milliseconds
40027 Error %1!d! occurred. No description was returned by server '%2!s!'.
40028 Configure
40029 Create a New Data Source to SQL Server
40030 <Unable to display>
40031 skipped
40032 Row
40033 Column
40034 Microsoft SQL Server Native Client Version %1!02u!.%2!02u!.%3!04u!
40038 Running connectivity tests...
40039 Attempting connection
40040 Connection established
40041 Verifying option settings
40042 Disconnecting from server
40043 TESTS COMPLETED SUCCESSFULLY!
40044 TESTS FAILED!
40048 The database entered is not valid
40049 The mirror server can't be specified without a specific database
40050 WARNING: The code page on the server does not equal the code page on the client.\n'Perform translation for character data' should be checked
40051 The passwords you typed do not match. Type the new password in both text boxes.
40052 INFO: A network alias was found for the DSN server. 'Protocol: %1!ls!; Address: %2!ls!' was used to establish the connection.
40053 WARNING: The DSN server is Microsoft SQL Server 2000 or older that does not support Multiple Active Result Sets (MARS).
40054 INFO: Data encryption was enforced by server or client machine-wide setting.
40055 INFO: Connection was encrypted without server certificate validation.
40056 INFO: Connection was encrypted with server certificate validation.
40057 WARNING: The 'mirror server' in the DSN does not match the server configuration. '%1!ls!' will be used upon failover.
40058 SQL Server Native Client Connection Page
40059 SQL Server Native Client Advanced Page
40060 SQLNCLI OLEDB Connection Page
40061 SQLNCLI OLEDB Advanced Page
40062 Microsoft SQL Server Databases (*.mdf)|*.mdf|All Files (*.*)|*.*|
40063 Select SQL Server Database File
40064 mdf
40065 Operation cannot be completed due to insufficient memory.
40066 Operation cannot be completed.
40067 SQL Server Native Client Data Link Error
40070 Connection failed because of an error in creating data source object.
40071 Connection failed because of an error in setting one or more properties.
40072 Connection failed because of an error in querying provider interfaces.
40073 Connection failed with initialization error. Check name and authentication settings.
40074 Connection failed because of an error in uninitializing provider.
40075 Connection failed.\n\n
40076 Connection failed with unknown error.
40077 Test connection succeeded.
40078 Test connection succeeded but some settings were not accepted by the provider.
40079 Connection may fail because not all properties could be set.\n\n
40080 \nContinue with the connection?
40081 SQL Server Native Client Data Link
40082 not supported
40083 bad value
40084 bad option
40085 bad column
40086 not all settable
40087 not settable
40088 not set
40089 conflicting
40090 unknown status
40091 Change Password Succeeeded.
40092 Change Password Failed.
40094 Failed to obtain database properties.
40095 Connection succeeded, but databases information could not be retrieved.
40114 COUNT field incorrect or syntax error
40115 Restricted data type attribute violation
40116 Invalid use of default parameter
40117 Client unable to establish connection
40118 Server rejected the connection
40119 Communication link failure
40120 Insert value list does not match column list
40121 Degree of derived table does not match column list
40122 String data, right truncation
40123 Indicator variable required but not supplied
40124 Numeric value out of range
40125 Invalid character value for cast specification
40126 Invalid date format
40127 Invalid time format
40128 Invalid timestamp format
40129 String data, length mismatch
40130 Invalid cursor state
40131 Invalid transaction state
40132 Invalid authorization specification
40133 Invalid authorization specification; Access to selected database has been denied
40134 Invalid authorization specification; Language specified is not supported
40135 Invalid cursor name
40136 Syntax error, permission violation, or other nonspecific error
40137 Duplicate cursor name
40138 Server declined cancel request
40140 Packet size change not supported by server, default used
40141 Dialog failed
40142 Unable to load translation DLL
40143 Translation module is not valid
40144 General error
40146 The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.
40147 Unknown token received from SQL Server
40148 Operation not allowed while results are pending
40149 Unable to load communication module. Driver has not been correctly installed.
40150 Communication module is not valid. Driver has not been correctly installed.
40151 Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed.
40152 Connection is busy with results for another command
40153 Failure during closing of connection
40154 Protocol error in TDS stream
40156 Non-default parameter not allowed after default parameter
40157 Memory allocation failure
40158 Invalid Descriptor Index
40159 Invalid application buffer type
40160 Operation canceled
40161 Invalid use of null pointer
40162 Function sequence error
40163 Operation invalid at this time
40164 No cursor name available
40165 Invalid string or buffer length
40166 Invalid descriptor field identifier
40167 Invalid attribute/option identifier
40168 Invalid parameter number
40169 Inconsistent descriptor information
40170 Invalid precision or scale value
40171 Invalid information type
40172 Invalid precision value
40173 Invalid parameter type
40174 Fetch type out of range
40175 Row value out of range
40176 Invalid cursor position
40177 Invalid bookmark value
40178 Optional feature not implemented
40179 Login timeout expired
40180 Connection does not exist
40184 Non-character and non-binary data sent in pieces
40185 First parameter in {rpc command represents stored procedure return value and has to be defined as output parameter
40186 {rpc command is automatically prepared, prepare is not needed
40187 When executing {rpc command user is required to Set Parameter Information for all parameters
40188 {rpc commands can not use server side cursors
40190 Prepared statement is not a cursor-specification
40192 Attempt to concatenate to a null or default value
40193 Cannot insert or update columns from multiple tables.
40194 Cannot modify an implementation row descriptor
40195 Invalid SQL data type
40197 Interval field overflow
40198 Associated statement is not prepared
40199 Invalid attribute value
40200 Database is invalid or cannot be accessed
40201 Connection is not enabled for BCP
40202 Unable to derive parameter information for a temporary stored procedure.
40203 ODBCBCP.dll is not compatible with 'SQL Server Native Client' driver. Please configure 'SQL Server' driver for the DSN or connection string
40205 Unicode conversion failed
40206 Bad BCP direction. Must be either IN or OUT
40207 Unable to open BCP host data-file
40208 Unable to open BCP error-file
40209 Table has no text/image columns
40210 I/O error while writing BCP error-file
40211 Invalid option
40212 Attempt to bulk-copy a NULL value into a Server column which does not accept NULL values
40213 BCP host-files must contain at least one column
40214 I/O error while writing BCP data-file
40215 Host-file columns may be skipped only when copying into the Server
40216 Unexpected EOF encountered in BCP data-file
40217 Attempt to read unknown version of BCP format file
40218 Incorrect host-column number found in BCP format-file
40219 Bad terminator
40220 For BCP, all variable-length data must have either a length-prefix or a terminator specified
40221 I/O error while reading BCP format file
40222 Table contains less rows than first row count
40223 Table contains less rows than last row count
40224 Attempt to bulk-copy an oversized column to the SQL Server
40225 The BCP host-file contains less rows than first row count
40226 Neither DSN nor SERVER keyword supplied
40227 All bound columns are read-only
40228 Cannot initialize SSPI package
40229 Cannot generate SSPI context
40230 Text column data incomplete
40231 Datetime field overflow
40232 Conversions not allowed using bcp_moretext
40233 The row length exceeds SQL Server's maximum allowable size
40234 Unicode conversion failed. Code page of server not on client
40235 I/O error while reading/writing BCP data-file
40236 Not enough columns bound
40238 Unable to resolve column level collations. Bulk-copy cannot continue.
40239 DBTYPE_IUNKNOWN or DBTYPE_XML bindings are only allowed for BLOB output parameters
40240 DBTYPE_IUNKNOWN or DBTYPE_XML bindings can only be followed by DBTYPE_IUNKNOWN or DBTYPE_XML bindings
40242 Conversion to sql_variant sub type not supported
40243 Incorrect format for native variant field
40244 Variant operation reqested on column that is not sql_variant
40245 Invalid buffer size for BCP column property
40246 Unknown BCP column property
40247 Text file mode selected. Character column types only expected.
40248 Field size undefined. Column type cannot be set until field size is defined.
40249 Server column undefined. Column type cannot be set until server column number is defined.
40250 Invalid field size for datatype
40251 Collation name [%1!s!] could not be resolved for column [%2!s!] by target server
40252 Server column order must match field order of file for BCP with QUERYOUT
40253 Column number invalid
40254 Invalid buffer
40256 Unspecified error occurred on SQL Server. Connection may have been terminated by the server.
40257 Warning: Server data (%1!Iu! bytes) exceeds host-file field length (%2!u! bytes) for field (%3!u!). Use prefix length, termination string, or a larger host-file field size. Truncation cannot occur for BCP output files.
40259 Format file could not be opened. Invalid name specified or access denied.
40261 Invalid table name provided for bcp operation.
40263 Variable length types of unlimited length should have 8 byte prefix.
40267 Format File : Invalid Data type.
40273 Format File : Invalid Collation.
40283 Format File : Unknown error occurred while attempting to read.
40284 Server does not support this attribute. Setting of this attribute is ignored.
40285 Setting this attribute requires some others also to be set. Setting of this attribute is ignored.
40286 Unable to resolve column level collations. Bulk-copy cannot continue.
40287 Invalid format file version
40288 Unable to resolve column level collations
40289 Parameter information is missing from a user-defined type.
40290 Invalid attribute/option identifier (SQL_COPT_SS_INTEGRATED_AUTHENTICATION_METHOD is only available for Trusted Connections)
40350 Enlistment is not possible due to pending transaction
40351 Distributed transaction error
40352 Cannot specify old password when using trusted connection
40353 Server rejected the connection; Access to selected database has been denied
40354 Server rejected the connection; Language specified is not supported
40400 General warning
40401 Ongoing transaction has been committed
40403 Access to database configured in the DSN has been denied. Default used.
40404 Language configured in the DSN is not supported. Default used.
40405 Procedure executed with 'EXEC'. No output parameters returned.
40406 An error has occurred during an attempt to access the log file, logging disabled.
40407 Connected to backup server
40409 Translation options conflict with client/server character sets
40410 String data, right truncation
40412 %1!ld! rows sent to SQL Server. Total sent: %2!I64d!
40413 String data, right truncation
40415 %1!ld! rows successfully bulk-copied to host-file. Total received: %2!I64d!
40416 Zero length data forced to length 1
40417 Null bit data forced to zero
40418 Cursor was not closed
40419 Warning: Code page translation caused loss of data
40448 No database is specified for a failover partner server to mirror
40449 Invalid value specified for connection string attribute '%1!s!'
40450 Invalid connection string attribute
40451 Error in row
40452 Option value changed
40453 Packet size change not honored by server, server size used
40454 Packet size changed
40455 Cursor type changed
40456 Cursor concurrency changed
40457 Login timeout changed
40458 Cursor operation conflict
40459 Cancel treated as FreeStmt/Close
40460 Attempt to fetch before the result returned the first rowset
40461 Fractional truncation
40462 Unable to derive parameter information when parameter marker is a function argument
40463 Packet size requested by server is invalid
40464 Unable to open a logical session
40465 The fractional part of the provided time value overflows the scale of the corresponding SQL Server parameter or column. Increase bScale in DBPARAMBINDINFO or column scale to correct this error.
40466 The number of fields provided for bcp operation is less than the number of columns on the server.
40467 The code page specified for bcp operation is not supported on the machine.
40468 Client unable to establish connection due to prelogin failure
40470 Invalid table column name for bcp format file, conversion to MBCS failed.
40471 Data provided for user-defined type column exceeds the maximum length
40472 Query timeout expired
40473 The connection attempted to fail over to a database which is not configured for database mirroring.
40474 Catalog or schema name of XML schema collection can not be specified without specifying the name of XML schema collection.
40475 This version of SQL Server Native Client does not support UTF-8 encoding (code page 65001)
40479 Unable to complete login process due to delay in opening server connection
40480 Unable to complete login process due to delay in prelogin response
40481 Unable to complete login process due to delay in login response
40482 A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
40483 Parameter focus does not refer to a table-valued parameter
40484 Invalid attribute value, SQL_SOPT_SS_PARAM_FOCUS (must be zero at execution time)
40485 Warning: The data for column %1!u!, was truncated by %2!u! bytes because the column ended with an invalid MBCS character.
40486 Conversion not allowed from the given field type 0x%1!X! for field %2!u! to column %3!u!.
40487 Error during string encryption. The operating system returned error %1!u!. Please take corrective action based on the operating system error.
40488 Error during string decryption. The operating system returned error %1!u!. Please take corrective action based on the operating system error.
40489 The connection is no longer usable because the server failed to respond to a command cancellation for a previously executed statement in a timely manner. Possible causes include application deadlocks or the server being overloaded. Open a new connection and re-try the operation.
40490 The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted.
40491 Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.
40492 Datetime field overflow. Operating system error occurred while attempting to obtain time zone information.
40501 Data Source Name
40502 Data Source Name
40503 Data Source Description
40504 Driver
40505 Server
40506 Login ID
40507 Password
40508 Use Integrated Security
40509 AppName
40510 WorkStation ID
40511 Database
40512 Language
40515 Translate Character Data
40516 Log Long Running Queries
40517 Query Log File
40518 Query Log Time
40519 Log Driver Statistics
40520 Statistics File
40521 Use Regional Settings
40522 Use ANSI Quoted Identifiers
40523 Use ANSI Null, Paddings and Warnings
40524 Attach Database Filename
40525 Data Encryption
40526 Multiple Active Result Sets(MARS)
40527 Mirror Server
40529 Trust Server Certificate
40530 Server Service Principle Name(SPN)
40531 Mirror Server Service Principle Name(SPN)
40619 SQL Server requires Encryption On.
40620 Encryption not supported on SQL Server.
40621 Encryption not supported on the client.
40622 SQL Server Native Client 10.0 does not support connections to SQL 7.0 or earlier versions.
40623 Failed to read prelogin response.
40624 Changing password during login is only supported for SQL Server 2005 and above.
40625 Connection to a pre-released SQL server with intermediate TDS version is not supported.
40626 Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.
40627 Registry information is corrupt or missing. Make sure the provider installed and registered correctly.
40701 The data source can not be used, because its DBMS version is less than 7.0.
40702 The requested properties cannot be supported.
40703 Operation Canceled
40704 Nested variants are not supported as parameters.
40705 At least one parameter contained a type that was not supported.
40706 Unable to determine parameter type for at least one variant parameter.
40707 Cannot start transaction because more than one connection is in use.
40708 Cannot create new connection because in manual or distributed transaction mode.
40709 Cannot start transaction while in firehose mode.
40710 The data source can not be used, because it is not a Microsoft SQL Server.
40711 The object is in a zombie state. An object may enter a zombie state when either ITransaction::Commit or ITransaction::Abort is called, or when a storage object was created and not yet released.
40712 Cannot start transaction while in fastload mode.
40713 IRowset interfaces are not supported on a fastload rowset.
40714 The precision is invalid.
40715 The scale is invalid.
40716 Deferred prepare could not be completed.
40717 Parameter Information cannot be derived from SQL statements with sub-select queries. Set parameter information before preparing command.
40718 Unable to read stream data because ACCESSORDER is sequential and the column has already been passed.
40719 Some columns could not be retrieved because ACCESSORDER is sequential and the columns have already been passed.
40720 Unexpected server side behavior.
40721 Failed to load library sqlxmlx.dll. Please make sure it is properly installed and registered.
40722 Property IRowsetFastLoad cannot be set optional.
40723 Warning:Firehose rowsets cannot be preserved.
40724 Parameter Information cannot be derived from SQL statements. Set parameter information before preparing command.
40725 Invalid input parameter values. Check the status values for detail.
40726 At least one parameter can not be derived from the binding info. Set parameter information first.
40727 Sequential stream cannot be created for uncommitted text or image data.
40728 <Unable to display>
40729 An xml index can only be created on a single xml column.
40730 SetParameterProperties method cannot be called for the specified parameters without first calling SetParameterInfo method. The parameter information must be set before setting the parameter properties.
40731 Missing parameter properties. DBTYPE_UDT requires parameter properties to be set in addition to setting parameter info.
40732 Missing XML collection name. If XML schema or XML catalog properties are provided, XML collection name must be provided as well.
40733 Cannot start transaction because there are active results on the connection
40801 The database name specified is invalid
40802 Database name not specified in the provider string
40803 Could not find a property containing the database name
40804 A database with the provided name was created but could not be dropped when errors occurred
40810 File field number specified is out of range.
40811 BCPColumns should be called before calling BCPColFmt.
40812 The buffer size for the field attribute value is too small.
40813 Attribute for the field must have a non-null value.
40814 The column number attribute corresponding to the current field has invalid value.
40815 You can only skip fields for BCP in operation
40816 The column number for the field must be set before specifying its type.
40817 The type of the field must be SQLCHAR or SQLNCHAR for character mode operation.
40818 The specified size of the field is too large.
40819 The specified size of the field is invalid.
40820 An unknown field type was specified.
40821 Variable length field requires either a prefix or a terminator.
40822 Prefix length must be 0,1,2 or 4.
40823 Terminator must have a greater than 0 length.
40824 Conversion between the user specified field type and database column type is not possible.
40825 The buffer passed as parameter has a NULL pointer, must be non-NULL
40826 This function can not be called while using the BCP API
40827 At the time of call to BCPColumns, the number of columns must be 0. BCPColumns can be called only once during a BCP operation
40828 Bulk Copy must be initialized before calling this function.
40829 Version of file must be 60, 65, 70 or 80.
40830 Metadata request query failed
40831 BCPExec can not be called programatically
40832 Operation has already been aborted.
40833 Data file is not open for BCP operation.
40834 Input file is not present
40835 Read operation from data file failed, format of file might be invalid
40836 Write operation on data file failed
40837 Field format could not be specified
40838 Not enough information to continue execution
40839 Send/Receive Operation Failed
40840 Bulk Copy Rowsets are not Enabled
40841 Invalid direction for the BCP operation has been specified
40842 Table name is required for BCP in operation
40843 Data file must be specified for out operation
40844 File Could not be opened
40845 The format file name should be specified
40846 The version of format file is unknown
40847 The fields in the format file are not in order
40848 Data type for field in the format file is unknown
40849 The prefix length for a field is invalid
40850 The field length for a field in invalid
40851 The format of a terminator is invalid
40852 Table column number specified in format file is invalid
40853 There should be not hints for BCP out with out of order columns
40854 The field data has not been intialized
40855 Write operation on format file failed
40856 Could not convert data type token to its corresponding name
40857 BCPInit should be called before calling any other BCP API function
40858 I/O error while writing BCP data-file
40901 Bad file path
40902 File already open
40903 File not open
40904 End of file reached, terminator missing or field data incomplete
40905 memory mapped file read failed
40906 memory mapped file write failed
40907 invalid seek position
40908 Seek failed
40909 Bad bcp direction
40910 Bad table name
40911 need table name for bcp in
40912 need file name for out
40913 metadata query generation failed
40914 metadata query failed
40915 collations could not be resolved
40916 invalid api call for programmatic transfer
40917 at least one field should be provided
40918 This api can be called only once per bcp operation
40919 Field information need be initialized first
40920 Field no. invalid
40921 Column no. invalid
40922 Skipped fields only allowed for bcp in
40923 Term len invalid
40924 Attrib should be non-null
40925 Prefix len invalid
40926 Field len invalid
40927 Field type must be char
40928 Field size too large
40929 invalid field size
40930 Field type invalid
40931 Prefix size invalid
40932 Term size invalid
40933 Field conversion not possible
40934 data file is not open
40935 Query for data failed
40936 End reached before first row
40937 Failed to read from server
40938 Could not read till last row
40939 Bad collation name
40940 Invalid combo of prefix and length
40941 Failed to read column length
40942 Failed to read column data
40943 Failed to read BLOB column
40944 Data conversion failed
40945 Failed to send batch after max errors
40946 Failed to send batch
40947 Format file version invalid
40948 Invalid table name
40949 Invalid option specified
40950 Insert bulk failed because all the columns requested to be inserted into are either read-only or identity columns and KeepIdentity is off
40951 Insert bulk failed
40952 Insert bulk metadata send failed
40953 Batch send failed
40954 End reached before first row
40955 End reached before last row
40956 Not all rows could be copied
40957 Invalid format file
40958 Fields are out of order in format file
40959 Invalid field type
40960 Invalid field term
40961 Invalid table column
40962 No hints allowed in out of order column case
40963 Invalid format file version
40964 Invalid numeric format of data
40965 Reac char failed in format file
40966 Fields are not initialized
40967 Incorrect format for native variant field
40968 Query provided for bcp out does not give a result set
40969 One or more BLOB columns could not be sent to the server, attempt to recover from the problem failed.
40970 Invalid version for xml format file.
40971 The number of fields in the xml format file must be between 1 and 4096.
40972 Invalid ordinal for field %1!u! in xml format file.
40973 Invalid data type for field %1!u! in xml format file.
40974 Invalid prefix length for field %1!u! in xml format file.
40975 Invalid length for field %1!u! in xml format file.
40976 Invalid field terminator for field %1!u! in xml format file.
40977 Invalid column ordinal for field %1!u! in xml format file.
40978 Insufficient information for at least 1 field in xml format file.
40979 Invalid collation for field %1!u! in xml format file.
40980 Syntax error at line %1!u! column %2!u! in xml format file.
40981 Unexpected element %1 found in xml format file at line %2!u! column %3!u!.
40982 Unexpected InfoItem found in xml format file at line %1!u! column %2!u!.
40983 Unexpected attribute %1 found in xml format file at line %2!u! column %3!u!.
40984 A required attribute %1 is missing in xml format file for the field at line %2!u! column %3!u!.
40985 The value of attribute %1 is incorrect in xml format file for the field at line %2!u! column %3!u!.
40986 Duplicate values of attribute "ID" found in xml format file for the field at line %1!u! column %2!u!.
40987 An invalid reference to a field was found in xml format file at line %1!u! column %2!u!.
40988 A duplicate reference to a field was found in xml format file at line %1!u! column %2!u!.
40989 Unable to load xmlrw.dll while attempting to read xml format file.
40990 End of file reached while attempting to read the format file.
40991 Failed to create an instance of xml reader while attempting to read xml format file.
40992 BCP Operation was aborted by the user.
40993 The number of fields provided for bcp operation is less than the number of columns on the server.
40994 The code page specified for bcp operation is not supported on the machine.
40995 Invalid table column name specified in the format file, read operation failed.
40996 Invalid table column name for bcp format file, conversion to MBCS failed.
40997 Data provided for user-defined type column exceeds the maximum length
40998 This version of SQL Server Native Client does not support UTF-8 encoding (code page 65001)
41001 Warning: Server data exceeds host-file field length for a field. Use prefix length, termination string, or a larger host-file field size. Truncation cannot occur for BCP output files.
41002 %1!ld! rows sent to SQL Server. Total sent: %2!I64d!
41003 %1!ld! rows successfully bulk-1copied to host-file. Total received: %2!I64d!
41101 An unknown error has occurred. Detailed error information is not available.
41102 Constraints can not be specified for InMemory Rowset objects. InMemory Rowset creation failed.
41103 The specified number of columns (%1!Iu!) is more than the SQL Server limit of %2!u! columns for a Table/Table Type.
41104 The client code page %1!u! does not have a corresponding SQL Server Collation. InMemory Rowset creation failed.
41105 The name of column %1!Iu! was not provided. InMemory Rowset creation failed.
41106 The column name "%1!128s!" for column %2!Iu! is not a valid SQL Server identifier. InMemory Rowset creation failed.
41107 The pTypeInfo member of DBCOLUMNDESC structure was non-null for column %1!Iu!. InMemory Rowset creation failed.
41108 The type name "%1" for column %2!Iu! is invalid. InMemory Rowset creation failed.
41109 The length ~0 was specified for type "%1" for column %2!Iu!. ~0 is only a valid length for varchar(max)/nvarchar(max)/binary(max) or xml types. InMemory Rowset creation failed.
41110 The character length %1!Iu! specified for type "%2" for column %3!Iu! exceeded the maximum SQL Server allowed length of %4!d! characters. InMemory Rowset creation failed.
41111 The scale %1!u! exceeded the maximum limit of 7 for time/datetime2/datetimeoffset column %2!Iu!. InMemory Rowset creation failed.
41112 The "table" or "DBTYPE_TABLE" type specified for column %1!Iu! is only supported as type of a command parameter. InMemory Rowset creation failed.
41113 The identity property was attempted to be set for column %1!Iu!. Only columns of integer and numeric types can be marked as identity. InMemory Rowset creation failed.
41114 The default value was attempted to be set for column %1!Iu!. Default values can not be set for InMemory Rowset columns. InMemory Rowset creation failed.
41115 The fixed length property was attempted to be set for column %1!Iu! which can not be of fixed length. InMemory Rowset creation failed.
41116 The nullable property was attempted to be set for column %1!Iu! which is a timestamp column. timestamp columns do not allow null values. InMemory Rowset creation failed.
41117 The "%1" property was attempted to be set for column %2!Iu!. The column was either of type bit or a blob type for which this property can not be set. InMemory Rowset creation failed.
41118 The precision %1!u! specified for column %2!Iu! is out of the valid range of 1 to %3!d!. InMemory Rowset creation failed.
41119 The scale %1!u! exceeded the precision %2!u! specified for column %3!Iu!. InMemory Rowset creation failed.
41120 The "SSPROP_COL_UDT_NAME" property was not set for column %1!Iu!. This property must be set for user-defined types. InMemory Rowset creation failed.
41121 The "%1" property was invalid for column %2!Iu!. InMemory Rowset creation failed.
41122 One or more errors occurred while attempting to retrieve metadata information for InMemory Rowset. Check other errors for details. InMemory Rowset creation failed.
41123 InMemory Rowset objects can only be created on sessions connected to SQL Server 10 or newer.
41124 The scale %1!u! is incorrect for datetime/smalldatetime column %2!Iu!. InMemory Rowset creation failed.
41201 The client code page %1!u! does not have a corresponding SQL Server Collation. The Table-Valued Parameter could not be sent.
41202 A required interface "%1" was not exposed by a Table-Valued Parameter Rowset. The Table-Valued Parameter could not be sent.
41203 Failure to read Metadata information from a Table-Valued Parameter Rowset. The call to "%1" method on the TVP Rowset object failed.
41204 Failure to read Metadata information from a Table-Valued Parameter Rowset. Failure occurred while attempting to obtain Ordinals of the columns exposed by ColumnsRowset object of the Rowset.
41205 One or more required column is missing from the ColumnsRowset of a Table-Valued Parameter Rowset.
41206 A required interface "%1" was not exposed by the ColumnsRowset of a Table-Valued Parameter Rowset.
41207 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. Failure occurred in the method "%1" on the ColumnsRowset of the Table-Valued Parameter Rowset.
41208 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. Failure occurred in IRowset::GetNextRows method on the ColumnsRowset of the Table-Valued Parameter Rowset for Row %1!Iu!.
41209 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. The number of columns in the Rowset exceeded the SQL Server limit of %1!u! columns for a Table Type.
41210 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. One of NUMBER, TYPE, FLAGS or COLUMNSIZE data for Row %1!Iu! of ColumnsRowset of the Table-Valued Parameter Rowset was invalid.
41211 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. Either PRECISION or SCALE data for Row %1!Iu! of ColumnsRowset of the Table-Valued Parameter Rowset was invalid.
41212 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. One of user-defined type catalog/schema/typename data for Row %1!Iu! of ColumnsRowset of the Table-Valued Parameter Rowset was invalid.
41213 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. One of xml type catalog/schema/"schema collection name" data for Row %1!Iu! of ColumnsRowset of the Table-Valued Parameter Rowset was invalid.
41214 A failure occurred while reading Metadata information from a Table-Valued Parameter Rowset. The OLE DB type (%1!u!) for Column %2!Iu! does not correspond to any SQL Server supported data type.
41215 The number of default columns (%1!u!) specified for Table-Valued Parameter Rowset exceeds the total number of Table-Valued Parameter Rowset columns (%2!u!).
41216 The index (%1!u!) of a default Table-Valued Parameter Rowset column is outside the valid range of 1 to %2!u!.
41217 The Table-Valued Parameter column %1!u! was marked as default more than once.
41218 The Table-Valued Parameter column %1!Iu! was marked as default and it was also bound through accessor %2!Iu!. Default columns must not be bound through accessors.
41219 The Table-Valued Parameter column %1!Iu! was bound through multiple accessor bindings. Each Table-Valued Parameter Rowset column must only have 1 binding.
41220 The Table-Valued Parameter column %1!Iu! was not bound in the same accessor as it's surrounding columns (from %2!Iu! to %3!Iu!). Each accessor should have a contiguous set of columns bound in it.
41221 The Table-Valued Parameter column %1!Iu! was not bound through any accessor binding. Each non-default column must have 1 accessor binding.
41222 An attempt to create an accessor for fetching row data from a Table-Valued Parameter Rowset failed.
41223 The Table-Valued Parameter column %1!u! has duplicate ordering information.
41224 The index (%1!u!) for an ordered column of Table-Valued Parameter Rowset is outside the valid range of 1 to %2!u!.
41225 Column %1!u! of the Table-Valued Parameter Rowset was marked as ordered. However the ordering type specified %2!u! was neither Ascending (0x01) nor Descending (0x02)
41226 There are references to Table-Valued Parameter Rowset column BLOB objects that are held by the consumer. All ISequentialStream objects must be released by the consumer before command execution.
41227 A failure occurred while sending row data for a Table-Valued Parameter Rowset. Error occurred in method IRowset::RestartPosition while attempting to move to the 1st Row of the TVP Rowset object.
41228 A failure occurred while sending row data for a Table-Valued Parameter Rowset. Error occurred in method IRowset::GetNextRows while attempting to read Row %1!Iu!.
41229 A failure occurred while sending row data for a Table-Valued Parameter Rowset. Error occurred in method IRowset::GetData while attempting to read Row %1!Iu!, Column %2!Iu!.
41230 A failure occurred while sending row data for a Table-Valued Parameter Rowset. Null value was provided for Row %1!Iu!, Column %2!Iu! but the column is not null-able.
41231 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The status (%1!u!) provided for Row %2!Iu!, Column %3!Iu! was not neither DBSTATUS_S_OK nor DBSTATUS_S_ISNULL.
41232 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The length (%1!Iu!) for Row %2!Iu!, Column %3!Iu! exceeded the maximum column length of %4!Iu! bytes.
41233 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The data provided for Row %1!Iu!, Column %2!Iu! for column type "%3" was out of the range of valid values.
41234 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The data provided for Row %1!Iu!, Column %2!Iu! for column type "sql_variant" caused a conversion error.
41235 A failure occurred while sending row data for a Table-Valued Parameter Rowset. Error occurred in method IRowset::ReleaseRows while attempting to Release Row %1!Iu!.
41236 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The length (%1!Iu!) for Row %2!Iu!, Column %3!Iu! exceeded the maximum length (%4!Iu!) specified in the binding.
41237 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The length was not provided by the consumer for Row %1!Iu!, Column %2!Iu!. The provider failed to infer the length from the given data.
41238 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The provider failed to convert data for Row %1!Iu!, Column %2!Iu!.
41239 A failure occurred while sending row data for a Table-Valued Parameter Rowset. No data was provided for Row %1!Iu!, Column %2!Iu!.
41240 A failure occurred while sending row data for a Table-Valued Parameter Rowset. The failure occurred at Row %1!Iu!, Column %2!Iu!. Detailed error information is provided in other error messages.
41241 Table-Valued Parameter Rowset column data was bound as DBTYPE_IUNKNOWN but no object was provided in the data buffer.
41242 Table-Valued Parameter Rowset column data was bound as DBTYPE_IUNKNOWN but the object provided in the data buffer did not expose the ISequentialStream interface.
41243 Table-Valued Parameter Rowset column data was bound as DBTYPE_IUNKNOWN for a text/ntext/image column but no length was provided. Length of data is required to be specified for these column types.
41244 The length (%1!Iu!) provided for a text/ntext/image column of a Table-Valued Parameter Rowset exceeded the SQL Server limit of %2!Iu! bytes.
41245 Table-Valued Parameter Rowset column data was bound as DBTYPE_IUNKNOWN. A failure occurred during the call to ISequentialStream::Read method on the provided object.
41246 Table-Valued Parameter Rowset column data was bound as DBTYPE_IUNKNOWN with length %1!Iu!. Only %2!Iu! bytes of data could be read from the provided object which is less than expected.
41247 The specified Table-Valued Parameter type %1 could not be located on the server.
50000 HTTP Provider:
50001 Named Pipes Provider:
50002 Session Provider:
50003 Sign Provider:
50004 Shared Memory Provider:
50005 SMux Provider:
50006 SSL Provider:
50007 TCP Provider:
50008 VIA Provider:
50009 MAX_PROVS:
50010 SQL Server Network Interfaces:
50101 I/O Error detected in read/write operation
50102 Connection was terminated
50103 Asynchronous operations not supported
50105 Invalid parameter(s) found
50106 Unsupported protocol specified
50107 Invalid connection found when setting up new session protocol
50108 Protocol not supported
50109 Associating port with I/O completion mechanism failed
50111 Timeout error
50112 No server name supplied
50113 TerminateListener() has been called
50114 Win9x not supported
50115 Function not supported
50116 Shared-memory heap error
50117 Cannot find an ip/ipv6 type address to connect
50118 Connection has been closed by peer
50119 Physical connection is not usable
50120 Connection has been closed
50121 Encryption is enforced but there is no valid certificate
50122 Couldn't load library
50123 Cannot open a new thread in server process
50124 Cannot post event to completion port
50125 Connection string is not valid
50126 Error Locating Server/Instance Specified
50127 Error getting enabled protocols list from registry
50128 Server doesn't support requested protocol
50129 Shared Memory is not supported for clustered server connectivity
50130 Invalid attempt bind to shared memory segment
50131 Encryption(ssl/tls) handshake failed
50132 Packet size too large for SSL Encrypt/Decrypt operations
50133 SSRP error
50134 Could not connect to the Shared Memory pipe
50135 An internal exception was caught
50136 The Shared Memory dll used to connect to SQL Server 2000 was not found
50137 The SQL Server 2000 Shared Memory client dll appears to be invalid/corrupted
50138 Cannot open a Shared Memory connection to SQL Server 2000
50139 Shared memory connectivity to SQL Server 2000 is either disabled or not available on this machine
50140 Could not open a connection to SQL Server
50141 Cannot open a Shared Memory connection to a remote SQL Server instance
50142 Could not establish dedicated administrator connection (DAC) on default port. Make sure that DAC is enabled
50143 An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number
50144 Could not compose Service Principal Name (SPN) for Windows Integrated Authentication. Possible causes are server(s) incorrectly specified to connection API calls, Domain Name System (DNS) lookup failure or memory shortage
