SQL Error Type List with description from error 500 to 1000

Error Type =502,/n Error Description The SQL Debugging Interface (SDI) requires that SQL Server, when started as a service, must not log on as System Account. Reset to log on as user account using Control Panel.. Error Severity  Level=16

Error Type =503, Error Description Unable to send symbol information to debugger on %ls for connection %d. Debugging disabled.. Error Severity  Level=16

Error Type =504, Error Description Unable to connect to debugger on %ls (Error = 0x%08x). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on %.*ls. Debugging disabled for connection %d.. Error Severity  Level=16

Error Type =505, Error Description The current user account was invoked with SETUSER or SP_SETAPPROLE. Changing databases is not allowed.. Error Severity  Level=16

Error Type =506, Error Description The invalid escape character "%.*ls" was specified in a %ls predicate.. Error Severity  Level=16

Error Type =507, Error Description Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.. Error Severity  Level=16

Error Type =508, Error Description Unable to connect to debugger on %ls (Error = 0x%08x). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on %.*ls. Debugging disabled for connection %d.. Error Severity  Level=16

Error Type =509, Error Description User name '%.*ls' not found.. Error Severity  Level=11

Error Type =510, Error Description Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.. Error Severity  Level=16

Error Type =511, Error Description Cannot create a row of size %d which is greater than the allowable maximum of %d.. Error Severity  Level=16

Error Type =512, Error Description Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.. Error Severity  Level=16

Error Type =513, Error Description A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database '%.*ls', table '%.*ls', column '%.*ls'.. Error Severity  Level=16

Error Type =514, Error Description Unable to communicate with debugger on %ls (Error = 0x%08x). Debugging disabled for connection %d.. Error Severity  Level=16

Error Type =515, Error Description Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.. Error Severity  Level=16

Error Type =516, Error Description Attempt to initialize OLE library failed. Check for correct versions of OLE DLLs on this machine.. Error Severity  Level=16

Error Type =517, Error Description Adding a value to a '%ls' column caused overflow.. Error Severity  Level=16

Error Type =518, Error Description Cannot convert data type %ls to %ls.. Error Severity  Level=16

Error Type =520, Error Description SQL Server no longer supports version %d of the SQL Debugging Interface (SDI).. Error Severity  Level=16

Error Type =522, Error Description The WAITFOR thread was evicted.. Error Severity  Level=16

Error Type =523, Error Description A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.. Error Severity  Level=16

Error Type =524, Error Description A trigger returned a resultset and the server option 'disallow results from triggers' is true.. Error Severity  Level=16

Error Type =525, Error Description The column that was returned from the nodes() method cannot be converted to the data type %ls. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.. Error Severity  Level=16

Error Type =526, Error Description %ls of XML types constrained by different XML schema collections and/or DOCUMENT/CONTENT option is not allowed. Use the CONVERT function to run this query.. Error Severity  Level=16

Error Type =527, Error Description Implicit conversion between XML types constrained by different XML schema collections is not allowed. Use the CONVERT function to run this query.. Error Severity  Level=16

Error Type =528, Error Description System error detected during attempt to use the 'upsleep' system function.. Error Severity  Level=16

Error Type =529, Error Description Explicit conversion from data type %ls to %ls is not allowed.. Error Severity  Level=16

Error Type =530, Error Description The statement terminated. The maximum recursion %d has been exhausted before statement completion.. Error Severity  Level=16

Error Type =531, Error Description Cannot set NOCOUNT to OFF inside the trigger execution because the server option "disallow_results_from_triggers" is true or we are inside LOGON trigger execution.. Error Severity  Level=10

Error Type =532, Error Description The timestamp (changed to %S_TS) shows that the row has been updated by another user.. Error Severity  Level=16

Error Type =533, Error Description Cannot set XACT ABORT to OFF inside the trigger execution unless the database compatibility is 90.. Error Severity  Level=10

Error Type =534, Error Description %.*ls' failed because it is not supported in the edition of this SQL Server instance '%.*ls'. See books online for more details on feature support in different SQL Server editions.. Error Severity  Level=16

Error Type =535, Error Description Difference of two datetime columns caused overflow at runtime.

 The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.. Error Severity  Level=16"

 

Error Type =536, Error Description Invalid length parameter passed to the substring function.. Error Severity  Level=16

Error Type =537, Error Description Invalid length parameter passed to the LEFT or SUBSTRING function.. Error Severity  Level=16

Error Type =538, Error Description Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator.. Error Severity  Level=16

Error Type =539, Error Description Schema changed after the target table was created. Rerun the Select Into query.. Error Severity  Level=16

Error Type =540, Error Description There is insufficient system memory to run RAISERROR.. Error Severity  Level=16

Error Type =541, Error Description There is not enough stack to execute the statement. Error Severity  Level=16

Error Type =542, Error Description An invalid datetime value was encountered. Value exceeds the year 9999.. Error Severity  Level=16

Error Type =543, Error Description Creation of a return table failed for the table valued function '%.*ls'.. Error Severity  Level=16

Error Type =544, Error Description Cannot insert explicit value for identity column in table '<Table Name>' when IDENTITY_INSERT is set to OFF.. Error Severity  Level=16

Error Type =545, Error Description Explicit value must be specified for identity column in table '<Table Name>' when IDENTITY_INSERT is set to ON.. Error Severity  Level=16

"Error Type =547, Error Description INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'Constraint Name'.For more details

 UPDATE statement conflicted with COLUMN REFERENCE constraint 'Constraint Name'.

 DELETE statement conflicted with COLUMN REFERENCE constraint 'Constraint Name'.

 ALTER TABLE statement conflicted with COLUMN REFERENCE constraint 'Constraint Name'.. Error Severity  Level=16"

 

 

Error Type =548, Error Description The identity range managed by replication is full and must be updated by a replication agent. The %ls conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls. Sp_adjustpublisheridentityrange can be called to get a new identity range.. Error Severity  Level=16

Error Type =549, Error Description The collation '%.*ls' of receiving variable is not equal to the collation '%.*ls' of column '%.*ls'.. Error Severity  Level=16

Error Type =550, Error Description The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.. Error Severity  Level=16

Error Type =551, Error Description The checksum has changed to %d. This shows that the row has been updated by another user.. Error Severity  Level=16

Error Type =552, Error Description CryptoAPI function "%ls" failed. Error 0x%x: %ls. Error Severity  Level=16

Error Type =555, Error Description User-defined functions are not yet enabled.. Error Severity  Level=16

Error Type =556, Error Description INSERT EXEC failed because the stored procedure altered the schema of the target table.. Error Severity  Level=16

Error Type =557, Error Description Only functions and extended stored procedures can be executed from within a function.. Error Severity  Level=16

Error Type =558, Error Description Remote function calls are not allowed within a function.. Error Severity  Level=16

Error Type =561, Error Description Failed to access file '%.*ls'. Error Severity  Level=16

Error Type =562, Error Description Failed to access file '%.*ls'. Files can be accessed only through shares. Error Severity  Level=16

Error Type =563, Error Description The transaction for the INSERT EXEC statement has been rolled back. The INSERT EXEC operation will be terminated.. Error Severity  Level=14

Error Type =564, Error Description Attempted to create a record with a fixed length of '%d'. Maximum allowable fixed length is '%d'.. Error Severity  Level=16

Error Type =566, Error Description Error writing audit trace. SQL Server is shutting down.. Error Severity  Level=21

Error Type =565, Error Description The server encountered a stack overflow during compile time.. Error Severity  Level=18

Error Type =567, Error Description File '%.*ls' either does not exist or is not a recognizable trace file. Or there was an error opening the file.. Error Severity  Level=16

Error Type =568, Error Description Server encountered an error '%.*ls'.. Error Severity  Level=16

Error Type =569, Error Description The handle that was passed to %ls was invalid.. Error Severity  Level=16

Error Type =570, Error Description INSTEAD OF triggers do not support direct recursion. The trigger execution failed.. Error Severity  Level=15

Error Type =571, Error Description The specified attribute value for %ls is invalid.. Error Severity  Level=16

Error Type =572, Error Description Invalid regular expression "%.*ls" near the offset %d.. Error Severity  Level=16

Error Type =573, Error Description Evaluation of the regular expression is too complex: '%.*ls'.. Error Severity  Level=16

Error Type =574, Error Description %ls statement cannot be used inside a user transaction.. Error Severity  Level=16

Error Type =575, Error Description A LOGON trigger returned a resultset. Modify the LOGON trigger to not return resultsets.. Error Severity  Level=16

Error Type =576, Error Description Cannot create a row that has sparse data of size %d which is greater than the allowable maximum sparse data size of %d.. Error Severity  Level=16

Error Type =577, Error Description The value provided for the timeout is not valid. Timeout must be a valid integer between 0 and 2147483647.. Error Severity  Level=16

Error Type =578, Error Description Insert Exec not allowed in WAITFOR queries.. Error Severity  Level=16

Error Type =579, Error Description Can not execute WAITFOR query with snapshot isolation level.. Error Severity  Level=16

Error Type =582, Error Description Offset is greater than the length of the column to be updated in write.. Error Severity  Level=16

Error Type =583, Error Description Negative offset or length in write.. Error Severity  Level=16

Error Type =584, Error Description Select Into not allowed in WAITFOR queries.. Error Severity  Level=16

Error Type =585, Error Description Changing database context is not allowed when populating the resource database.. Error Severity  Level=16

Error Type =587, Error Description An invalid delayed CLR type fetch token is provided.. Error Severity  Level=16

Error Type =588, Error Description Multiple tasks within the session are using the same delayed CLR type fetch token at the same time.. Error Severity  Level=16

Error Type =589, Error Description This statement has attempted to access data whose access is restricted by the assembly.. Error Severity  Level=16

Error Type =590, Error Description RPC was aborted without execution.. Error Severity  Level=16

Error Type =591, Error Description %ls: The formal parameter "%ls" was defined as OUTPUT, but the actual parameter was not declared as OUTPUT.. Error Severity  Level=16

Error Type =592, Error Description Cannot find %S_MSG ID %d in database ID %d.. Error Severity  Level=16

Error Type =593, Error Description fn_trace_gettable: XML conversion of trace data for event 165 failed.. Error Severity  Level=10

Error Type =594, Error Description fn_trace_gettable: XML conversion of trace data is not supported in fiber mode.. Error Severity  Level=10

Error Type =595, Error Description Bulk Insert with another outstanding result set should be run with XACT_ABORT on.. Error Severity  Level=16

Error Type =596, Error Description Cannot continue the execution because the session is in the kill state.. Error Severity  Level=16

Error Type =597, Error Description The execution of in-proc data access is being terminated due to errors in the User Datagram Protocol (UDP).. Error Severity  Level=16

Error Type =598, Error Description An error occurred while executing CREATE/ALTER DB. Please look at the previous error for more information.. Error Severity  Level=16

Error Type =599, Error Description %.*ls: The length of the result exceeds the length limit (2GB) of the target large type.. Error Severity  Level=16

Error Type =601, Error Description Could not continue scan with NOLOCK due to data movement.. Error Severity  Level=12

Error Type =602, Error Description Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.. Error Severity  Level=21

Error Type =603, Error Description Could not find an entry for table or index with object ID %d (partition ID %I64d) in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHE. Error Severity  Level=21

Error Type =604, Error Description Could not find row in sysobjects for object ID %ld in database '%.*ls'. Run DBCC CHECKTABLE on sysobjects.. Error Severity  Level=21

Error Type =605, Error Description Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.. Error Severity  Level=21

Error Type =606, Error Description Metadata inconsistency. Filegroup id %ld specified for table '%.*ls' does not exist. Run DBCC CHECKDB or CHECKCATALOG.. Error Severity  Level=21

Error Type =607, Error Description Insufficient room was allocated for search arguments in the session descriptor for object '%.*ls'. Only %d search arguments were anticipated.. Error Severity  Level=21

Error Type =608, Error Description No catalog entry found for partition ID %I64d in database %d. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.. Error Severity  Level=16

Error Type =609, Error Description BTree is not empty when waking up on RowsetBulk.. Error Severity  Level=16

Error Type =610, Error Description Invalid header value from a page. Run DBCC CHECKDB to check for a data corruption.. Error Severity  Level=16

Error Type =611, Error Description Cannot insert or update a row because total variable column size, including overhead, is %d bytes more than the limit.. Error Severity  Level=16

Error Type =613, Error Description Could not find an entry for worktable rowset with partition ID %I64d in database %d.. Error Severity  Level=21

Error Type =615, Error Description Could not find database table ID %d, name '%.*ls'.. Error Severity  Level=21

Error Type =617, Error Description Descriptor for object ID %ld in database ID %d not found in the hash table during attempt to unhash it.. Error Severity  Level=20

Error Type =618, Error Description A varno of %d was passed to the opentable system function. The largest valid value is %d.. Error Severity  Level=21

Error Type =622, Error Description Filegroup '%.*ls' has no files assigned to it. Tables, indexes, and text, ntext, and image columns cannot be populated on this filegroup until a file is added.. Error Severity  Level=16

Error Type =623, Error Description Could not retrieve row from page by RID because logical page %S_PGID is not a data page. %S_RID. %S_PAGE.. Error Severity  Level=21

Error Type =624, Error Description Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. %S_RID.%S_PAGE, DBID %d.. Error Severity  Level=21

Error Type =625, Error Description Cannot retrieve row from page %S_PGID by RID because the slotid (%d) is not valid.. Error Severity  Level=21

Error Type =626, Error Description Cannot use ROLLBACK with a savepoint within a distributed transaction.. Error Severity  Level=16

Error Type =627, Error Description Cannot use SAVE TRANSACTION within a distributed transaction.. Error Severity  Level=16

Error Type =628, Error Description Cannot issue SAVE TRANSACTION when there is no active transaction.. Error Severity  Level=13

Error Type =635, Error Description Process %d tried to remove DES resource lock %S_DES, which it does not hold.. Error Severity  Level=20

Error Type =637, Error Description Index shrink program returned invalid status of 0.. Error Severity  Level=20

Error Type =639, Error Description Could not fetch logical page %S_PGID, database ID %d. The page is not currently allocated.. Error Severity  Level=21

Error Type =644, Error Description Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.. Error Severity  Level=21

Error Type =649, Error Description Could not find the clustered index entry for page %S_PGID, object ID %ld, status 0x%x. Index page %S_PGID, in database '%.*ls', was searched for this entry.. Error Severity  Level=21

Error Type =650, Error Description You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.. Error Severity  Level=16

Error Type =651, Error Description Cannot use %hs granularity hint on table '%.*ls' because locking at the specified granularity is inhibited.. Error Severity  Level=16

Error Type =652, Error Description Index ID %d for table '%.*ls' resides on a read-only filegroup which cannot be modified.. Error Severity  Level=16

Error Type =653, Error Description Two buffers are conflicting for the same keep slot in table '%.*ls'.. Error Severity  Level=20

Error Type =654, Error Description No slots are free to keep buffers for table '%.*ls'.. Error Severity  Level=20

Error Type =655, Error Description Expected to find buffer in keep slot for table '%.*ls'.. Error Severity  Level=20

Error Type =656, Error Description The partitioning function '%.*ls' creates %d partitions, which prevents removal of increased partitions support.. Error Severity  Level=10

Error Type =657, Error Description Could not disable support for increased partitions in database '%.*ls' because %S_MSG.. Error Severity  Level=16

Error Type =658, Error Description Could not enable support for increased partitions in database '%.*ls' because %S_MSG.. Error Severity  Level=16

Error Type =666, Error Description Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key.. Error Severity  Level=16

Error Type =667, Error Description Index %d for table '%.*ls' resides on offline filegroup that cannot be accessed.. Error Severity  Level=16

Error Type =669, Error Description The row object is inconsistent. Please rerun the query.. Error Severity  Level=22

Error Type =670, Error Description Large object (LOB) data for table "%.*ls" resides on an offline filegroup ("%.*ls") that cannot be accessed.. Error Severity  Level=16

Error Type =671, Error Description Large object (LOB) data for table "%.*ls" resides on a read-only filegroup ("%.*ls"), which cannot be modified.. Error Severity  Level=16

Error Type =672, Error Description Failed to queue cleanup packets for orphaned rowsets in database "%.*ls". Some disk space may be wasted. Cleanup will be attempted again on database restart.. Error Severity  Level=10

Error Type =674, Error Description Exception occurred in destructor of RowsetNewSS 0x%p. This error may indicate a problem related to releasing pre-allocated disk blocks used during bulk-insert operations. Restart the server to resolve this problem.. Error Severity  Level=10

Error Type =675, Error Description Worktable with partition ID %I64d was dropped successfully after repeated attempts.. Error Severity  Level=10

Error Type =676, Error Description Error occurred while attempting to drop worktable with partition ID %I64d.. Error Severity  Level=10

Error Type =677, Error Description Unable to drop worktable with partition ID %I64d after repeated attempts. Worktable is marked for deferred drop. This is an informational message only. No user action is required.. Error Severity  Level=10

Error Type =678, Error Description Active rowset for partition ID %I64d found at the end of the batch. This error may indicate incorrect exception handling. Use the current activity window in SQL Server Management Studio or the Transact-SQL KILL statement to terminate the server process id. Error Severity  Level=10

Error Type =679, Error Description One of the partitions of index '%.*ls' for table '%.*ls'(partition ID %I64d) resides on a filegroup ("%.*ls") that cannot be accessed because it is offline, restoring, or defunct. This may limit the query result.. Error Severity  Level=16

Error Type =680, Error Description Error [%d, %d, %d] occurred while attempting to drop allocation unit ID %I64d belonging to worktable with partition ID %I64d.. Error Severity  Level=10

Error Type =681, Error Description Attempting to set a non-NULL-able column's value to NULL.. Error Severity  Level=16

Error Type =682, Error Description Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.. Error Severity  Level=16

Error Type =683, Error Description An internal error occurred while trying to convert between variable-length and fixed-length decimal formats. Run DBCC CHECKDB to check for any database corruption.. Error Severity  Level=22

Error Type =684, Error Description An internal error occurred while attempting to convert between compressed and uncompressed storage formats. Run DBCC CHECKDB to check for any corruption.. Error Severity  Level=22

Error Type =685, Error Description An internal error occurred while attempting to retrieve a backpointer for a heap forwarded record.. Error Severity  Level=22

Error Type =, Error Description Syntax error converting datetime from character string.. Error Severity  Level=16

Error Type =701, Error Description There is insufficient system memory to run this query.. Error Severity  Level=19

Error Type =708, Error Description Warning: Due to low virtual memory, special reserved memory used %d times since startup. Increase virtual memory on server.. Error Severity  Level=10

Error Type =801, Error Description A buffer was encountered with an unexpected status of 0x%x.. Error Severity  Level=20

Error Type =802, Error Description No more buffers can be stolen.. Error Severity  Level=17

Error Type =803, Error Description simulated failure (DEBUG only). Error Severity  Level=10

Error Type =804, Error Description Could not find buffer 0x%lx holding logical page %S_PGID in the SDES 0x%lx kept buffer pool for object '%.*ls'.. Error Severity  Level=20

Error Type =805, Error Description restore pending. Error Severity  Level=10

Error Type =806, Error Description audit failure (a page read from disk failed to pass basic integrity checks). Error Severity  Level=10

Error Type =807, Error Description (no disk or the wrong disk is in the drive). Error Severity  Level=10

Error Type =808, Error Description insufficient bytes transferred. Error Severity  Level=10

Error Type =809, Error Description Buffer 0x%lx, allocation page %S_PGID, in database '%.*ls' is not in allocation buffer pool in PSS (process status structure). Contact Technical Support.. Error Severity  Level=20

Error Type =813, Error Description Logical page %S_PGID in database ID %d is already hashed.. Error Severity  Level=20

Error Type =816, Error Description Process ID %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES. Contact Technical Support.. Error Severity  Level=20

Error Type =818, Error Description There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES. Contact Technical Support.. Error Severity  Level=19

Error Type =821, Error Description Could not unhash buffer at 0x%lx with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE.. Error Severity  Level=20

Error Type =822, Error Description Could not start I/O for request %S_BLKIOPTR.. Error Severity  Level=21

Error Type =823, Error Description I/O error %ls detected during %S_MSG at offset %#016I64x in file '%ls'.. Error Severity  Level=24

Error Type =824, Error Description SQL Server detected a logical consistency-based I/O error: %ls. It occurred during a %S_MSG of page %S_PGID in database ID %d at offset %#016I64x in file '%ls'. Additional messages in the SQL Server error log or system event log may provide more detail.. Error Severity  Level=24

Error Type =825, Error Description A read of the file '%ls' at offset %#016I64x succeeded after failing %d time(s) with error: %ls. Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be co. Error Severity  Level=10

Error Type =826, Error Description incorrect pageid (expected %d:%d; actual %d:%d). Error Severity  Level=10

Error Type =829, Error Description Database ID %d, Page %S_PGID is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.. Error Severity  Level=21

Error Type =830, Error Description stale page (a page read returned a log sequence number (LSN) (%u:%u:%u) that is older than the last one that was written (%u:%u:%u)). Error Severity  Level=10

Error Type =831, Error Description Unable to deallocate a kept page.. Error Severity  Level=20

Error Type =832, Error Description A page that should have been constant has changed (expected checksum: %08x, actual checksum: %08x, database %d, file '%ls', page %S_PGID). This usually indicates a memory failure or other hardware or OS corruption.. Error Severity  Level=24

Error Type =833, Error Description SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in database [%ls] (%d). The OS file handle is 0x%p. The offset of the latest long I/O is: %#016I64x. Error Severity  Level=10

Error Type =834, Error Description The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).. Error Severity  Level=21

Error Type =840, Error Description Device '%.*ls' (physical name '%.*ls', virtual device number %d) is not available. Contact the system administrator for assistance.. Error Severity  Level=17

Error Type =844, Error Description Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.. Error Severity  Level=10

Error Type =845, Error Description Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.. Error Severity  Level=17

Error Type =846, Error Description A time-out occurred while waiting for buffer latch -- type %d, bp %p, page %d:%d, stat %#x, database id: %d, allocation unit Id: %I64d%ls, task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Not continuing to wait.. Error Severity  Level=10

Error Type =847, Error Description Timeout occurred while waiting for latch: class '%ls', id %p, type %d, Task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Continuing to wait.. Error Severity  Level=10

Error Type =848, Error Description Using large pages for buffer pool.. Error Severity  Level=10

Error Type =849, Error Description Using locked pages for buffer pool.. Error Severity  Level=10

Error Type =850, Error Description %I64u MB of large page memory allocated.. Error Severity  Level=10

Error Type =851, Error Description the page is in an OFFLINE file which cannot be read. Error Severity  Level=10

Error Type =901, Error Description Could not find descriptor for database ID %d, object ID %ld in hash table after hashing it.. Error Severity  Level=21

Error Type =902, Error Description To change the %ls, the database must be in state in which a checkpoint can be executed.. Error Severity  Level=16

Error Type =903, Error Description Could not find row in sysindexes for clustered index on system catalog %ld in database ID %d. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.. Error Severity  Level=22

Error Type =904, Error Description Database %ld cannot be autostarted during server shutdown or startup.. Error Severity  Level=16

Error Type =905, Error Description Database '%.*ls' cannot be started in this edition of SQL Server because it contains a partition function '%.*ls'. Only Enterprise edition of SQL Server supports partitioning.. Error Severity  Level=21

Error Type =906, Error Description Could not locate row in sysobjects for system catalog '%.*ls' in database '%.*ls'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.. Error Severity  Level=22

Error Type =907, Error Description The database "%ls" has inconsistent database or file metadata.. Error Severity  Level=16

Error Type =908, Error Description Filegroup %ls in database %ls is unavailable because it is %ls. Restore or alter the filegroup to be available.. Error Severity  Level=10

Error Type =909, Error Description Database '%.*ls' cannot be started in this edition of SQL Server because part or all of object '%.*ls' is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterpris. Error Severity  Level=21

Error Type =910, Error Description Database '%.*ls' is upgrading script '%.*ls' from level %d to level %d.. Error Severity  Level=10

Error Type =911, Error Description Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.. Error Severity  Level=16

Error Type =912, Error Description Script level upgrade for database '%.*ls' failed because upgrade step '%.*ls' encountered error %d, state %d, severity %d. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error. Error Severity  Level=21

Error Type =913, Error Description Could not find database ID %d. Database may not be activated yet or may be in transition.. Error Severity  Level=22

Error Type =914, Error Description Script level upgrade for database '%.*ls' failed because upgrade step '%.*ls' was aborted before completion. If the abort happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous. Error Severity  Level=21

Error Type =915, Error Description Unable to obtain the current script level for database '%.*ls'. If the error happened during startup of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the approp. Error Severity  Level=21

Error Type =916, Error Description Server user '%.*ls' is not a valid user in database '%.*ls'.. Error Severity  Level=14

Error Type =917, Error Description An upgrade script batch failed to execute for database '%.*ls' due to compilation error. Check the previous error message for the line which caused compilation to fail.. Error Severity  Level=21

Error Type =918, Error Description Failed to load the engine script metadata from script DLL '%.*ls'. The error code reported by Windows was %d. This is a serious error condition, which usually indicates a corrupt or incomplete installation. Repairing the SQL Server instance may help resol. Error Severity  Level=21

Error Type =919, Error Description User '%.*ls' is changing database script level entry %d to a value of %d.. Error Severity  Level=10

Error Type =920, Error Description Only members of the sysadmin role can modify the database script level.. Error Severity  Level=20

Error Type =921, Error Description Database '%.*ls' has not been recovered yet. Wait and try again.. Error Severity  Level=14

Error Type =922, Error Description Database '%.*ls' is being recovered. Waiting until recovery is finished.. Error Severity  Level=14

Error Type =923, Error Description Database '%.*ls' is in restricted mode. Only the database owner and members of the dbcreator and sysadmin roles can access it.. Error Severity  Level=14

Error Type =924, Error Description Database '%.*ls' is already open and can only have one user at a time.. Error Severity  Level=14

Error Type =925, Error Description Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.. Error Severity  Level=19

Error Type =926, Error Description Database '%.*ls' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.. Error Severity  Level=14

Error Type =927, Error Description Database '%.*ls' cannot be opened. It is in the middle of a restore.. Error Severity  Level=14

Error Type =928, Error Description During upgrade, database raised exception %d, severity %d, state %d, address %p. Use the exception number to determine the cause.. Error Severity  Level=20

Error Type =929, Error Description Attempting to close a database that is not already open. Contact Technical Support.. Error Severity  Level=20

Error Type =930, Error Description Attempting to reference recovery unit %d in database '%ls' which does not exist. Contact Technical Support.. Error Severity  Level=21

Error Type =931, Error Description Attempting to reference database fragment %d in database '%ls' which does not exist. Contact Technical Support.. Error Severity  Level=21

Error Type =932, Error Description SQL Server cannot load database '%.*ls' because change tracking is enabled. The currently installed edition of SQL Server does not support change tracking. Either disable change tracking in the database by using a supported edition of SQL Server, or upgra. Error Severity  Level=21

Error Type =933, Error Description Database '%.*ls' cannot be started because some of the database functionality is not available in the current edition of SQL Server.. Error Severity  Level=21

Error Type =934, Error Description SQL Server cannot load database '%.*ls' because Change Data Capture is enabled. The currently installed edition of SQL Server does not support Change Data Capture. Either disable Change Data Capture in the database by using a supported edition of SQL Serv. Error Severity  Level=21

Error Type =935, Error Description The script level for '%.*ls' in database '%.*ls' cannot be downgraded from %d to %d, which is supported by this server. This usually implies that a future database was attached and the downgrade path is not supported by the current installation. Install. Error Severity  Level=21

Error Type =941, Error Description Cannot open database '%.*ls'. It has not been upgraded to the latest format.. Error Severity  Level=14

Error Type =942, Error Description Database '%.*ls' cannot be opened because it is offline.. Error Severity  Level=14

Error Type =943, Error Description Database '%.*ls' cannot be opened because its version (%d) is later than the current server version (%d).. Error Severity  Level=14

Error Type =944, Error Description Converting database '%.*ls' from version %d to the current version %d.. Error Severity  Level=10

Error Type =945, Error Description Database '%.*ls' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.. Error Severity  Level=16

Error Type =946, Error Description Cannot open database '%.*ls' version %d. Upgrade the database to the latest version.. Error Severity  Level=14

Error Type =947, Error Description Error while closing database '%.*ls' cleanly.. Error Severity  Level=16

Error Type =948, Error Description Database '%.*ls' cannot be upgraded. Database is version %d and this server supports version %d.. Error Severity  Level=14

Error Type =949, Error Description tempdb is skipped. You cannot run a query that requires tempdb. Error Severity  Level=16

Error Type =950, Error Description Database '%.*ls' cannot be upgraded - database has a version (%d) earlier than SQL Server 7.0(%d).. Error Severity  Level=14

Error Type =951, Error Description Database '%.*ls' running the upgrade step from version %d to version %d.. Error Severity  Level=10

Error Type =952, Error Description Database '%.*ls' is in transition. Try the statement later.. Error Severity  Level=16

Error Type =953, Error Description Warning: Index '%ls' on '%ls' in database '%ls' may be corrupt because of expression evaluation changes in this release. Drop and re-create the index.. Error Severity  Level=16

Error Type =954, Error Description The database "%.*ls" cannot be opened. It is acting as a mirror database.. Error Severity  Level=14

Error Type =955, Error Description Database %.*ls is enabled for Database Mirroring, but the database lacks quorum: the database cannot be opened. Check the partner and witness connections if configured.. Error Severity  Level=14

Error Type =956, Error Description Database %.*ls is enabled for Database Mirroring, but has not yet synchronized with its partner. Try the operation again later.. Error Severity  Level=14

Error Type =957, Error Description Database '%.*ls' is enabled for Database Mirroring, The name of the database may not be changed.. Error Severity  Level=17

Error Type =958, Error Description The resource database build version is %.*ls. This is an informational message only. No user action is required.. Error Severity  Level=10

Error Type =959, Error Description The resource database version is %d and this server supports version %d. Restore the correct version or reinstall SQL Server.. Error Severity  Level=20

Error Type =960, Error Description Warning: User "sys" (principal_id = %d) in database "%.*ls" has been renamed to "%.*ls". "sys" is a reserved user or schema name in this version of SQL Server.. Error Severity  Level=10

Error Type =961, Error Description Warning: Index "%.*ls" (index_id = %d) on object ID %d in database "%.*ls" was renamed to "%.*ls" because its name is a duplicate of another index on the same object.. Error Severity  Level=10

Error Type =962, Error Description Warning: Primary key or Unique constraint "%.*ls" (object_id = %d) in database "%.*ls" was renamed to "%.*ls" because its index was renamed.. Error Severity  Level=10

Error Type =963, Error Description Warning: Database "%.*ls" was marked suspect because of actions taken during upgrade. See errorlog or eventlog for more information. Use ALTER DATABASE to bring the database online. The database will come online in restricted_user state.. Error Severity  Level=10

Error Type =964, Error Description Warning: System user '%.*ls' was found missing from database '%.*ls' and has been restored. This user is required for SQL Server operation.. Error Severity  Level=10

Error Type =965, Error Description Warning: A column nullability inconsistency was detected in the metadata of index "%.*ls" (index_id = %d) on object ID %d in database "%.*ls". The index may be corrupt. Run DBCC CHECKTABLE to verify consistency.. Error Severity  Level=10

Error Type =966, Error Description Warning: Assembly "%.*ls" in database "%.*ls" has been renamed to "%.*ls" because the name of the assembly conflicts with a system assembly in this version of SQL Server.. Error Severity  Level=10

Error Type =967, Error Description Warning: The index "%.*ls" on "%.*ls"."%.*ls" is disabled because the XML data bound to it may contain negative values for xs:date and xs:dateTime which are not longer supported.. Error Severity  Level=10

Error Type =968, Error Description Warning: The XML facet on type "%.*ls" in schema collection "%.*ls" is updated from "%.*ls" to "%.*ls" because Sql Server does not support negative years inside values of type xs:date or xs:dateTime.. Error Severity  Level=10

Error Type =969, Error Description Warning: The default or fixed value on XML element or attribute "%.*ls" in schema collection "%.*ls" is updated from "%.*ls" to "%.*ls" because Sql Server does not support negative years inside values of type xs:date or xs:dateTime.. Error Severity  Level=10

Error Type =970, Error Description Warning: The XML instances in the XML column "%.*ls.%.*ls.%.*ls" may contain negative simple type values of type xs:date or xs:dateTime. It will be impossible to run XQuery or build a primary XML index on these XML instances.. Error Severity  Level=10

Error Type =971, Error Description The resource database has been detected in two different locations. Attaching the resource database in the same directory as sqlservr.exe at '%.*ls' instead of the currently attached resource database at '%.*ls'.. Error Severity  Level=10

Error Type =972, Error Description Could not use database '%d' during procedure execution.. Error Severity  Level=17

Error Type =973, Error Description Database %ls was started . However, FILESTREAM is not compatible with the READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION options. Either remove the FILESTREAM files and the FILESTREAM filegroups, or set READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_. Error Severity  Level=10

SQL Error Type List with description from error 1- 500

SQL Error Type List with description from 1 to 500 with Severity Level

Error Type =1, Error Description Version date of last upgrade: 10/11/90.. Error Severity Level=10

Error Type =21, Error Description Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.. Error Severity Level=10

Error Type =53, Error Description An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server ) (.Net SqlClient Data Provider).. Error Severity Level=10

Error Type =101, Error Description Query not allowed in Waitfor.. Error Severity Level=15

Error Type =102, Error Description Incorrect syntax near '%.*ls'.. Error Severity Level=15

Error Type =103, Error Description The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.. Error Severity Level=15

Error Type =104, Error Description ORDER BY items must appear in the select list if the statement contains a UNION operator.. Error Severity Level=15

Error Type =105, Error Description Unclosed quotation mark before the character string '%.*ls'.. Error Severity Level=15

Error Type =106, Error Description Too many table names in the query. The maximum allowable is %d.. Error Severity Level=16

Error Type =107, Error Description The column prefix '%.*ls' does not match with a table name or alias name used in the query.. Error Severity Level=15

Error Type =108, Error Description The ORDER BY position number is out of range of the number of items in the select list.. Error Severity Level=15

Error Type =109, Error Description There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.. Error Severity Level=15

Error Type =110, Error Description There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.. Error Severity Level=15

Error Type =111, Error Description CREATE FUNCTION' must be the first statement in a query batch.. Error Severity Level=15

Error Type =112, Error Description Variables are not allowed in the %ls statement.. Error Severity Level=15

Error Type =113, Error Description Missing end comment mark '*/'.. Error Severity Level=15

Error Type =114, Error Description Browse mode is invalid for a statement that assigns values to a variable.. Error Severity Level=15

Error Type =115, Error Description The FOR UPDATE clause is invalid for statements containing set operators.. Error Severity Level=15

Error Type =116, Error Description Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.. Error Severity Level=15

Error Type =117, Error Description The object name "Object Name" contains more than the maximum number of prefixes. The maximum is 2.. Error Severity Level=15

Error Type =118, Error Description Only members of the sysadmin role can specify the %ls option for the %ls statement.. Error Severity Level=15

Error Type =119, Error Description Must pass parameter number %d and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.. Error Severity Level=15

Error Type =120, Error Description The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.. Error Severity Level=15

Error Type =121, Error Description The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.. Error Severity Level=15

Error Type =122, Error Description The %ls option is allowed only with %ls syntax.. Error Severity Level=15

Error Type =123, Error Description Batch/procedure exceeds maximum length of %d characters.. Error Severity Level=15

Error Type =124, Error Description CREATE PROCEDURE contains no statements.. Error Severity Level=15

Error Type =125, Error Description Case expressions may only be nested to level %d.. Error Severity Level=15

Error Type =126, Error Description Invalid pseudocolumn "%.*ls".. Error Severity Level=15

Error Type =127, Error Description A TOP N value may not be negative.. Error Severity Level=15

Error Type =128, Error Description The name '<Column Name>' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.. Error Severity Level=15

Error Type =129, Error Description Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.. Error Severity Level=15

Error Type =130, Error Description Cannot perform an aggregate function on an expression containing an aggregate or a subquery.. Error Severity Level=16

Error Type =131, Error Description The size (<Data Type Size>) given to the type 'varchar / char / nvarchar / nchar / binary / varbinary' exceeds the maximum allowed for any data type (8000).

The size (<Data Type Size>) given to the column '<Column Name>' exceeds the maximum allowed for any data type (8000).. Error Severity Level=15

Error Type =132, Error Description The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.. Error Severity Level=15

Error Type =133, Error Description A GOTO statement references the label '<Label Name>' but the label has not been declared.. Error Severity Level=15

Error Type =134, Error Description The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.. Error Severity Level=15

Error Type =135, Error Description Cannot use a BREAK statement outside the scope of a WHILE statement.. Error Severity Level=15

Error Type =136, Error Description Cannot use a CONTINUE statement outside the scope of a WHILE statement.. Error Severity Level=15

Error Type =137, Error Description Must declare the scalar variable '<Variable Name>'.. Error Severity Level=15

Error Type =138, Error Description Correlation clause in a subquery not permitted.. Error Severity Level=15

Error Type =139, Error Description Cannot assign a default value to a local variable.. Error Severity Level=15

Error Type =140, Error Description Can only use IF UPDATE within a CREATE TRIGGER statement.. Error Severity Level=15

Error Type =141, Error Description A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.. Error Severity Level=15

Error Type =142, Error Description Incorrect syntax for definition of the '%ls' constraint.. Error Severity Level=15

Error Type =143, Error Description A COMPUTE BY item was not found in the order by list. All expressions in the compute by list must also be present in the order by list.. Error Severity Level=15

Error Type =144, Error Description Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.. Error Severity Level=15

Error Type =145, Error Description ORDER BY items must appear in the select list if SELECT DISTINCT is specified.. Error Severity Level=15

Error Type =146, Error Description Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.. Error Severity Level=15

Error Type =147, Error Description An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.. Error Severity Level=15

Error Type =148, Error Description Incorrect time syntax in time string '<Wait Time>' used with WAITFOR.. Error Severity Level=15

Error Type =149, Error Description Time value '%.*ls' used with WAITFOR is not a valid value. Check date/time syntax.. Error Severity Level=15

Error Type =150, Error Description Both terms of an outer join must contain columns.. Error Severity Level=15

Error Type =151, Error Description %.*ls' is an invalid money value.. Error Severity Level=15

Error Type =152, Error Description The same large data placement option "%.*ls" has been specified twice.. Error Severity Level=15

Error Type =153, Error Description Invalid usage of the option %.*ls in the %ls statement.. Error Severity Level=15

Error Type =154, Error Description a COMPUTE clause is not allowed in a SELECT INTO statement.. Error Severity Level=15

Error Type =155, Error Description <DATEADD option>' is not a recognized DATEADD option.. Error Severity Level=15

Error Type =156, Error Description Incorrect syntax near the keyword '%.*ls'.. Error Severity Level=15

Error Type =157, Error Description An aggregate may not appear in the set list of an UPDATE statement.. Error Severity Level=15

Error Type =158, Error Description An aggregate may not appear in the OUTPUT clause.. Error Severity Level=15

Error Type =159, Error Description SQL Server 2005, SQL Server 2008 - Must specify the table name and index name for the DROP INDEX statement.

SQL Server 2000 - For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.. Error Severity Level=15

Error Type =160, Error Description Rule does not contain a variable.. Error Severity Level=15

Error Type =161, Error Description Rule contains more than one variable.. Error Severity Level=15

Error Type =162, Error Description Invalid expression in the TOP clause.. Error Severity Level=15

Error Type =163, Error Description The compute by list does not match the order by list.. Error Severity Level=15

Error Type =164, Error Description Each GROUP BY expression must contain at least one column that is not an outer reference.

GROUP BY expressions must refer to column names that appear in the select list.. Error Severity Level=15

Error Type =165, Error Description Privilege %ls may not be granted or revoked.. Error Severity Level=16

Error Type =166, Error Description CREATE VIEW' does not allow specifying the database name as a prefix to the object name.. Error Severity Level=15

Error Type =167, Error Description Cannot create a trigger on a temporary object.. Error Severity Level=16

Error Type =168, Error Description The %S_MSG '%.*ls' is out of the range of computer representation (%d bytes).. Error Severity Level=15

Error Type =169, Error Description A column has been specified more than once in the order by list. Columns in the order by list must be unique.. Error Severity Level=15

Error Type =170, Error Description Line %d: Incorrect syntax near '%.*ls'.. Error Severity Level=15

Error Type =171, Error Description Cannot use SELECT INTO in browse mode.. Error Severity Level=15

Error Type =172, Error Description Cannot use HOLDLOCK in browse mode.. Error Severity Level=15

Error Type =173, Error Description The definition for column <Column Name> must include a data type.. Error Severity Level=15

Error Type =174, Error Description The dateadd function requires 3 arguments.. Error Severity Level=15

Error Type =175, Error Description An aggregate may not appear in a computed column expression or check constraint.. Error Severity Level=15

Error Type =176, Error Description The FOR BROWSE clause is no longer supported in views. Set the database compatibility level to 80 or lower for this statement to be allowed.. Error Severity Level=15

Error Type =177, Error Description The IDENTITY function can only be used when the SELECT statement has an INTO clause.. Error Severity Level=15

Error Type =178, Error Description A RETURN statement with a return value cannot be used in this context.. Error Severity Level=15

Error Type =179, Error Description Cannot use the OUTPUT option when passing a constant to a stored procedure.. Error Severity Level=15

Error Type =180, Error Description There are too many parameters in this %ls statement. The maximum number is %d.. Error Severity Level=15

Error Type =181, Error Description SQL Server 2008 - Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.

SQL Server 2005 - Cannot use the OUTPUT option in a DECLARE or CREATE FUNCTION statement.

SQL Server 2000 - Cannot use the OUTPUT option in a DECLARE statement.. Error Severity Level=15

Error Type =182, Error Description Table and column names must be supplied for the READTEXT or WRITETEXT utility.. Error Severity Level=15

Error Type =183, Error Description The scale (<Scale Value>) for column '<Column Name>' must be within the range 0 to <Precision Value>.. Error Severity Level=15

Error Type =184, Error Description DEFAULT cannot be specified more than once for filegroups of the same content type.. Error Severity Level=15

Error Type =185, Error Description Data stream is invalid for WRITETEXT statement in bulk form.. Error Severity Level=15

Error Type =186, Error Description Data stream missing from WRITETEXT statement.. Error Severity Level=15

Error Type =187, Error Description The valid range for MAX_QUEUE_READERS is 0 to 32767.. Error Severity Level=16

Error Type =188, Error Description Cannot specify a log device in a CREATE DATABASE statement without also specifying at least one non-log device.. Error Severity Level=15

Error Type =189, Error Description The %ls function requires %d to %d arguments.. Error Severity Level=15

Error Type =190, Error Description An invalid date or time was specified in the statement.. Error Severity Level=15

Error Type =191, Error Description Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.. Error Severity Level=15

Error Type =192, Error Description The scale must be less than or equal to the precision.. Error Severity Level=16

Error Type =193, Error Description The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.. Error Severity Level=15

Error Type =194, Error Description A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.. Error Severity Level=15

Error Type =195, Error Description Function Name' is not a recognized function name.. Error Severity Level=15

Error Type =196, Error Description SELECT INTO must be the first query in an SQL statement containing a UNION, INTERSECT or EXCEPT operator.. Error Severity Level=15

Error Type =197, Error Description EXECUTE cannot be used as a source when inserting into a table variable.. Error Severity Level=15

Error Type =198, Error Description Browse mode is invalid for statements containing a UNION operator.. Error Severity Level=15

Error Type =199, Error Description An INSERT statement cannot contain a SELECT statement that assigns values to a variable.. Error Severity Level=15

Error Type =201, Error Description Procedure '<Procedure Name>' expects parameter '<Parameter Name>', which was not supplied.. Error Severity Level=16

Error Type =202, Error Description Invalid type '%s' for WAITFOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAITFOR DELAY supports the INT and SMALLINT data types.. Error Severity Level=16

Error Type =203, Error Description The name '%.*ls' is not a valid identifier.. Error Severity Level=16

Error Type =204, Error Description Normalization error in node %ls.. Error Severity Level=20

Error Type =205, Error Description All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists.. Error Severity Level=16

Error Type =206, Error Description Operand type clash: %ls is incompatible with %ls. Error Severity Level=16

Error Type =207, Error Description Invalid column name '%.*ls'.. Error Severity Level=16

Error Type =208, Error Description Invalid object name '%.*ls'.. Error Severity Level=16

Error Type =209, Error Description Ambiguous column name '%.*ls'.. Error Severity Level=16

Error Type =210, Error Description Syntax error converting datetime from binary/varbinary string.. Error Severity Level=16

Error Type =211, Error Description SyntaxPossible schema corruption. Run DBCC CHECKCATALOG.. Error Severity Level=12

Error Type =212, Error Description Expression result length exceeds the maximum. %d max, %d found.. Error Severity Level=16

Error Type =213, Error Description Insert Error: Column name or number of supplied values does not match table definition.. Error Severity Level=16

Error Type =214, Error Description Procedure expects parameter '%ls' of type '%ls'.. Error Severity Level=16

Error Type =215, Error Description Parameters supplied for object '%.*ls' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.. Error Severity Level=16

Error Type =216, Error Description Parameters were not supplied for the function '%.*ls'.. Error Severity Level=16

Error Type =217, Error Description Maximum stored procedure, function, trigger, or view nesting level exceeded (limit %d).. Error Severity Level=16

Error Type =218, Error Description Could not find the type '%.*ls'. Either it does not exist or you do not have the necessary permission.. Error Severity Level=16

Error Type =219, Error Description The type '%.*ls' already exists, or you do not have permission to create it.. Error Severity Level=16

Error Type =220, Error Description Arithmetic overflow error for data type %ls, value = %ld.. Error Severity Level=16

Error Type =221, Error Description FIPS Warning: Implicit conversion from %ls to %ls.. Error Severity Level=10

Error Type =222, Error Description The base type "%.*ls" is not a valid base type for the alias data type.. Error Severity Level=16

Error Type =223, Error Description Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default.. Error Severity Level=11

Error Type =224, Error Description Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.. Error Severity Level=11

Error Type =225, Error Description The parameters supplied for the %ls "%.*ls" are not valid.. Error Severity Level=16

Error Type =226, Error Description %ls statement not allowed within multi-statement transaction.. Error Severity Level=16

Error Type =227, Error Description %.*ls is not a valid function, property, or field.. Error Severity Level=15

Error Type =228, Error Description Method '%.*ls' of type '%.*ls' in assembly '%.*ls' does not return any value.. Error Severity Level=15

Error Type =229, Error Description %ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.. Error Severity Level=14

Error Type =230, Error Description %ls permission denied on column '%.*ls' of object '%.*ls', database '%.*ls', owner '%.*ls'.. Error Severity Level=14

Error Type =231, Error Description No such default. ID = %ld, database ID = %d.. Error Severity Level=11

Error Type =232, Error Description Arithmetic overflow error for type %ls, value = %f.. Error Severity Level=16

Error Type =233, Error Description The column '%.*ls' in table '%.*ls' cannot be null.. Error Severity Level=16

Error Type =234, Error Description There is insufficient result space to convert a money value to varchar / nvarchar / char / nchar.. Error Severity Level=16

Error Type =235, Error Description Cannot convert a char value to money. The char value has incorrect syntax.. Error Severity Level=16

Error Type =236, Error Description The conversion from char data type to money resulted in a money overflow error.. Error Severity Level=16

Error Type =237, Error Description There is insufficient result space to convert a money value to int / smallint / tinyint.. Error Severity Level=16

Error Type =238, Error Description There is insufficient result space to convert the %ls value (= %d) to the money data type.. Error Severity Level=16

Error Type =239, Error Description Duplicate common table expression name '%.*ls' was specified.. Error Severity Level=16

Error Type =240, Error Description Types don't match between the anchor and the recursive part in column "<Column Name>" of recursive query "<Recursive CTE>".. Error Severity Level=16

Error Type =241, Error Description Syntax error converting datetime from character string.. Error Severity Level=16

Error Type =242, Error Description The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.. Error Severity Level=16

Error Type =243, Error Description Type <Data Type> is not a defined system type.. Error Severity Level=16

Error Type =244, Error Description The conversion of the %ls value '%.*ls' overflowed an %hs column. Use a larger integer column.. Error Severity Level=16

Error Type =245, Error Description Syntax error converting the varchar value to a column of data type int.. Error Severity Level=16

Error Type =246, Error Description No anchor member was specified for recursive query "%.*ls".. Error Severity Level=16

Error Type =247, Error Description An anchor member was found in the recursive part of recursive query "%.*ls".. Error Severity Level=16

Error Type =248, Error Description The conversion of the %ls value '%.*ls' overflowed an int column. Maximum integer value exceeded.. Error Severity Level=16

Error Type =249, Error Description The type "%ls" is not comparable. It cannot be used in the %ls clause.. Error Severity Level=16

Error Type =251, Error Description Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.. Error Severity Level=16

Error Type =252, Error Description Recursive common table expression '<Common Table Expression Name>' does not contain a top-level UNION ALL operator.. Error Severity Level=16

Error Type =253, Error Description Recursive member of a common table expression '<Common Table Expression Name>' has multiple recursive references.. Error Severity Level=16

Error Type =254, Error Description Prefixed columns are not allowed in the column list of a PIVOT operator.. Error Severity Level=16

Error Type =255, Error Description Pseudocolumns are not allowed in the column list of a PIVOT operator.. Error Severity Level=16

Error Type =256, Error Description The data type int is invalid for the substring function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.. Error Severity Level=16

Error Type =257, Error Description Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.. Error Severity Level=16

Error Type =258, Error Description Cannot call methods on %ls.. Error Severity Level=16

Error Type =259, Error Description Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.. Error Severity Level=16

Error Type =260, Error Description Disallowed implicit conversion from data type %ls to data type %ls, table '%.*ls', column '%.*ls'. Use the CONVERT function to run this query.. Error Severity Level=16

Error Type =261, Error Description %.*ls' is not a recognized function.. Error Severity Level=16

Error Type =262, Error Description %ls permission denied in database '%.*ls'.. Error Severity Level=16

Error Type =263, Error Description Must specify table to select from.. Error Severity Level=16

Error Type =264, Error Description Column name '%.*ls' appears more than once in the result column list.. Error Severity Level=16

Error Type =265, Error Description The column name "%.*ls" specified in the %ls operator conflicts with the existing column name in the %ls argument.. Error Severity Level=16

Error Type =266, Error Description Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld.. Error Severity Level=16

Error Type =267, Error Description Object '%.*ls' cannot be found.. Error Severity Level=16

Error Type =268, Error Description Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.. Error Severity Level=16

Error Type =270, Error Description Object '%.*ls' cannot be modified.. Error Severity Level=16

Error Type =271, Error Description SQL Server 2005, SQL Server 2008, SQL Server 2012 - The column '<Column Name>' cannot be modified because it is either a computed column or is the result of a UNION operator.

SQL Server 2000 - Column '<Column Name>' cannot be modified because it is a computed column.. Error Severity Level=16

Error Type =272, Error Description Cannot update a timestamp column.. Error Severity Level=16

Error Type =273, Error Description Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column.. Error Severity Level=16

Error Type =275, Error Description Prefixes are not allowed in value or pivot columns of an UNPIVOT operator.. Error Severity Level=16

Error Type =276, Error Description Pseudocolumns are not allowed as value or pivot columns of an UNPIVOT operator.. Error Severity Level=16

Error Type =277, Error Description The column "%.*ls" is specified multiple times in the column list of the UNPIVOT operator.. Error Severity Level=16

Error Type =278, Error Description The text, ntext, and image data types cannot be used in a GROUP BY clause.. Error Severity Level=16

Error Type =279, Error Description The text, ntext, and image data types are invalid in this subquery or aggregate expression.. Error Severity Level=16

Error Type =280, Error Description Only text, ntext, and image columns are valid with the TEXTPTR function.. Error Severity Level=16

Error Type =281, Error Description <Style number> is not a valid style number when converting from %ls to a character string.. Error Severity Level=16

Error Type =282, Error Description The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.. Error Severity Level=10

Error Type =283, Error Description READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger.. Error Severity Level=16

Error Type =284, Error Description Rules cannot be bound to text, ntext, or image data types.. Error Severity Level=16

Error Type =285, Error Description The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions.. Error Severity Level=16

Error Type =286, Error Description The logical tables INSERTED and DELETED cannot be updated.. Error Severity Level=16

Error Type =287, Error Description The %ls statement is not allowed within a trigger.. Error Severity Level=16

Error Type =288, Error Description The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.. Error Severity Level=16

Error Type =290, Error Description Invalid EXECUTE statement using object "%ls", method "%ls".. Error Severity Level=16

Error Type =291, Error Description CAST or CONVERT: invalid attributes specified for type '%.*ls'. Error Severity Level=16

Error Type =292, Error Description There is insufficient result space to convert a smallmoney value to varchar/nvarchar.. Error Severity Level=16

Error Type =293, Error Description Cannot convert char value to smallmoney. The char value has incorrect syntax.. Error Severity Level=16

Error Type =294, Error Description The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.. Error Severity Level=16

Error Type =295, Error Description Syntax error converting character string to smalldatetime data type.. Error Severity Level=16

Error Type =296, Error Description The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.. Error Severity Level=16

Error Type =297, Error Description The user does not have permission to perform this action.. Error Severity Level=16

Error Type =298, Error Description The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.. Error Severity Level=16

Error Type =299, Error Description The DATEADD function was called with bad type %ls.. Error Severity Level=16

Error Type =300, Error Description %ls permission was denied on object '%.*ls', database '%.*ls'.. Error Severity Level=14

Error Type =301, Error Description Query contains an outer-join request that is not permitted.. Error Severity Level=16

Error Type =302, Error Description The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier' in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression.. Error Severity Level=16

Error Type =303, Error Description The table '%.*ls' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.. Error Severity Level=16

Error Type =304, Error Description %d' is out of range for index option '%.*ls'. See sp_configure option '%ls' for valid values.. Error Severity Level=16

Error Type =305, Error Description The XML data type cannot be compared or sorted, except when using the IS NULL operator.. Error Severity Level=16

Error Type =306, Error Description The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.. Error Severity Level=16

Error Type =307, Error Description Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.. Error Severity Level=16

Error Type =308, Error Description Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.. Error Severity Level=16

Error Type =309, Error Description Cannot use index "%.*ls" on table "%.*ls" in a hint. XML indexes are not allowed in hints.. Error Severity Level=16

Error Type =310, Error Description The value <MAXRECURSION value> specified for the MAXRECURSION option exceeds the allowed maximum of %d.. Error Severity Level=16

Error Type =311, Error Description Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.. Error Severity Level=16

Error Type =312, Error Description Cannot reference text, ntext, or image columns in a filter stored procedure.. Error Severity Level=16

Error Type =313, Error Description An insufficient number of arguments were supplied for the procedure or function %.*ls.. Error Severity Level=16

Error Type =314, Error Description Cannot use GROUP BY ALL with the special tables INSERTED or DELETED.. Error Severity Level=16

Error Type =315, Error Description Index "%.*ls" on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.. Error Severity Level=16

Error Type =316, Error Description The index ID %d on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.. Error Severity Level=16

Error Type =317, Error Description Table-valued function '<Function Name>' cannot have a column alias.. Error Severity Level=16

Error Type =318, Error Description The table (and its columns) returned by a table-valued method need to be aliased.. Error Severity Level=16

Error Type =319, Error Description Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.. Error Severity Level=16

Error Type =320, Error Description The compile-time variable value for '%.*ls' in the OPTIMIZE FOR clause must be a literal.. Error Severity Level=16

Error Type =321, Error Description %.*ls is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.. Error Severity Level=15

Error Type =322, Error Description The variable "%.*ls" is specified in the OPTIMIZE FOR clause, but is not used in the query.. Error Severity Level=16

Error Type =323, Error Description The 'COMPUTE' clause is not allowed in a statement containing an INTERSECT or EXCEPT operator.. Error Severity Level=16

Error Type =324, Error Description The 'ALL' version of the %.*ls operator is not supported.. Error Severity Level=15

Error Type =325, Error Description Incorrect syntax near '%.*ls'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.. Error Severity Level=15

Error Type =326, Error Description Multi-part identifier '%.*ls' is ambiguous. Both columns '%.*ls' and '%.*ls' exist.. Error Severity Level=16

Error Type =327, Error Description Function call '%.*ls' is ambiguous: both a user-defined function and a method call with this name exist.. Error Severity Level=16

Error Type =328, Error Description A cursor plan could not be generated for the given statement because the textptr() function was used on a LOB column from one of the base tables.. Error Severity Level=16

Error Type =329, Error Description Each GROUP BY expression must contain at least one column reference.. Error Severity Level=16

Error Type =330, Error Description The target '<Object Name>' of the OUTPUT INTO clause cannot be a view or common table expression.. Error Severity Level=15

Error Type =331, Error Description The target table '<Table Name>' of the OUTPUT INTO clause cannot have any enabled triggers.. Error Severity Level=15

Error Type =332, Error Description The target table '<Table Name>' of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint '<Primary Key or Foreign Key Constraint Name>'.. Error Severity Level=15

Error Type =333, Error Description The target table '<Table Name>' of the OUTPUT INTO clause cannot have any enabled check constraints or any enabled rules. Found check constraint or rule '<CHECK Constraint Name>'.. Error Severity Level=15

Error Type =334, Error Description The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.. Error Severity Level=15

Error Type =335, Error Description Function call cannot be used to match a target table in the FROM clause of a DELETE or UPDATE statement. Use function name '%.*ls' without parameters instead.. Error Severity Level=16

Error Type =336, Error Description Incorrect syntax near '%.*ls'. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.. Error Severity Level=15

Error Type =337, Error Description Warning: the floating point value '%.*ls' is too small. It will be interpreted as 0.. Error Severity Level=10

Error Type =338, Error Description READEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views, remote tables, and inserted or deleted tables inside triggers.. Error Severity Level=16

Error Type =339, Error Description DEFAULT or NULL are not allowed as explicit identity values.. Error Severity Level=16

Error Type =340, Error Description Cannot create the trigger "%.*ls" on view "%.*ls". AFTER triggers cannot be created on views.. Error Severity Level=16

Error Type =341, Error Description Replication filter procedures may not contain columns of large object, large value, XML or CLR type.. Error Severity Level=16

Error Type =342, Error Description Column "%.*ls" is not allowed in this context, and the user-defined function or aggregate "%.*ls" could not be found.. Error Severity Level=16

Error Type =343, Error Description Unknown object type '%.*ls' used in a CREATE, DROP, or ALTER statement.. Error Severity Level=16

Error Type =344, Error Description Remote function reference '%.*ls' is not allowed, and the column name '%.*ls' could not be found or is ambiguous.. Error Severity Level=16

Error Type =345, Error Description Function '%.*ls' is not allowed in the OUTPUT clause, because it performs user or system data access, or is assumed to perform this access. A function is assumed by default to perform data access if it is not schemabound.. Error Severity Level=16

Error Type =346, Error Description The parameter "<Parameter Name>" can not be declared READONLY since it is not a table-valued parameter.. Error Severity Level=15

Error Type =347, Error Description The table-valued parameter "%.*ls" cannot be declared as an OUTPUT parameter.. Error Severity Level=16

Error Type =348, Error Description The table variable "%.*ls" can not be passed to a stored procedure with the OUTPUT option.. Error Severity Level=16

Error Type =349, Error Description The procedure "%.*ls" has no parameter named "%.*ls".. Error Severity Level=16

Error Type =350, Error Description The column "%.*ls" does not have a valid data type. A column cannot be of a user-defined table type.. Error Severity Level=16

Error Type =351, Error Description Column, parameter, or variable %.*ls. : Cannot find data type %.*ls.. Error Severity Level=16

Error Type =352, Error Description The table-valued parameter "%.*ls" must be declared with the READONLY option.. Error Severity Level=15

Error Type =353, Error Description Function '%.*ls' is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. This is because the function performs user or system data access, or is assumed to perform this access. By default, a function is assumed to perform data access if it is not schema-bound.. Error Severity Level=16

Error Type =354, Error Description The target '%.*ls' of the INSERT statement cannot be a view or common table expression when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.. Error Severity Level=15

Error Type =355, Error Description The target table '<Table Name>' of the INSERT statement cannot have any enabled triggers when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.. Error Severity Level=15

Error Type =356, Error Description The target table '%.*ls' of the INSERT statement cannot be on either side of a (primary key, foreign key) relationship when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found reference constraint '%ls'.. Error Severity Level=15

Error Type =357, Error Description The target table '%.*ls' of the INSERT statement cannot have any enabled rules when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found rule '%ls'.. Error Severity Level=15

Error Type =358, Error Description The target table '%.*ls' of the MERGE statement cannot have any enabled rules. Found rule '%ls'.. Error Severity Level=15

Error Type =359, Error Description The target '%.*ls' of an OUTPUT INTO clause has an index with the ignore_dup_key option and cannot be used when an OUTPUT clause is also used.. Error Severity Level=15

Error Type =360, Error Description The target column list of an INSERT, UPDATE, or MERGE statement cannot contain both a sparse column and the column set that contains the sparse column. Rewrite the statement to include either the sparse column or the column set, but not both.. Error Severity Level=15

Error Type =361, Error Description The number of target columns that are specified in an INSERT, UPDATE, or MERGE statement exceeds the maximum of %d. This total number includes identity, timestamp, and columns that have default values. To correct this error, change the query to target a sparse column set instead of single sparse columns.. Error Severity Level=16

Error Type =362, Error Description The query processor could not produce a query plan because the name '%.*ls' in the FORCESEEK hint on table or view '<Object Name>' did not match the key column names of the index '<Index Name>'.. Error Severity Level=16

Error Type =363, Error Description The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' cannot be used with the %S_MSG specified by index '%.*ls'.. Error Severity Level=16

Error Type =364, Error Description The query processor could not produce a query plan because the FORCESEEK hint on view '<View Name>' is used without a NOEXPAND hint. Resubmit the query with the NOEXPAND hint or remove the FORCESEEK hint on the view.. Error Severity Level=16

Error Type =365, Error Description The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' specified more seek columns than the number of key columns in index '%.*ls'.. Error Severity Level=16

Error Type =366, Error Description The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' cannot be used with the column store index '%.*ls'.. Error Severity Level=16

Error Type =401, Error Description Unimplemented statement or expression %ls.. Error Severity Level=16

Error Type =402, Error Description The data types %s and %s are incompatible in the %s operator.. Error Severity Level=16

Error Type =403, Error Description Invalid operator for data type. Operator equals add, type equals text.. Error Severity Level=16

Error Type =404, Error Description The column reference "inserted.%.*ls" is not allowed because it refers to a base table that is not being modified in this statement.. Error Severity Level=16

Error Type =405, Error Description A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement.. Error Severity Level=16

Error Type =406, Error Description %ls cannot be used in the PIVOT operator because it is not invariant to NULLs.. Error Severity Level=16

Error Type =407, Error Description Internal error. The string routine in file %hs, line %d failed with HRESULT 0x%x.. Error Severity Level=16

Error Type =408, Error Description A constant expression was encountered in the ORDER BY list, position %i.. Error Severity Level=16

Error Type =409, Error Description The %ls operation cannot take a %ls data type as an argument.. Error Severity Level=16

Error Type =410, Error Description COMPUTE clause #%d 'BY' expression #%d is not in the order by list.. Error Severity Level=20

Error Type =411, Error Description COMPUTE clause #%d, aggregate expression #%d is not in the select list.. Error Severity Level=16

Error Type =412, Error Description The column "%.*ls" is not updatable because it is derived or constant.. Error Severity Level=16

Error Type =413, Error Description Correlated parameters or sub-queries are not supported by the inline function "%.*ls".. Error Severity Level=16

Error Type =414, Error Description UPDATE is not allowed because the statement updates view "%.*ls" which participates in a join and has an INSTEAD OF UPDATE trigger.. Error Severity Level=16

Error Type =415, Error Description DELETE is not allowed because the statement updates view "%.*ls" which participates in a join and has an INSTEAD OF DELETE trigger.. Error Severity Level=16

Error Type =416, Error Description The service queue "%.*ls" cannot be directly updated.. Error Severity Level=16

Error Type =417, Error Description TOP is not allowed in an UPDATE or DELETE statement against a partitioned view.. Error Severity Level=16

Error Type =418, Error Description Objects exposing CLR type columns are not allowed in distributed queries. Use a pass-through query to access the remote object '%.*ls'.. Error Severity Level=16

Error Type =420, Error Description The text, ntext, and image data types cannot be used in an ORDER BY clause.. Error Severity Level=16

Error Type =421, Error Description The text/ntext/image data type cannot be selected as DISTINCT because it is not comparable.. Error Severity Level=16

Error Type =422, Error Description Common table expression defined but not used.. Error Severity Level=16

Error Type =423, Error Description Xml data type methods are not supported in check constraints. Create a scalar user-defined function to wrap the method invocation. The error occurred at table "%.*ls".. Error Severity Level=16

Error Type =424, Error Description Xml data type methods are not supported in computed column definitions of table variables and return tables of table-valued functions. The error occurred at column "%.*ls", table "%.*ls", in the %ls statement.. Error Severity Level=16

Error Type =425, Error Description Data type %ls of receiving variable is not equal to the data type %ls of column '%.*ls'.. Error Severity Level=16

Error Type =426, Error Description The length %d of the receiving variable is less than the length %d of the column '%.*ls'.. Error Severity Level=16

Error Type =427, Error Description Could not load sysprocedures entries for constraint ID %d in database ID %d.. Error Severity Level=20

Error Type =428, Error Description Could not find row in sysconstraints for constraint ID %d in database ID %d.. Error Severity Level=20

Error Type =429, Error Description Could not find new constraint ID %d in sysconstraints, database ID %d, at compile time.. Error Severity Level=20

Error Type =430, Error Description Could not resolve table name for object ID %d, database ID %d, when compiling foreign key.. Error Severity Level=20

Error Type =431, Error Description Could not bind foreign key constraint. Too many tables involved in the query.. Error Severity Level=19

Error Type =432, Error Description Xml data type methods are not supported in check constraints anymore. Please drop the constraint or create a scalar user-defined function to wrap the method invocation. The error occurred at table "%.*ls".. Error Severity Level=16

Error Type =433, Error Description Could not find CHECK constraint for '%.*ls', although the table is flagged as having one.. Error Severity Level=20

Error Type =434, Error Description Function '%ls' is not allowed in the OUTPUT clause.. Error Severity Level=16

Error Type =435, Error Description Xml data type methods are not supported in computed column definitions. Create a scalar user-defined function to wrap the method invocation. The error occurred at column "%.*ls", table "%.*ls", in the %ls statement.. Error Severity Level=16

Error Type =436, Error Description Could not open referenced table ID %d in database ID %d.. Error Severity Level=20

Error Type =437, Error Description Could not resolve the referenced column name in table ID %d.. Error Severity Level=20

Error Type =438, Error Description Could not resolve the referencing column name in table ID %d.. Error Severity Level=20

Error Type =439, Error Description Could not find FOREIGN KEY constraints for table '%.*ls' in database ID %d although the table is flagged as having them.. Error Severity Level=20

Error Type =440, Error Description Internal query compilation error. The stack overflow could not be handled.. Error Severity Level=16

Error Type =441, Error Description Cannot use the '%ls' function on a remote data source.. Error Severity Level=16

Error Type =442, Error Description The NEST argument must be a column reference. Expressions are not allowed.. Error Severity Level=16

Error Type =443, Error Description Invalid use of 'getdate' within a function.

Invalid use of 'INSERT' within a function.

Invalid use of 'UPDATE' within a function.. Error Severity Level=16

Error Type =444, Error Description Select statements included within a function cannot return data to a client.. Error Severity Level=16

Error Type =445, Error Description COLLATE clause cannot be used on expressions containing a COLLATE clause.. Error Severity Level=16

Error Type =446, Error Description Cannot resolve collation conflict for %ls operation.. Error Severity Level=16

Error Type =447, Error Description Expression type %ls is invalid for COLLATE clause.. Error Severity Level=16

Error Type =448, Error Description Invalid collation '%.*ls'.. Error Severity Level=16

Error Type =449, Error Description Collation conflict caused by collate clauses with different collation '%.*ls' and '%.*ls'.. Error Severity Level=16

Error Type =450, Error Description Code page translations are not supported for the text data type. From: %d To: %d.. Error Severity Level=16

Error Type =451, Error Description Cannot resolve collation conflict for column %d in %ls statement.. Error Severity Level=16

Error Type =452, Error Description COLLATE clause cannot be used on user-defined data types.. Error Severity Level=16

Error Type =453, Error Description Collation '%.*ls' is supported on Unicode data types only and cannot be set at the database or server level.. Error Severity Level=16

Error Type =454, Error Description The UNNEST argument must be a nested table column.. Error Severity Level=16

Error Type =455, Error Description The last statement included within a function must be a return statement.. Error Severity Level=16

Error Type =456, Error Description Implicit conversion of %ls value to %ls cannot be performed because the resulting collation is unresolved due to collation conflict.. Error Severity Level=16

Error Type =457, Error Description Implicit conversion of %ls value to %ls cannot be performed because the collation of the value is unresolved due to a collation conflict.. Error Severity Level=16

Error Type =458, Error Description Cannot create the SELECT INTO target table "%.*ls" because the xml column "%.*ls" is typed with a schema collection "%.*ls" from database "%.*ls". Xml columns cannot refer to schemata across databases.. Error Severity Level=16

Error Type =459, Error Description Collation '%.*ls' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.. Error Severity Level=16

Error Type =460, Error Description DISTINCT operator is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'.. Error Severity Level=16

Error Type =461, Error Description TOP operator is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'.. Error Severity Level=16

Error Type =462, Error Description Outer join is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'.. Error Severity Level=16

Error Type =463, Error Description Functions with parameters are not allowed in the recursive part of a recursive common table expression '%.*ls'.. Error Severity Level=16

Error Type =464, Error Description Functions with side effects are not allowed in the recursive part of a recursive common table expression '%.*ls'.. Error Severity Level=16

Error Type =465, Error Description Recursive references are not allowed in subqueries.. Error Severity Level=16

Error Type =466, Error Description UNION operator is not allowed in the recursive part of a recursive common table expression '%.*ls'.. Error Severity Level=16

Error Type =467, Error Description GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression '<CTE Name>'.. Error Severity Level=16

Error Type =468, Error Description Cannot resolve the collation conflict between "%.*ls" and "%.*ls" in the %ls operation.. Error Severity Level=16

Error Type =469, Error Description An explicit column list must be specified for target table '%.*ls' when table hint KEEPIDENTITY is used and the table contains an identity column.. Error Severity Level=16

Error Type =470, Error Description The synonym "<Synonym Name>" referenced synonym "<Synonym Name>". Synonym chaining is not allowed.. Error Severity Level=16

Error Type =471, Error Description Only one of the three options, SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB, can be specified.. Error Severity Level=16

Error Type =472, Error Description Either a format file or one of the three options SINGLE_BLOB, SINGLE_CLOB, or SINGLE_NCLOB must be specified.. Error Severity Level=16

Error Type =473, Error Description The incorrect value "%.*ls" is supplied in the PIVOT operator.. Error Severity Level=16

Error Type =474, Error Description Unable to load the computed column definitions for table "%.*ls".. Error Severity Level=16

Error Type =475, Error Description Invalid SAMPLE clause. Only table names in the FROM clause of SELECT, UPDATE, and DELETE queries may be sampled.. Error Severity Level=16

Error Type =476, Error Description Invalid PERCENT tablesample size "<sample_number>" for table "<Table Name>". The PERCENT tablesample size must be between 0 and 100.. Error Severity Level=16

Error Type =477, Error Description Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table "<Table Name>". The value or seed must be an integer.. Error Severity Level=16

Error Type =478, Error Description The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.. Error Severity Level=16

Error Type =479, Error Description Invalid ROWS value or REPEATABLE seed "%I64d" in the TABLESAMPLE clause for table "%.*ls". The value or seed must be greater than 0.. Error Severity Level=16

Error Type =480, Error Description The TABLESAMPLE clause cannot be used with the table function "%.*ls".. Error Severity Level=16

Error Type =481, Error Description The TABLESAMPLE clause cannot be used with the linked server table "%.*ls".. Error Severity Level=16

Error Type =482, Error Description Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause.. Error Severity Level=16

Error Type =483, Error Description The OUTPUT clause cannot be used in an INSERT...EXEC statement.. Error Severity Level=16

Error Type =484, Error Description Cannot declare more than %d local variables.. Error Severity Level=16

Error Type =485, Error Description Views and inline functions cannot return xml columns that are typed with a schema collection registered in a database other than current. Column "%.*ls" is typed with the schema collection "%.*ls", which is registered in database "%.*ls".. Error Severity Level=16

Error Type =486, Error Description %.*ls does not allow specifying a schema name as a prefix to the assembly name.. Error Severity Level=16

Error Type =487, Error Description An invalid option was specified for the statement "%.*ls".. Error Severity Level=16

Error Type =488, Error Description %s columns must be comparable. The type of column "%.*ls" is "%s", which is not comparable.. Error Severity Level=16

Error Type =489, Error Description The OUTPUT clause cannot be specified because the target view "%.*ls" is a partitioned view.. Error Severity Level=16

Error Type =490, Error Description The resync functionality is temporarily disabled.. Error Severity Level=16

Error Type =491, Error Description A correlation name must be specified for the bulk rowset in the from clause.. Error Severity Level=16

Error Type =492, Error Description Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "%.*ls" is a duplicate.. Error Severity Level=16

Error Type =493, Error Description The column '%.*ls' that was returned from the nodes() method cannot be used directly. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.. Error Severity Level=16

Error Type =494, Error Description The TABLESAMPLE clause can only be used with local tables.. Error Severity Level=16

Error Type =495, Error Description The return table column "%.*ls" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.. Error Severity Level=16

Error Type =496, Error Description The parameter "%.*ls" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.. Error Severity Level=16

Error Type =497, Error Description Variables are not allowed in the TABLESAMPLE or REPEATABLE clauses.. Error Severity Level=16

Error Type =498, Error Description Invalid value in the TABLESAMPLE or the REPEATABLE clause.. Error Severity Level=16

Error Type =499, Error Description Invalid parameter for the getchecksum function.. Error Severity Level=16

Error Type =500, Error Description Trying to pass a table-valued parameter with %d column(s) where the corresponding user-defined table type requires %d column(s).. Error Severity Level=16

SQL Server Error

Error-1

When we try to insert a new row but the no of column specified and values passed is greater  then we used to get this error.

Error Msg 121
Error  Level 15,
Error State 1,
Error Line 91

"The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns."