SQL Server Errors or Failures from Error: 11622 to Error: 11712

SQLServerF1

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

Error: 11622, Severity: 16,
CREATE ASSEMBLY can only be created FROM a constant binary expression.

Error: 11623, Severity: 15,
ALTR TABLE statements can only be used to add a single constraint.

Error: 11624, Severity: 15,
ALTR ROLE statements can only be used to add a member to a role.

Error: 11625, Severity: 16,
‘%ls’ is either corrupt, not readable or not accessible.

Error: 11651, Severity: 10,
%ls statements with a ‘%.*ls’ option are not supported in a data-tier application.

Error: 11652, Severity: 10,
%ls statements are not supported at the top level in a data-tier application.

Error: 11653, Severity: 10,
Cannot execute as the user ‘%.*ls’ because it does not exist.

Error: 11700, Severity: 16,
The increment for sequence object ‘%.*ls’ cannot be zero.

Error: 11701, Severity: 16,
The absolute value of the increment for sequence object ‘%.*ls’ must be less than or equal to the difference between the minimum and maximum value of the sequence object.

Error: 11702, Severity: 16,
The sequence object ‘%.*ls’ must be of data type int, bigint, smallint, tinyint, or decimal or numeric with a scale of 0, or any user-defined data type that is based on one of the above integer data types.

Error: 11703, Severity: 16,
The start value for sequence object ‘%.*ls’ must be between the minimum and maximum value of the sequence object.

Error: 11704, Severity: 16,
The current value ‘%.*ls’ for sequence object ‘%.*ls’ must be between the minimum and maximum value of the sequence object.

Error: 11705, Severity: 16,
The minimum value for sequence object ‘%.*ls’ must be less than its maximum value.

Error: 11706, Severity: 16,
The cache size for sequence object ‘%.*ls’ must be greater than 0.

Error: 11707, Severity: 10,
The cache size for sequence object ‘%.*ls’ has been set to NO CACHE.

Error: 11708, Severity: 16,
An invalid value was specified for argument ‘%.*ls’ for the given data type.

Error: 11709, Severity: 15,
The ‘RESTART WITH’ argument cannot be used in a CREATE SEQUENCE statement.

Error: 11710, Severity: 15,
Argument ‘START WITH’ cannot be used in an ALTER SEQUENCE statement.

Error: 11711, Severity: 15,
Argument ‘AS’ cannot be used in an ALTER SEQUENCE statement.

Error: 11712, Severity: 15,
Argument ‘%.*ls’ can not be specified more than once.

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 *