SQL Server Errors or Failures from Error: 8391 to Error: 8413

SQLServerF1

 

Error: 8391, Severity: 10, The usage of 2-part names in DROP INDEX is deprecated. New-style syntax DROP INDEX ON { | }
Error: 8393, Severity: 10, The ability to not specify a column name when the datatype is timestamp will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
Error: 8394, Severity: 10, Usage of deprecated index option syntax. The deprecated relational index option syntax structure will be removed in a future version of SQL Server. Avoid using this syntax structure in new development work, and plan to modify applications that currently u

Error: 8396, Severity: 10, %ls will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it. Use %ls instead.
Error: 8397, Severity: 10, The TEXT, NTEXT, and IMAGE data types will be removed in a future version of SQL Server. Avoid using them in new development work, and plan to modify applications that currently use them. Use the varchar(max), nvarchar(max), and varbinary(max) data types
Error: 8398, Severity: 10, The use of more than two-part column names will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
Error: 8399, Severity: 10, %ls will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.

Error: 8401, Severity: 16, This message could not be delivered because the target user with ID %i in database ID %i does not have permission to receive from the queue ‘%.*ls’.
Error: 8402, Severity: 16, The data type of the ‘%S_MSG’ in the ‘%S_MSG’ statement must be %s. The %s data type is not allowed.
Error: 8403, Severity: 16, The message type ‘%.*ls’ is specified more than once. Remove the duplicate message type.
Error: 8404, Severity: 16, The service contract ‘%.*ls’ is specified more than once. Remove the duplicate service contract.
Error: 8405, Severity: 16, An error occurred in the service broker queue rollback handler, while trying to disable a queue. Database ID: %d, Queue ID: %d, Error: %i, State: %i.
Error: 8406, Severity: 16, The dialog lifetime can not be NULL. Specify a valid dialog lifetime value from %d to %d.
Error: 8407, Severity: 16, Received a message that contains invalid header fields. This may indicate a network problem or that another application is connected to the Service Broker endpoint.
Error: 8408, Severity: 16, Target service ‘%.*ls’ does not support contract ‘%.*ls’.
Error: 8409, Severity: 16, This message could not be delivered because the targeted service does not support the service contract. Targeted service: ‘%.*ls’, service contract: ‘%.*ls’.
Error: 8410, Severity: 16, The conversation timer cannot be set beyond the conversation’s lifetime.
Error: 8411, Severity: 16, The dialog lifetime value of %d is outside the allowable range of %d to %d. Specify a valid dialog lifetime value.
Error: 8412, Severity: 16, The syntax of the service name ‘%.*ls’ is invalid.
Error: 8413, Severity: 16, The syntax of the broker instance ‘%.*ls’ is invalid. The specified broker instance is too long, the maximum size is 256 bytes.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures from Error: 7122 to Error: 7214

SQLServerF1

 

Error: 7122, Severity: 16, Invalid text, ntext, or image pointer type. Must be binary(16).
Error: 7123, Severity: 16, Invalid text, ntext, or image pointer value %hs.
Error: 7124, Severity: 16, The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
Error: 7125, Severity: 16, The text, ntext, or image pointer value conflicts with the column name specified.
Error: 7133, Severity: 16, NULL textptr (text, ntext, or image pointer) passed to %ls function.
Error: 7134, Severity: 16, LOB Locator is not supported as text pointer when using UPDATETEXT/WRITETEXT to update/write a text column.

Error: 7135, Severity: 16, Deletion length %ld is not in the range of available text, ntext, or image data.
Error: 7137, Severity: 16, %s is not allowed because the column is being processed by a concurrent snapshot or is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS) or tracked by Change Data Capture.
Error: 7138, Severity: 16, The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS) or tracked by Change Data Capture.
Error: 7139, Severity: 16, Length of LOB data (%I64d) to be replicated exceeds configured maximum %ld. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit,

Error: 7140, Severity: 16, Cannot create additional orphans with the stored procedure sp_createorphan. Free up some of the orphan handles that you have created by inserting or deleting them.
Error: 7141, Severity: 16, Must create orphaned text inside a user transaction.
Error: 7143, Severity: 16, Invalid locator de-referenced.
Error: 7144, Severity: 16, A text/ntext/image column referenced by a persisted or indexed computed column cannot be updated
Error: 7151, Severity: 16, Insufficient buffer space to perform write operation.
Error: 7201, Severity: 17, Could not execute procedure on remote server ‘%.*ls’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
Error: 7202, Severity: 11, Could not find server ‘%.*ls’ in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Error: 7212, Severity: 16, Could not execute procedure ‘%.*ls’ on remote server ‘%.*ls’.
Error: 7213, Severity: 20, The attempt by the provider to pass remote stored procedure parameters to remote server ‘%.*ls’ failed. Verify that the number of parameters, the order, and the values passed are correct.
Error: 7214, Severity: 16, Remote procedure time out of %d seconds exceeded. Remote procedure ‘%.*ls’ is canceled.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures Error: 2738 to Error: 2760

SQLServerF1

 

Error: 2738, Severity: 16, A table can only have one timestamp column. Because table ‘%.*ls’ already has one, the column ‘%.*ls’ cannot be added.,
Error: 2739, Severity: 16, The text, ntext, and image data types are invalid for local variables.,
Error: 2740, Severity: 16, SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server.,
Error: 2741, Severity: 16, SET DATEFORMAT date order ‘%.*ls’ is invalid.,
Error: 2742, Severity: 16, SET DATEFIRST %d is out of range.,
Error: 2743, Severity: 16, %ls option requires %S_MSG parameter.,

Error: 2744, Severity: 16, Multiple identity columns specified for table ‘%.*ls’. Only one identity column per table is allowed.,
Error: 2745, Severity: 10, Process ID %d has raised user error %d, severity %d. SQL Server is terminating this process.,
Error: 2747, Severity: 16, Too many substitution parameters for RAISERROR. Cannot exceed %d substitution parameters.,
Error: 2748, Severity: 16, Cannot specify %ls data type (parameter %d) as a substitution parameter.,
Error: 2749, Severity: 16, Identity column ‘%.*ls’ must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and constrained to be nonnullable.,
Error: 2750, Severity: 16, Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.,

Error: 2751, Severity: 16, Column or parameter #%d: Specified column scale %d is greater than the specified precision of %d.,
Error: 2752, Severity: 16, Identity column ‘%.*ls’ contains invalid SEED.,
Error: 2753, Severity: 16, Identity column ‘%.*ls’ contains invalid INCREMENT.,
Error: 2754, Severity: 16, Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option.,
Error: 2755, Severity: 16, SET DEADLOCK_PRIORITY option is invalid. Valid options are {HIGH | NORMAL | LOW | [%d … %d] of type integer}.,
Error: 2756, Severity: 16, Invalid value %d for state. Valid range is from %d to %d.,
Error: 2759, Severity: 16, CREATE SCHEMA failed due to previous errors.,
Error: 2760, Severity: 16, The specified schema name “%.*ls” either does not exist or you do not have permission to use it.,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures Error: 290 to Error: 312

SQLServerF1

 

Error: 290, severity 16,
Invalid EXECUTE statement using object “%ls”, method “%ls”.

Error: 291, severity 16,
CAST or CONVERT: invalid attributes specified for type ‘%.*ls’

Error: 292, severity 16,
There is insufficient result space to convert a smallmoney value to %ls.

Error: 293, severity 16,
Cannot convert char value to smallmoney. The char value has incorrect syntax.

Error: 294, severity 16,
The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.

Error: 295, severity 16,
Conversion failed when converting character string to smalldatetime data type.

Error: 297, severity 16,
The user does not have permission to perform this action.

Error: 300, severity 14,
%ls permission was denied on object ‘%.*ls’, database ‘%.*ls’.

Error: 301, severity 16,
Query contains an outer-join request that is not permitted.

Error: 302, severity 16,
The newsequentialid built-in function can only be used in a DEFAULT expression for a column of type ‘uniqueidentifier’ in a CRATE TBL or ALTER TBL statement. It cannot be combined with other operators to form a complex scalar expression.

Error: 303, severity 16,
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: 304, severity 16,
‘%d’ is out of range for index option ‘%.*ls’. See sp_configure option ‘%ls’ for valid values.

Error: 305, severity 16,
The XML data type cannot be compared or sorted, except when using the IS NULL operator.

Error: 306, severity 16,
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Error: 307, severity 16,
Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error: 308, severity 16,
Index ‘%.*ls’ on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Error: 309, severity 16,
Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints.

Error: 310, severity 15,
The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d.

Error: 311, severity 16,
Cannot use text, ntext, or image columns in the ‘inserted’ and ‘deleted’ tables.

Error: 312, severity 16,
Cannot reference text, ntext, or image columns in a filter stored procedure.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures Error: 268 to Error: 289

SQLServerF1

You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 268 to Error: 289

Error: 268, severity 16,
Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.

Error: 270, severity 16,
Object ‘%.*ls’ cannot be modified.

Error: 271, severity 16,
The column “%.*ls” cannot be modified because it is either a computed column or is the result of a UNION operator.

Error: 272, severity 16,
Cannot update a timestamp column.

Error: 273, severity 16,
Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

Error: 275, severity 16,
Prefixes are not allowed in value or pivot columns of an UNPIVOT operator.

Error: 276, severity 16,
Pseudocolumns are not allowed as value or pivot columns of an UNPIVOT operator.

Error: 277, severity 16,
The column “%.*ls” is specified multiple times in the column list of the UNPIVOT operator.

Error: 278, severity 16,
The text, ntext, and image data types cannot be used in a GROUP BY clause.

Error: 279, severity 16,
The text, ntext, and image data types are invalid in this subquery or aggregate expression.

Error: 280, severity 16,
Only base table columns are allowed in the TEXTPTR function.

Error: 281, severity 16,
%d is not a valid style number when converting from %ls to a character string.

Error: 282, severity 10,
The ‘%.*ls’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

Error: 283, severity 16,
READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger.

Error: 284, severity 16,
Rules cannot be bound to text, ntext, or image data types.

Error: 285, severity 16,
The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions.

Error: 286, severity 16,
The logical tables INSERTED and DELETED cannot be updated.

Error: 287, severity 16,
The %ls statement is not allowed within a trigger.

Error: 288, severity 16,
The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.

Error: 289, severity 16,
Cannot construct data type %ls, some of the arguments have values which are not valid.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.