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



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.

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 *