Home
Articles
Forums
Tips
Training
FAQ's
Blogs
Software
Books
About Us
RSS Feeds
Sign in
|
Join
FAQ Topics
All FAQ's
General DBA
General Developer
DBA Performance Tuning
Developer Performance Tuning
Clustering
Error Messages
USEFUL SITES :
ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help
Write for Us
Share your SQL Server knowledge with others and raise your profile in the community
More...
Latest Articles
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server
More
Latest SQL Server FAQ's
SQL Server Destination remote server error
Add Node to A SQL Server failover Cluster failed with invalid SKU error
Setting Up Data And Log Files For SQL Server
Is there a difference between fill factor 0 and 100
The Excel Connection Manager is not supported in the 64-bit version of SSIS
Will Check Constraints Improve Database Performance?
An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode
Cannot find either column "%.*ls" or the user-defined function or aggregate "%.*ls", or the name is ambiguous.
XQuery [query()]: Attribute may not appear outside of an element
%sThere are not enough actual arguments in the call to function "%ls".
%sThe name "%ls" has already been defined.
%sSyntax error near '%ls', expected '%ls'.
XQuery: Unable to resolve sql:variable('%.*ls'). The variable must be declared as a scalar TSQL variable.
%sOnly 'http://www.w3.org/2001/XMLSchema#boolean?' or 'node()*' expressions allowed in conditions and with logical operators, found '%ls'
%sThe operator "%ls" cannot be applied to "%ls" and "%ls" operands.
%sHeterogeneous sequences are not allowed in '%ls', found '%ls' and '%ls'.
%sUnterminated string constant (started on line %u)
%sInvalid source character 0x%02x
%sVariable expected: '$name'
%sResult of '%ls' expression is statically 'empty'
%sThe name "%ls" does not denote a namespace.
Cannot call methods on %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'.
%s'%ls' requires a singleton (or empty sequence), found operand of type '%ls'
%sNo more tokens expected at the end of the XQuery expression. Found '%ls'.
"%.*ls" is not a valid function, property, or field.
%sSyntax error near '%ls'
%sThe XQuery syntax '%ls' is not supported.
%sAn expression was expected
%s"%ls" was expected.
%sSyntax error near '%ls', expected 'where', '(stable) order by' or 'return'.
%s'%ls' or '%ls' expected
%sThere is no function '%ls:%ls()'
%sThe variable '%ls' was not found in the scope in which it was referenced.
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.
Cannot use index option ignore_dup_key to alter index '%.*ls' as it enforces a primary or unique constraint.
There is no user table matching the input name '%s' in the current database or you do not have permission to access the table.
Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option.
Cannot recreate index '%.*ls'. The new index definition does not match the constraint being enforced by the existing index.
Index '%.*ls' was not created. This index has a key length of at least %d bytes. The maximum permissible key length is %d bytes.
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 no row can satisfy the view definition. Consider eliminating contradictions from the view definition.
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.
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.
There are no matching rows on which to report.
Database option '%s' does not exist. Specify a valid database option.
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.
DROP XML INDEX does not support any options.
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.
Column names in each view or function must be unique. Column name '%.*ls' in view or function '%.*ls' is specified more than once.
Constraint name '%.*ls' not permitted. Constraint names cannot begin with a number sign (#).
Insufficient result space to convert uniqueidentifier value to char.
Conversion failed when converting from a character string to uniqueidentifier.
Hint '%ls' on object '%.*ls' is invalid.
Cannot issue SAVE TRANSACTION when there is no active transaction.
INSERT EXEC failed because the stored procedure altered the schema of the target table.
Only functions and extended stored procedures can be executed from within a function.
GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression '%.*ls'.
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.
The 'COMPUTE' clause is not allowed in a statement containing an INTERSECT or EXCEPT operator.
Invalid parameter %d specified for %ls.
The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.
An expression of non-boolean type specified in a context where a condition is expected, near '%.*ls'.
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.
Browse mode is invalid for a statement that assigns values to a variable.
The message number %u or specified language version does not exist.
Cannot drop a message with an ID less than 50,000.
User, group, or role '%s' already exists in the current database.
Explicit conversion from data type %ls to %ls is not allowed.
The formal parameter "%.*ls" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.
The %ls data type cannot be selected as DISTINCT because it is not comparable.
The variable "%.*ls" is specified in the OPTIMIZE FOR clause, but is not used in the query.
The value %d specified for the MAXRECURSION option exceeds the allowed maximum of %d.
Browse mode is invalid for statements containing a UNION, INTERSECT or EXCEPT operator.
Browse mode cannot be used with INSERT, SELECT INTO, or UPDATE statements.
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.
Cannot use HOLDLOCK in browse mode.
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
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 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.
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 use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns.
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 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.
A trigger returned a resultset and the server option 'disallow results from triggers' is true.
The last statement included within a function must be a return statement.
Select statements included within a function cannot return data to a client.
The logical tables INSERTED and DELETED cannot be updated.
The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.
Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.
The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.
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.
ALTER TABLE SWITCH statement failed. Target table '%.*ls' and source table '%.*ls' have different vardecimal storage format values.
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.
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.
Vardecimal storage format is not available in system database '%s'.
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.
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.
ALTER TABLE failed because trigger '%.*ls' does not belong to table '%.*ls'.
ALTER TABLE failed because trigger '%.*ls' on table '%.*ls' does not exist.
Cannot bulk load. The file "%ls" does not exist.
CREATE DATABASE permission can only be granted in the master database.
Derived table '%.*ls' is not updatable because it contains aggregates, or a DISTINCT or GROUP BY clause, or PIVOT or UNPIVOT operator.
Derived table '%.*ls' is not updatable because a column of the derived table is derived or constant.
Backup and restore operations are not allowed on database tempdb.
FIPS Warning: The length of identifier '%.*ls' exceeds 18.
FIPS Warning: Line %d has the non-ANSI clause '%ls'.
FIPS Warning: Line %d has the non-ANSI statement '%ls'.
COMPUTE clause #%d, aggregate expression #%d is not in the select list.
Cannot specify included columns for a clustered index.
Cannot create plan guide '%.*ls' because its name is invalid. Plan guide name cannot begin with a '#' character.
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 value '%.*ls' provided for @module_or_batch is not legal two-part name. Use 'schema_name.object_name'.
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 object '@module_or_batch' is encrypted. Consider tuning query using other techniques such as indexes and statistics.
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 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 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 parameter @stmt has more than one statement.
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 @hints is incorrect. Use N'OPTION (
[ ,...n ] )'.
Cannot create plan guide '%.*ls' because type '%.*ls' provided is not allowed.
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 @module_or_batch can not be compiled.
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 %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 contains a CUBE, ROLLUP, or GROUPING SETS operator. Consider not indexing this 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 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 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 an INNER join that specifies a join hint. Consider removing the join hint.
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.
XML parsing: line %d, character %d, end tag does not match start tag
XML parsing: line %d, character %d, unexpected end of input
ALTER TABLE SWITCH statement failed because column '%.*ls' does not have the same collation in tables '%.*ls' and '%.*ls'.
The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.
The transaction name must be specified when it is used with the mark option.
The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum allowed (%d).
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.
Cannot create %S_MSG on view "%.*ls" because it uses the aggregate COUNT. Use COUNT_BIG instead.
The READPAST lock hint is only allowed on target tables of UPDATE and DELETE and on tables specified in an explicit FROM clause.
Computed column '%.*ls' in table '%.*ls' cannot be persisted because the column is non-deterministic.
The ALTER TABLE SWITCH statement failed. The table "%.*ls" has a disabled clustered index.
Partitioned view '%.*ls' is not updatable because table '%.*ls' has a DEFAULT constraint.
Using defaults is not allowed in views that contain a set operator.
Cannot INSERT into partitioned view '%.*ls' because table '%.*ls' has an IDENTITY constraint.
Partitioned view '%.*ls' is not updatable because it does not deliver all columns from its member tables.
Cannot INSERT into partitioned view '%.*ls' because values were not supplied for all columns.
Partitioned view '%.*ls' is not updatable because a value was not specified for partitioning column '%.*ls'.
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 table '%.*ls' has a timestamp column.
UNION ALL view '%.*ls' is not updatable because the primary key of table '%.*ls' is not unioned with primary keys of preceding tables.
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 included in the union result.
UNION ALL view '%.*ls' is not updatable because base table '%.*ls' is used multiple times.
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 a partitioning column was not found.
Update or insert of view or function '%.*ls' failed because it contains a derived or constant field.
Operation failed. The index entry of length %d bytes for the index '%.*ls' exceeds the maximum length of %d bytes.
Cannot create the foreign key '%.*ls' because the referenced column '%.*ls.%.*ls' is a non-persisted computed column.
Cannot create foreign key '%.*ls' because it references object '%.*ls' whose clustered index '%.*ls' is disabled.
Foreign key references to temporary tables are not supported. Foreign key '%.*ls'.
Cannot create the foreign key "%.*ls" with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.
Cannot create the foreign key "%.*ls" with the SET NULL referential action, because one or more referencing columns are not nullable.
Column '%.*ls.%.*ls' is not of same collation as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.
'%.*ls' is an invalid event type.
The NOLOCK and READUNCOMMITTED lock hints are not allowed for target tables of INSERT, UPDATE or DELETE statements.
Cannot set or reset the 'parseonly' option within a procedure or function.
The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION, INTERSECT or EXCEPT operator.
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.
Syntax error: Duplicate specification of the action "%.*s" in the trigger declaration.
The %S_MSG '%.*ls' is out of the range for numeric representation (maximum precision 38).
The TABLESAMPLE clause can only be used with local tables.
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 target table '%.*ls' of the OUTPUT INTO clause cannot have any enabled triggers.
The index ID %d on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
Index "%.*ls" on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
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) does not exist.
The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
Cannot use the OUTPUT option when passing a constant to a stored procedure.
Query not allowed in Waitfor.
Usage: sp_bindefault defaultname, objectname [, 'futureonly']
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.
Cannot bind a default to a column created with or altered to have a default value.
Cannot change the owner of the master, model, tempdb or distribution database.
The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.
The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.
'%s' is not a valid option for the @updateusage parameter. Enter either 'true' or 'false'.
The data type or table column '%s' does not exist or you do not have permission.
IDENTITY_INSERT is already ON for table '%.*ls.%.*ls.%.*ls'. Cannot perform SET operation for table '%.*ls'.
ALTER TABLE SWITCH statement failed because column '%.*ls' does not have the same nullability attribute in tables '%.*ls' and '%.*ls'.
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. 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. 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. 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. Column '%.*ls' in table '%.*ls' is computed column but the same column in '%.*ls' is not computed.
'%ls' statement failed because the expression identifying partition number for the %S_MSG '%.*ls' is not of integer type.
ALTER TABLE SWITCH statement failed. There is no identical index in source table '%.*ls' for the index '%.*ls' 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 because column '%.*ls' has data type %s in source table '%.*ls' which is different from its type %s in target table '%.*ls'.
A cursor with the name '%.*ls' already exists.
A cursor with the name '%.*ls' does not exist.
Cursor is not open.
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]
Invalid partition number %I64d specified for %S_MSG '%.*ls', partition number can range from 1 to %d.
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.
Cannot bind a default to an identity column.
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]
Invalid partition number %I64d specified for %S_MSG '%.*ls', partition number can range from 1 to %d.
Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created.
Remove a Node From a SQL Server 2008 Cluster
Report Builder Fails to Launch
The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF.
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.
Invalid partition number %I64d specified for %S_MSG '%.*ls', partition number can range from 1 to %d.
Error when Inserting data to Replicated Databases
How to run SQL Profiler without sysadmin rights?
How to Perform Multiple lookups to the same table
How to import an Excel file which has columns with more than 255 characters to SQL Server using SSIS?
How to Manually Uninstall SQL Server 2005
How to send a SSRS report from SSIS?
How to alter a User Defined Data Type?
How to view previous query plans?
How to unzip a File in SSIS?
ALTER TABLE SWITCH statement failed because the object '%.*ls' is not a user defined table.
ALTER TABLE SWITCH statement failed because table '%.*ls' has %d columns and table '%.*ls' has %d columns.
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. The table '%.*ls' has view '%.*ls' with schemabinding.
ALTER TABLE SWITCH statement failed. The table '%.*ls' has clustered index '%.*ls' while the table '%.*ls' does not have clustered index.
SQL Server Reporting Server (SSRS) service is failing to start
Cannot Start SQL Server Service
Users are able to connect to report manager but not able to connect to report server.
Errors when SQL Server Snapshot Replication is Running
How to Display Server Name or IP Address in a Reporting Services Report
How to schedule SSAS Database backup?