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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *