SQL Server Error FAQs (All)



Add Node to A SQL Server failover Cluster failed with invalid SKU error

SQL Server Destination remote server error

Add Node to A SQL Server failover Cluster failed with invalid SKU error

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

XQuery [query()]: Attribute may not appear outside of an element

Cannot find either column “%.*ls” or the user-defined function or aggregate “%.*ls”, or the name is ambiguous.

%sThe operator “%ls” cannot be applied to “%ls” and “%ls” operands.

%sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’

XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable.

%sSyntax error near ‘%ls’, expected ‘%ls’.

%sThe name “%ls” has already been defined.

%sThere are not enough actual arguments in the call to function “%ls”.

%sThe name “%ls” does not denote a namespace.

%sResult of ‘%ls’ expression is statically ‘empty’

%sVariable expected: ‘$name’

%sInvalid source character 0x%02x

%sUnterminated string constant (started on line %u)

%sHeterogeneous sequences are not allowed in ‘%ls’, found ‘%ls’ and ‘%ls’.

%sThe XQuery syntax ‘%ls’ is not supported.

%sSyntax error near ‘%ls’

“%.*ls” is not a valid function, property, or field.

%sNo more tokens expected at the end of the XQuery expression. Found ‘%ls’.

%s’%ls’ requires a singleton (or empty sequence), found operand of type ‘%ls’

%sThe argument of ‘%ls’ must be of a single numeric primitive type or ‘http://www.w3.org/2004/07/xpath-datatypes#untypedAtomic’. Found argument of type ‘%ls’.

Cannot call methods on %ls.

Cannot use index option ignore_dup_key to alter index ‘%.*ls’ as it enforces a primary or unique constraint.

Cannot define an index on a view with ignore_dup_key index option. Remove ignore_dup_key option and verify that view definition does not allow duplicates, or do not index view.

%sThe variable ‘%ls’ was not found in the scope in which it was referenced.

%sThere is no function ‘%ls:%ls()’

%s’%ls’ or ‘%ls’ expected

%sSyntax error near ‘%ls’, expected ‘where’, ‘(stable) order by’ or ‘return’.

%s”%ls” was expected.

%sAn expression was expected

There is no user table matching the input name ‘%s’ in the current database or you do not have permission to access the table.

Index ‘%.*ls’ was not created. This index has a key length of at least %d bytes. The maximum permissible key length is %d bytes.

Cannot recreate index ‘%.*ls’. The new index definition does not match the constraint being enforced by the existing index.

Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option.

Saving Changes is Not Permitted. The changes you have made require the following tables…

Cannot create the clustered index ‘%.*ls’ on view ‘%.*ls’ because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function.

Cannot create the clustered index “%.*ls” on view “%.*ls” because the select list of the view definition does not include all columns in the GROUP BY clause. Consider adding these columns to the select list.

Cannot create the clustered index “%.*ls” on view “%.*ls” because no row can satisfy the view definition. Consider eliminating contradictions from the view definition.

DROP XML INDEX does not support any options.

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.

Database option ‘%s’ does not exist. Specify a valid database option.

There are no matching rows on which to report.

Error %d, severity %d, state %d was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.

The ‘COMPUTE’ clause is not allowed in a statement containing an INTERSECT or EXCEPT operator.

Incorrect syntax near the keyword ‘with’. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Only functions and extended stored procedures can be executed from within a function.

INSERT EXEC failed because the stored procedure altered the schema of the target table.

Cannot issue SAVE TRANSACTION when there is no active transaction.

Hint ‘%ls’ on object ‘%.*ls’ is invalid.

Conversion failed when converting from a character string to uniqueidentifier.

Insufficient result space to convert uniqueidentifier value to char.

Constraint name ‘%.*ls’ not permitted. Constraint names cannot begin with a number sign (#).

Column names in each view or function must be unique. Column name ‘%.*ls’ in view or function ‘%.*ls’ is specified more than once.

Warning! The maximum key length is %d bytes. The index ‘%.*ls’ has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.

The %S_MSG name ‘%.*ls’ contains more than the maximum number of prefixes. The maximum is %d.

Invalid parameter %d specified for %ls.

Browse mode is invalid for a statement that assigns values to a variable.

The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

An expression of non-boolean type specified in a context where a condition is expected, near ‘%.*ls’.

The formal parameter “%.*ls” was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.

Explicit conversion from data type %ls to %ls is not allowed.

User, group, or role ‘%s’ already exists in the current database.

Cannot drop a message with an ID less than 50,000.

The message number %u or specified language version does not exist.

Browse mode is invalid for statements containing a UNION, INTERSECT or EXCEPT operator.

The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d.

The variable “%.*ls” is specified in the OPTIMIZE FOR clause, but is not used in the query.

The %ls data type cannot be selected as DISTINCT because it is not comparable.

Column ‘%.*ls’ in %S_MSG ‘%.*ls’ cannot be used in an index or statistics or as a partition key because it is non-deterministic.

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.

Cannot use HOLDLOCK in browse mode.

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.

Browse mode cannot be used with INSERT, SELECT INTO, or UPDATE statements.

Derived table ‘%.*ls’ is not updatable because it contains aggregates, or a DISTINCT or GROUP BY clause, or PIVOT or UNPIVOT operator.

CREATE DATABASE permission can only be granted in the master database.

Cannot bulk load. The file “%ls” does not exist.

ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.

ALTER TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’.

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a column level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint.

Cannot use table option LARGE VALUE TYPES OUT OF ROW on a user table that does not have any of large value types varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns in it.

Vardecimal storage format is not available in system database ‘%s’.

Vardecimal storage format cannot be enabled on table ‘%.*ls’ because database ‘%.*ls’ is a system database. Vardecimal storage format is not available in system databases.

Index ‘%.*ls’ could not be created or rebuilt. The key length for this index (%d bytes) exceeds the maximum allowed length of ‘%d’ bytes when using the vardecimal storage format.

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ and source table ‘%.*ls’ have different vardecimal storage format values.

Cannot create the clustered index “%.*ls” on view “%.*ls” because the index key includes columns that are not in the GROUP BY clause. Consider eliminating columns that are not in the GROUP BY clause from the index key.

The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.

Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.

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

The logical tables INSERTED and DELETED cannot be updated.

Select statements included within a function cannot return data to a client.

The last statement included within a function must be a return statement.

A trigger returned a resultset and the server option ‘disallow results from triggers’ is true.

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.

Explicit value must be specified for identity column in table ‘%.*ls’ either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns.

FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table.

Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because key column ‘%.*ls’ is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key or changing column to be precise.

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same collation in tables ‘%.*ls’ and ‘%.*ls’.

XML parsing: line %d, character %d, unexpected end of input

XML parsing: line %d, character %d, end tag does not match start tag

Cannot create %S_MSG on view “%.*ls” because it references derived table “%.*ls” (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.

Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint.

Cannot create %S_MSG on view “%.*ls” because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead.

Cannot create %S_MSG on view ‘%.*ls’ because it contains one or more UNION, INTERSECT, or EXCEPT operators. Consider creating a separate indexed view for each query that is an input to the UNION, INTERSECT, or EXCEPT operators of the original view.

Cannot create %S_MSG on view “%.*ls” because it contains a HAVING clause. Consider removing the HAVING clause.

Cannot create %S_MSG on view “%.*ls” because it contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this view.

Cannot create %S_MSG on view “%.*ls” because it contains the TOP keyword. Consider removing TOP or not indexing the view.

Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.

Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled.

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, matches the existing plan guide ‘%.*ls’ in the database

Cannot create plan guide ‘%.*ls’ because type ‘%.*ls’ provided is not allowed.

Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,...n ] )’.

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch.

Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.

Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt or @statement_start_offset either contains a syntax error or is ineligible for use in a plan guide.

Cannot create plan guide ‘%.*ls’ because the hints specified in @hints cannot be applied to the statement specified by either @stmt or @statement_start_offset. Verify that the hints can be applied to the statement.

Cannot ‘%ls’ plan guide ‘%.*ls’ because it does not exist or you do not have permission. Verify plan guide name and database of current session, and that you have needed permission.

Cannot create plan guide ‘%.*ls’ because object ‘@module_or_batch’ is encrypted. Consider tuning query using other techniques such as indexes and statistics.

Cannot create plan guide ‘%.*ls’ because the module ‘%.*ls’ does not exist or you do not have needed permission.

Cannot create plan guide ‘%.*ls’ because value ‘%.*ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’.

Cannot %S_MSG %S_MSG ‘%.*ls’ because it is referenced by plan guide ‘%.*ls’. Use sp_control_plan_guide to drop the plan guide first. Record the plan guide definition for future use if needed.

Cannot create plan guide ‘%.*ls’ because its name is invalid. Plan guide name cannot begin with a ‘#’ character.

Cannot specify included columns for a clustered index.

COMPUTE clause #%d, aggregate expression #%d is not in the select list.

FIPS Warning: Line %d has the non-ANSI statement ‘%ls’.

FIPS Warning: Line %d has the non-ANSI clause ‘%ls’.

FIPS Warning: The length of identifier ‘%.*ls’ exceeds 18.

Backup and restore operations are not allowed on database tempdb.

Derived table ‘%.*ls’ is not updatable because a column of the derived table is derived or constant.

Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a timestamp column.

Cannot update partitioned view ‘%.*ls’ because the definition of the view column ‘%.*ls’ in table ‘%.*ls’ has a IDENTITY constraint.

Partitioned view ‘%.*ls’ is not updatable because a value was not specified for partitioning column ‘%.*ls’.

Cannot INSERT into partitioned view ‘%.*ls’ because values were not supplied for all columns.

Partitioned view ‘%.*ls’ is not updatable because it does not deliver all columns from its member tables.

Cannot INSERT into partitioned view ‘%.*ls’ because table ‘%.*ls’ has an IDENTITY constraint.

Using defaults is not allowed in views that contain a set operator.

Partitioned view ‘%.*ls’ is not updatable because table ‘%.*ls’ has a DEFAULT constraint.

The ALTER TABLE SWITCH statement failed. The table “%.*ls” has a disabled clustered index.

Computed column ‘%.*ls’ in table ‘%.*ls’ cannot be persisted because the column is non-deterministic.

The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause.

Cannot create %S_MSG on view “%.*ls” because it uses the aggregate COUNT. Use COUNT_BIG instead.

Cannot create %S_MSG on view “%.*ls” because it contains one or more subqueries. Consider changing the view to use only joins instead of subqueries. Alternatively, consider not indexing this view.

The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed (%d).

The transaction name must be specified when it is used with the mark option.

The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.

Update or insert of view or function ‘%.*ls’ failed because it contains a derived or constant field.

UNION ALL view ‘%.*ls’ is not updatable because a partitioning column was not found.

UNION ALL view ‘%.*ls’ is not updatable because a primary key was not found on table ‘%.*ls’.

UNION ALL view ‘%.*ls’ is not updatable because base table ‘%.*ls’ is used multiple times.

UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not included in the union result.

UNION ALL view ‘%.*ls’ is not updatable because column ‘%.*ls’ of base table ‘%.*ls’ is used multiple times.

UNION ALL view ‘%.*ls’ is not updatable because the primary key of table ‘%.*ls’ is not unioned with primary keys of preceding tables.

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.

Index ‘%.*ls’ on table ‘%.*ls’ (specified in the FROM clause) does not exist.

Cannot use index “%.*ls” on table “%.*ls” in a hint. XML indexes are not allowed in hints.

Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled triggers.

The target table ‘%.*ls’ of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint ‘%ls’.

The TABLESAMPLE clause can only be used with local tables.

The %S_MSG ‘%.*ls’ is out of the range for numeric representation (maximum precision 38).

Syntax error: Duplicate specification of the action “%.*s” in the trigger declaration.

An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [] are not allowed. Add a name or single space as the alias name.

The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION, INTERSECT or EXCEPT operator.

Cannot set or reset the ‘parseonly’ option within a procedure or function.

The NOLOCK and READUNCOMMITTED lock hints are not allowed for target tables of INSERT, UPDATE or DELETE statements.

‘%.*ls’ is an invalid event type.

Column ‘%.*ls.%.*ls’ is not of same collation as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’.

Cannot create the foreign key “%.*ls” with the SET NULL referential action, because one or more referencing columns are not nullable.

Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.

Foreign key references to temporary tables are not supported. Foreign key ‘%.*ls’.

Cannot create foreign key ‘%.*ls’ because it references object ‘%.*ls’ whose clustered index ‘%.*ls’ is disabled.

Cannot create the foreign key ‘%.*ls’ because the referenced column ‘%.*ls.%.*ls’ is a non-persisted computed column.

Operation failed. The index entry of length %d bytes for the index ‘%.*ls’ exceeds the maximum length of %d bytes.

Query not allowed in Waitfor.

Cannot use the OUTPUT option when passing a constant to a stored procedure.

Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ has data type %s in source table ‘%.*ls’ which is different from its type %s in target table ‘%.*ls’.

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ has data type %s in source table ‘%.*ls’ which is different from its type %s in target table ‘%.*ls’.

ALTER TABLE SWITCH statement failed. There is no identical index in source table ‘%.*ls’ for the index ‘%.*ls’ in target table ‘%.*ls’ .

‘%ls’ statement failed because the expression identifying partition number for the %S_MSG ‘%.*ls’ is not of integer type.

ALTER TABLE SWITCH statement failed. Column ‘%.*ls’ in table ‘%.*ls’ is computed column but the same column in ‘%.*ls’ is not computed.

ALTER TABLE SWITCH statement failed. Computed column ‘%.*ls’ defined as ‘%.*ls’ in table ‘%.*ls’ is different from the same column in table ‘%.*ls’ defined as ‘%.*ls’.

ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table ‘%.*ls’ allows values that are not allowed by check constraints or partition function on target table ‘%.*ls’.

ALTER TABLE SWITCH statement failed. Check constraint ‘%.*ls’ in source table ‘%.*ls’ and check constraint ‘%.*ls’ in target table ‘%.*ls’ have different ‘Not For Replication’ settings.

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has an XML index ‘%.*ls’ on it. Only source table can have XML indexes in the ALTER TABLE SWITCH statement.

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ does not have the same nullability attribute in tables ‘%.*ls’ and ‘%.*ls’.

IDENTITY_INSERT is already ON for table ‘%.*ls.%.*ls.%.*ls’. Cannot perform SET operation for table ‘%.*ls’.

The data type or table column ‘%s’ does not exist or you do not have permission.

‘%s’ is not a valid option for the @updateusage parameter. Enter either ‘true’ or ‘false’.

The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.

The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.

Cannot change the owner of the master, model, tempdb or distribution database.

Cannot bind a default to a column created with or altered to have a default value.

Cannot bind a default to a computed column or to a column of data type timestamp, varchar(max), nvarchar(max), varbinary(max), xml or sqlclr type.

Usage: sp_bindefault defaultname, objectname [, 'futureonly']

Cannot bind a default to an identity column.

Cannot bind a rule to a computed column or to a column of data type text, ntext, image, timestamp, varchar(max), nvarchar(max), varbinary(max), xml or sqlclr type.

Invalid partition number %I64d specified for %S_MSG ‘%.*ls’, partition number can range from 1 to %d.

Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

Cursor is not open.

A cursor with the name ‘%.*ls’ does not exist.

A cursor with the name ‘%.*ls’ already exists.

Invalid partition number %I64d specified for %S_MSG ‘%.*ls’, partition number can range from 1 to %d.

Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

The permissions granted to user ‘IUSR_‘ are insufficient for performing this operation. (rsAccessDenied)

Cannot bind a default to an identity column.

Cannot bind a rule to a computed column or to a column of data type text, ntext, image, timestamp, varchar(max), nvarchar(max), varbinary(max), xml or sqlclr type.

Invalid partition number %I64d specified for %S_MSG ‘%.*ls’, partition number can range from 1 to %d.

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has an XML index ‘%.*ls’ on it. Only source table can have XML indexes in the ALTER TABLE SWITCH statement.

The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.

ALTER TABLE SWITCH statement failed because the object ‘%.*ls’ is not a user defined table.

ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has clustered index ‘%.*ls’ while the table ‘%.*ls’ does not have clustered index.

ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has view ‘%.*ls’ with schemabinding.

ALTER TABLE SWITCH statement failed because column ‘%.*ls’ at ordinal %d in table ‘%.*ls’ has a different name than the column ‘%.*ls’ at the same ordinal in table ‘%.*ls’.

ALTER TABLE SWITCH statement failed because table ‘%.*ls’ has %d columns and table ‘%.*ls’ has %d columns.

Remote Name Could not be Resolved in SQL Server Reporting Services

Errors in the OLAP Storage Engine: The attribute key cannot be found

There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information

Error 0xC0012050 while loading package file

A Connection Cannot be Made to Redirector

The %S_MSG that starts with ‘%.*ls’ is too long.

Cannot specify both READ_ONLY and FOR READ ONLY on a cursor declaration.

The file size, max size cannot be greater than 2147483647 in units of a page size. The file growth cannot be greater than 2147483647 in units of both page size and percentage.

Invalid zero-length device name. Reissue the BACKUP statement with a valid device name.

INSERT into an identity column not allowed on table variables.

SQL Web Assistant: The @blobfmt parameter specification is invalid.

SQL Web Assistant: @singlerow must be 0 or 1. Cannot specify this parameter with @nrowsperpage.

SQL Web Assistant: Could not open the output file.

SQL Web Assistant: Could not execute the SQL statement.

Could not obtain information about Windows NT group/user ‘%ls’, error code %#lx.

sp_indexoption is not supported for XML Index and the table has an XML index on it. Use ALTER INDEX instead to set the option for ALL the indexes.

sp_indexoption is not supported for XML Index. Use ALTER INDEX instead.

User does not have permission to perform this action.

Usage: sp_dboption [dbname [,optname [,'true' | 'false']]]

Cannot change the owner of an indexed view.

The MUST_CHANGE option is not supported by this version of Microsoft Windows.

Setuser failed because of one of the following reasons: the database principal ‘%.*ls’ does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permissi

Cannot %S_MSG the %S_MSG ‘%.*ls’, because it does not exist or you do not have permission.

Cannot %S_MSG the %S_MSG ‘%.*ls’.

SQL Web Assistant: @numunits must be greater than 0.

SQL Web Assistant: @dayflags must be 1, 2, 4, 8, 16, 32, or 64.

SQL Web Assistant: The @targettime parameter must be between 0 and 240000.

SQL Web Assistant: @targetdate is invalid. It must be a valid date after 1900-01-01.

SQL Web Assistant: @unittype must be in the range 1 to 4.

SQL Web Assistant: @whentype must be in the range 1 to 9.

SQL Web Assistant: @HTMLheader must be in the range 1 to 6.

SQL Web Assistant: @lastupdated must be 0 or 1.

SQL Web Assistant: @colheaders must be 0 or 1.

SQL Web Assistant: @italic must be 0 or 1.

SQL Web Assistant: @bold must be 0 or 1.

SQL Web Assistant: @fixedfont must be 0 or 1.

The target ‘%.*ls’ of the OUTPUT INTO clause cannot be a view or common table expression.

An aggregate cannot appear in an ON clause unless it is in a subquery contained in a HAVING clause or select list, and the column being aggregated is an outer reference.

CREATE FUNCTION failed because a column name is not specified for column %d.

Ad hoc updates to system catalogs are not allowed.

Cannot create %S_MSG on view “%.*ls” because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or not indexing the view. Alternatively, consider replacing DISTINCT with GROUP BY or COUNT_BIG(*) to simulate DISTINCT on groupin

Cannot create %S_MSG on view “%.*ls” because it uses aggregate “%.*ls”. Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG.

Cannot create %S_MSG on view “%.*ls” because it references common table expression “%.*ls”. Views referencing common table expressions cannot be indexed. Consider not indexing the view, or removing the common table expression from the view definition

Cannot create %S_MSG on view ‘%.*ls’ because its select list does not include a proper use of COUNT_BIG. Consider adding COUNT_BIG(*) to select list.

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.

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.

The compute by list does not match the order by list.

Only base table columns are allowed in the TEXTPTR function.

The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled check constraints or any enabled rules. Found check constraint or rule ‘%ls’.

The column ‘%.*ls’ was specified multiple times for ‘%.*ls’.

‘%.*ls’ has more columns than were specified in the column list.

‘%.*ls’ has fewer columns than were specified in the column list.

Cannot create two constraints named ‘%.*ls’. Duplicate constraint names are not allowed.

Only UNIQUE or PRIMARY KEY constraints can be created on computed columns, while CHECK, FOREIGN KEY, and NOT NULL constraints require that computed columns be persisted.

The object ‘%.*ls’ does not exist or is invalid for this operation.

In EXECUTE , procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.

Cannot create the clustered index “%.*ls” on view “%.*ls” because the view references an unknown value (SUM aggregate of nullable expression). Consider referencing only non-nullable values in SUM. ISNULL() may be useful for this.

Cannot add identity column, using the SELECT INTO statement, to table ‘%.*ls’, which already has column ‘%.*ls’ that inherits the identity property.

Attempting to add multiple identity columns to table ‘%.*ls’ using the SELECT INTO statement.

Argument data type %ls is invalid for argument %d of %ls function.

Column ‘%.*ls.%.*ls’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Column ‘%.*ls.%.*ls’ is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.

None of the result expressions in a CASE specification can be NULL.

More than one key specified in column level %ls constraint, table ‘%.*ls’.

%.*ls is not a parameter for procedure %.*ls.

Procedure %.*ls has no parameters and arguments were supplied.

Could not create IDENTITY attribute on nullable column ‘%.*ls’, table ‘%.*ls’.

Multiple NULL constraints were specified for column ‘%.*ls’, table ‘%.*ls’.

Both a PRIMARY KEY and UNIQUE constraint have been defined for column ‘%.*ls’, table ‘%.*ls’. Only one is allowed.

String or binary data would be truncated.

No column was specified for column %d of ‘%.*ls’.

Windowed functions do not support integer indices as ORDER BY clause expressions.

Windowed functions do not support constants as ORDER BY clause expressions.

You do not have permission to run the RECONFIGURE statement.

KILL command cannot be used inside user transactions.

Column ‘%.*ls’ on table ‘%.*ls’ is not of type XML, which is required to create an XML index on it.

Primary XML Index ‘%.*ls’ already exists on column ‘%.*ls’ on table ‘%.*ls’, and multiple Primary XML Indexes per column are not allowed.

Table ‘%.*ls’ needs to have a clustered primary key with less than %d columns in it in order to create a primary XML index on it.

Could not find %ls XML index named ‘%.*ls’ on table ‘%.*ls’

Could not create XML index on object ‘%.*ls’ because that object is not a table.

‘%.*ls’ is not a valid XML Index name because it starts with ‘%c’ character. XML Index name should not start with ‘#’ or ‘@’

Cannot create secondary xml index ‘%.*ls’ without a USING XML INDEX clause.

The primary xml index ‘%.*ls’ does not exist on table ‘%.*ls’ column ‘%.*ls’.

Invalid text, ntext, or image pointer type. Must be binary(16).

The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.

NULL textptr (text, ntext, or image pointer) passed to %ls function.

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.

The required parameter %.*ls was not specified.

‘%.*ls’ does not contain an identity column.

‘%.*ls’ is not a user table. Cannot perform SET operation.

MODIFY FILE failed. Size is greater than MAXSIZE.

MODIFY FILE failed. File ‘%.*ls’ does not exist.

Cannot have a filegroup with the name ‘DEFAULT’.

Option ‘%.*ls’ cannot be set in database ‘%.*ls’.

The option “%.*ls” conflicts with another requested option. The options cannot both be requested at the same time.

The %S_MSG ‘%.*ls’ is dependent on %S_MSG ‘%.*ls’.

MAXSIZE cannot be less than SIZE for file ‘%ls’.

A file activation error occurred. The physical file name ‘%.*ls’ may be incorrect. Diagnose and correct additional errors, and retry the operation.

Directory lookup for the file “%ls” failed with the operating system error %ls.

Cannot create file ‘%ls’ because it already exists. Change the file path or the file name, and retry the operation.

At least one of the arguments to COALESCE must be a typed NULL.

BACKUP LOG cannot be performed because there is no current database backup.

Cannot update the view or function “%.*ls” because it contains aggregates or a DISTINCT clause.

View or function ‘%.*ls’ is not updatable because the modification affects multiple base tables.

Views or functions are not allowed on temporary tables. Table names that begin with ‘#’ denote temporary tables.

Create View or Function failed because no column name was specified for column %d.

Cannot schema bind %S_MSG ‘%.*ls’ because name ‘%.*ls’ is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

Grantor does not have GRANT permission.

Cannot grant, deny or revoke permissions to or from special roles.

ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must

%ls %.*ls failed because one or more objects access this column.

ALTER TABLE DROP COLUMN failed because ‘%.*ls’ is the only data column in table ‘%.*ls’. A table must have at least one data column.

%ls failed because column ‘%.*ls’ does not exist in table ‘%.*ls’.

ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table ‘%.*ls’ with ROWGUIDCOL property.

ALTER TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table ‘%.*ls’ with ROWGUIDCOL property.

One or more files listed in the statement could not be found or could not be initialized.

The master and model databases cannot have files added to them. ALTER DATABASE was aborted.

The primary data or log file cannot be removed from a database.

MODIFY FILE failed for file “%.*ls”. At least one property per file must be specified.

MODIFY FILE failed. Specified size is less than current size.

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.

The function ‘ntile’ takes only a positive int or bigint expression as its input.

Cannot create procedure ‘%.*ls’ with a group number of %d because a procedure with the same name and a group number of 1 does not currently exist in the database. Must execute CREATE PROCEDURE ‘%.*ls’;1 first.

Column names in each table must be unique. Column name ‘%.*ls’ in table ‘%.*ls’ is specified more than once.

Column, parameter, or variable #%d: Cannot find data type %.*ls.

Cannot schema bind %S_MSG ‘%.*ls’ because it references system object ‘%.*ls’.

Cannot create primary xml index ‘%.*ls’ on ‘%.*ls’ because PRIMARY KEY constraint contains column(s) of type timestamp.

The text, ntext, and image data types are invalid for local variables.

Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.

Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option.

SET DEADLOCK_PRIORITY option is invalid. Valid options are {HIGH | NORMAL | LOW | [%d ... %d] of type integer}.

The ROWGUIDCOL property can only be specified on the uniqueidentifier data type.

The SELECT INTO statement cannot have same source and destination tables.

Cannot access temporary tables from within a function.

BACKUP DATABASE cannot be used on a database opened in emergency mode.

Cannot %S_MSG the %S_MSG ‘%.*ls’, because it does not exist or you do not have permission.

Cannot use DROP %ls with ‘%.*ls’ because ‘%.*ls’ is a %S_MSG. Use DROP %ls.

Could not drop the primary key constraint ‘%.*ls’ because the table has an XML index.

Only a clustered index can be dropped online.

Cannot drop a clustered index created on a view using drop clustered index clause. Clustered index ‘%.*ls’ is created on view ‘%.*ls’.

Cannot drop non-clustered index ‘%.*ls’ using drop clustered index clause.

Cannot drop XML Index ‘%.*ls’ using old ‘Table.Index’ syntax, use ‘Index ON Table’ syntax instead.

Windowed functions can only appear in the SELECT or ORDER BY clauses.

Windowed functions cannot be used in the context of another windowed function or aggregate.

The CREATE SCHEMA statement should be followed by a name or authorization keyword.

The ranking function “%.*ls” must have an ORDER BY clause.

“%.*ls” is not a valid windowing function, and cannot be used with the OVER clause.

The function ‘%.*ls’ takes exactly %d argument(s).

Cannot convert a clustered index to a nonclustered index by using the DROP_EXISTING option. To change the index type from clustered to nonclustered, delete the clustered index, and then create a nonclustered index by using two separate statements.

There are already statistics on table ‘%.*ls’ named ‘%.*ls’.

Statistics cannot be created on object ‘%.*ls’ because the object is not a user table or view.

Cannot create %S_MSG on view ‘%.*ls’ because the view is not schema bound.

Cannot create %S_MSG on view ‘%.*ls’. It does not have a unique clustered index.

Cannot create nonunique clustered index on view ‘%.*ls’ because only unique clustered indexes are allowed. Consider creating unique clustered index instead.

Cannot create %S_MSG on view “%.*ls”. The view contains a self join on “%.*ls”.

Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields nondeterministic results. Use a deterministic system function, or modify the user-defined function to return deterministic results.

Cannot create an index on a view or computed column because the compatibility level of this database is less than 80. Use sp_dbcmptlevel to raise the compatibility level of the database.

Cannot perform the specified operation on disabled index ‘%.*ls’ on %S_MSG ‘%.*ls’.

Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’. Only XML Index can be created on XML column ‘%.*ls’.

Cannot rebuild clustered index ‘%.*ls’ online because it is disabled.

Cannot create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option while table has an XML Index.

Procedures with a group number cannot have parameters of xml or sqlclr user defined types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’.

Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number.

The object ‘%.*ls’ is not a procedure so you cannot create another procedure under that group name.

Index hints cannot be specified within a schema-bound object.

Cannot find a table or object with the name “%.*ls”. Check the system catalog.

The CONCAT_NULL_YIELDS_NULL option must be set to ON to run DBCC CHECKCONSTRAINTS.

Parameter %d is incorrect for this DBCC statement.

Cannot insert duplicate key row in object ‘%.*ls’ with unique index ‘%.*ls’.

Violation of %ls constraint ‘%.*ls’. Cannot insert duplicate key in object ‘%.*ls’.

The %S_MSG ‘%.*ls’ on table ‘%.*ls’ has %d column names in %S_MSG key list. The maximum limit for index or statistics key column list is %d.

Cannot use duplicate column names in %S_MSG. Column name ‘%.*ls’ listed more than once.

Column name ‘%.*ls’ does not exist in the target table or view.

The operation failed because an index or statistics with name ‘%.*ls’ already exists on %S_MSG ‘%.*ls’.

Index cannot be created on object ‘%.*ls’ because the object is not a user table or view.

Cannot alter a non-unique index with ignore_dup_key index option. Index ‘%.*ls’ is non-unique.

CREATE INDEX options %ls and %ls are mutually exclusive.

Cannot create, rebuild or drop an index on a local temporary table online. Perform the index operation offline.

Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index.

Invalid %S_MSG ‘%.*ls’ specified.

Could not locate entry in sysdatabases for database ‘%.*ls’. No entry found with that name. Make sure that the name is entered correctly.

Line %d: Length or precision specification %d is invalid.

The correlation name ‘%.*ls’ is specified multiple times in a FROM clause.

The correlation name ‘%.*ls’ has the same exposed name as table ‘%.*ls’.

File option %hs is required in this CREATE/ALTER DATABASE statement.

Syntax ‘%ls’ is not allowed in schema-bound objects.

The SET SHOWPLAN statements must be the only statements in the batch.

Creation of temporary functions is not allowed.

Cannot find the object “%.*ls” because it does not exist or you do not have permissions.

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name ‘%.*ls’ and the index name ‘%.*ls’. The duplicate key value is %ls.

Creating or altering table ‘%.*ls’ failed because the minimum row size would be %d, including %d bytes of internal overhead. This exceeds the maximum allowable table row size of %d bytes.

Could not create constraint. See previous errors.

Column ‘%.*ls.%.*ls’ is not the same length as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’. Columns participating in a foreign key relationship must be defined with the same length.

Defaults cannot be created on columns with an IDENTITY attribute. Table ‘%.*ls’, column ‘%.*ls’.

Skipping FOREIGN KEY constraint ‘%.*ls’ definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.

Computed column ‘%.*ls’ in table ‘%.*ls’ is not allowed to be used in another computed-column definition.

Constraints of type %ls cannot be created on columns of type %ls.

Cross-database foreign key references are not supported. Foreign key ‘%.*ls’.

Foreign key ‘%.*ls’ references invalid table ‘%.*ls’.

Foreign key ‘%.*ls’ references object ‘%.*ls’ which is not a user table.

Foreign key ‘%.*ls’ references invalid column ‘%.*ls’ in referenced table ‘%.*ls’.

There are no primary or candidate keys in the referenced table ‘%.*ls’ that match the referencing column list in the foreign key ‘%.*ls’.

Column ‘%.*ls.%.*ls’ is not the same data type as referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’.

Either column ‘%.*ls.%.*ls’ or referencing column ‘%.*ls.%.*ls’ in foreign key ‘%.*ls’ is a timestamp column. This data type cannot be used with cascading referential integrity constraints.

Cascading foreign key ‘%.*ls’ cannot be created where the referencing column ‘%.*ls.%.*ls’ is an identity column.

Cannot use CHECKSUM(*) in a computed column definition.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

The CREATE DATABASE statement failed. The primary file must be at least %d MB to accommodate a copy of the model database.

Cannot create more than one clustered index on %S_MSG ‘%.*ls’. Drop the existing clustered index ‘%.*ls’ before creating another.

The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.

Invalid ROWS value or REPEATABLE seed “%I64d” in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be greater than 0.

Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause.

Variables are not allowed in the TABLESAMPLE or REPEATABLE clauses.

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Cannot insert the value NULL into column ‘%.*ls’, table ‘%.*ls’; column does not allow nulls. %ls fails.

Difference of two datetime columns caused overflow at runtime.

The %ls statement conflicted with the %ls constraint “%.*ls”. The conflict occurred in database “%.*ls”, table “%.*ls”%ls%.*ls%ls.

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’.

The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Table and column names must be supplied for the READTEXT or WRITETEXT utility.

The valid range for MAX_QUEUE_READERS is 0 to 32767.

An INSERT statement cannot contain a SELECT statement that assigns values to a variable.

Operand type clash: %ls is incompatible with %ls

The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’.

Cannot convert a char value to money. The char value has incorrect syntax.

Types don’t match between the anchor and the recursive part in column “%.*ls” of recursive query “%.*ls”.

Recursive common table expression ‘%.*ls’ does not contain a top-level UNION ALL operator.

Recursive member of a common table expression ‘%.*ls’ has multiple recursive references.

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.

The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.

The xml data type cannot be compared or sorted, except when using the IS NULL operator.

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

Index ID %d on table ‘%.*ls’ (specified in the FROM clause) does not exist.

The data types %s and %s are incompatible in the %s operator.

Invalid collation ‘%.*ls’.

DISTINCT operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

TOP operator is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Outer join is not allowed in the recursive part of a recursive common table expression ‘%.*ls’.

Invalid PERCENT tablesample size “%f” for table “%.*ls”. The PERCENT tablesample size must be between 0 and 100.

Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table “%.*ls”. The value or seed must be an integer.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service

Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.

The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.

A GOTO statement references the label ‘%.*ls’ but the label has not been declared.

Cannot use a BREAK statement outside the scope of a WHILE statement.

Cannot use a CONTINUE statement outside the scope of a WHILE statement.

The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d).

Can only use IF UPDATE within a CREATE TRIGGER statement.

Invalid usage of the option %.*ls in the %ls statement.

An aggregate may not appear in the set list of an UPDATE statement.

An aggregate may not appear in the OUTPUT clause.

Each GROUP BY expression must contain at least one column that is not an outer reference.

The IDENTITY function can only be used when the SELECT statement has an INTO clause.

Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file.

A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.

Cannot back up the log of the master database. Use BACKUP DATABASE instead

The query uses non-ANSI outer join operators.

‘%.*ls’ is not a constraint.

Could not drop constraint. See previous errors.

A column has been specified more than once in the order by list. Columns in the order by list must be unique

An aggregate may not appear in a computed column expression or check constraint

The scale (%d) for column ‘%.*ls’ must be within the range %d to %d.

The scale must be less than or equal to the precision

Procedure or function ‘%.*ls’ expects parameter ‘%.*ls’, which was not supplied.

Conversion failed when converting datetime from binary/varbinary string

Insert Error: Column name or number of supplied values does not match table definition

Parameters were not supplied for the function ‘%.*ls’.

The column “%.*ls” cannot be modified because it is either a computed column or is the result of a UNION operator

Cannot update a timestamp column

Cannot alter column ‘%.*ls’ to be data type %.*ls

Process ID %d is not a valid process ID. Choose a number between 1 and %d

Cannot use KILL to kill your own process

Process ID %d is not an active process ID

Only user processes can be killed

The database ‘%s’ does not exist. Supply a valid database name. To see available databases, use sys.databases.

Column, parameter, or variable #%d: Cannot specify a column width on data type %.*ls.

SET LANGUAGE failed because ‘%.*ls’ is not an official language name or a language alias on this SQL Server

A table can only have one timestamp column. Because table ‘%.*ls’ already has one, the column ‘%.*ls’ cannot be added

Multiple identity columns specified for table ‘%.*ls’. Only one identity column per table is allowed.

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

Identity column ‘%.*ls’ contains invalid SEED

Identity column ‘%.*ls’ contains invalid INCREMENT.

%hs is terminating abnormally

Cannot drop database “%.*ls” because it is currently in use.

Cannot drop a default constraint by DROP DEFAULT statement. Use ALTER TABLE to drop a constraint default.

Defaults cannot be created on columns of data type timestamp. Table ‘%.*ls’, column ‘%.*ls’.

Conflicting locking hints specified

Invalid use of side-effecting or time-dependent operator in ‘%s’ within a function.

Line %d: Specified scale %d is invalid.

Cannot open backup device ‘%ls’. Operating system error %ls.

The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

Each file size must be greater than or equal to 512 KB

System databases master, model, msdb, and tempdb cannot be detached.

Error: SQL Server has encountered xxxx occurrence(s) of IO requests taking longer than 15 seconds to complete on file

‘%1!’ must be the first statement in a query batch.

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

Must specify the table and the index name for DROP INDEX statement.

Incorrect time syntax in time string ‘%1!’ used with WAITFOR.

Could not find any index named ‘%1!’ for table ‘%2!’.

‘%.*ls’ is not a recognized %ls option.

Incorrect syntax near the keyword ‘%.*ls’.

The %.*ls function requires %d argument(s).

Conversion failed when converting the %ls value ‘%.*ls’ to data type %ls.

‘%.*ls’ is not a recognized %S_MSG.

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

DEFAULT or NULL are not allowed as explicit identity values.

A constant expression was encountered in the ORDER BY list, position %i.

Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.

Invalid length parameter passed to the %ls function.

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries

The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.

Operand data type %1! is invalid for %2! operator.

Table ‘%1!’ does not have the identity property. Cannot perform SET operation.

An explicit value for the identity column in table ‘%1!’ can only be specified

Cannot insert explicit value for identity column in table ‘%1!’ when IDENTITY_INSERT is set to OFF.

“%1!”: Temporary views are not allowed.

Database ‘%1!’ already exists.

Column already has a DEFAULT bound to it.

More than one column %1! constraint specified for column ‘%2!’, table ‘t’.

The definition for column ‘%1!’ must include a data type.

The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.

Arithmetic overflow error converting expression to data type %1!.

The conversion of the %1! value %2!’ overflowed an %3! column.

Type %1! is not a defined system type.

Conversion failed when converting datetime from character string.

Arithmetic overflow error for data type %1!, value = %2!.

Divide by zero error encountered.

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Table ‘%1!” already has a primary key defined on it.

Cannot add multiple PRIMARY KEY constraints to table ‘%1!’.

Cannot define PRIMARY KEY constraint on nullable column in table ‘%1!’.

Cannot update identity column ‘%1!’.

A domain error occurred.

There is already an object named ‘%1!’ in the database.

A TOP N value may not be negative.

Invalid object name ‘%1!’.

%1! is not a valid style number when converting from datetime to a character string.

Could not find stored procedure ‘%1′.

Procedure or function %1! has too many arguments specified.

Column “%1!.%2!” is invalid in the ORDER BY clause

Invalid column name ‘%.*ls’.

Ambiguous column name ‘%.*ls’.

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.

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.

The variable name ‘%.*ls’ has already been declared. Variable names must be unique within a query batch or stored procedure.

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.

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.

Cannot assign a default value to a local variable.

A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Percent values must be between 0 and 100.

SET DATEFORMAT date order ‘mmy’ is invalid.

SET DATEFIRST %1! is out of range.

Missing end comment mark ‘*/’.

The ORDER BY position number %ld is out of range of the number of items in the select list.

The column prefix ‘%.*ls’ does not match with a table name or alias name used in the query.

Must declare the variable ‘%.*ls’.

Unclosed quotation mark before the character string ‘%.*ls’.

Line %d: Incorrect syntax near ‘%.*ls’.



Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |