1 2009.0100.1600.01 338 alter 339 add 342 create proc 345 Syntax error in translation file %s 346 set implicit_transactions off 347 set implicit_transactions on 348 as 349 null 350 select 351 where 353 SET ROWCOUNT 354 SET NO_BROWSETABLE 355 BEGIN TRAN 356 SET TEXTSIZE 361 char 362 varchar 363 text 364 nchar 365 nvarchar 366 ntext 367 binary 368 varbinary 369 image 370 int 371 smallint 372 tinyint 373 float 374 real 375 numeric 376 money 377 datetime 378 bit 379 timestamp 380 uniqueidentifier 381 sql_variant 382 bigint 384 varchar(max) 385 nvarchar(max) 386 varbinary(max) 387 xml 388 smallmoney 389 smalldatetime 397 from 398 holdlock 400 create;drop;select;grant;revoke;alter;truncate;update;reconfigure;load;disk; 402 EXEC 403 IF @@TRANCOUNT > 0 COMMIT TRAN 404 IF @@TRANCOUNT > 0 ROLLBACK TRAN 405 select USER_NAME() select usertype,type,name from systypes where usertype>= 406 'INTERVAL %c''%lu'' YEAR(%u)' 407 'INTERVAL %c''%lu'' MONTH(%u)' 408 'INTERVAL %c''%lu'' DAY(%u)' 409 'INTERVAL %c''%lu'' HOUR(%u)' 410 'INTERVAL %c''%lu'' MINUTE(%u)' 411 'INTERVAL %c''%lu%s'' SECOND(%u,%u)' 412 'INTERVAL %c''%lu-%02lu'' YEAR(%u) TO MONTH' 413 'INTERVAL %c''%lu %02lu'' DAY(%u) TO HOUR' 414 'INTERVAL %c''%lu %02lu:%02lu'' DAY(%u) TO MINUTE' 415 'INTERVAL %c''%lu %02lu:%02lu:%02lu%s'' DAY(%u) TO SECOND(%u)' 416 'INTERVAL %c''%lu:%02lu'' HOUR(%u) TO MINUTE' 417 'INTERVAL %c''%lu:%02lu:%02lu%s'' HOUR(%u) TO SECOND(%u)' 418 'INTERVAL %c''%lu:%02lu%s'' MINUTE(%u) TO SECOND(%u)' 419 dbcc traceon(208) 420 set quoted_identifier 421 set ansi_nulls off set ansi_padding off set ansi_warnings off 423 table 424 %04d-%02u-%02u %02u:%02u:%02u.%03lu 439 drop 440 SET PARSEONLY ON 441 SET PARSEONLY OFF 442 SET NOEXEC ON 443 SET NOEXEC OFF 481 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 483 identity 484 , = 485 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 486 char binary decimal integer smallint float real double varchar date time timestamp longvarchar varbinary longvarbinary tinyint bit numeric 487 char(255);binary(255);decimal(38,4);int; smallint;float;real;float; varchar(255);datetime;datetime;datetime; text; varbinary(255);image; tinyint;bit;numeric(38,4); 488 char(255);binary(255);money; int; smallint;float;real;float; varchar ;datetime;datetime;datetime; text; varbinary ;image; tinyint;bit; 489 set numeric_roundabort on 510 avg 511 cnt 512 max 513 min 514 sum 515 stdev 516 stdevp 517 var 518 varp 519 order 540 BREAK,BROWSE,BULK,CHECKPOINT,CLUSTERED,COMMITTED,COMPUTE,CONFIRM,CONTROLROW,DATABASE,DBCC,DISK,DISTRIBUTED,DUMMY,DUMP,ERRLVL,ERROREXIT,EXIT,FILE,FILLFACTOR,FLOPPY,HOLDLOCK,IDENTITY_INSERT,IDENTITYCOL,IF,KILL,LINENO,LOAD,MIRROREXIT, 541 NONCLUSTERED,OFF,OFFSETS,ONCE,OVER,PERCENT,PERM,PERMANENT,PLAN,PRINT,PROC,PROCESSEXIT,RAISERROR,READ,READTEXT,RECONFIGURE,REPEATABLE,RETURN,ROWCOUNT,RULE,SAVE,SERIALIZABLE,SETUSER,SHUTDOWN,STATISTICS, 542 TAPE,TEMP,TEXTSIZE,TOP,TRAN,TRIGGER,TRUNCATE,TSEQUEL,UNCOMMITTED,UPDATETEXT,USE,WAITFOR,WHILE,WRITETEXT 544 BACKUP,BREAK,BROWSE,BULK,CHECKPOINT,CLUSTERED,COMMITTED,COMPUTE,CONFIRM,CONTROLROW,DATABASE,DBCC,DISK,DISTRIBUTED,DUMMY,ERRLVL,ERROREXIT,EXIT,FILE,FILLFACTOR,FLOPPY,HOLDLOCK,IDENTITY_INSERT,IDENTITYCOL,IF,KILL,LINENO,MERGE,MIRROREXIT, 545 NONCLUSTERED,OFF,OFFSETS,ONCE,OVER,PERCENT,PERM,PERMANENT,PLAN,PRINT,PROC,PROCESSEXIT,RAISERROR,READ,READTEXT,RECONFIGURE,REPEATABLE,RESTORE,RETURN,ROWCOUNT,RULE,SAVE,SERIALIZABLE,SETUSER,SHUTDOWN,STATISTICS, 546 TAPE,TEMP,TEXTSIZE,TOP,TRAN,TRIGGER,TRUNCATE,TSEQUEL,UNCOMMITTED,UPDATETEXT,USE,WAITFOR,WHILE,WRITETEXT 551 Error in received XML stream 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 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 \n Continue 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 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