SQL Server Error Messages FAQ's

RSS Feeds

FAQ Topics

All FAQ's

General DBA

General Developer

DBA Performance Tuning

Developer Performance Tuning

Clustering

Error Messages

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest Articles

Working with Windows Communication Foundation (WCF)

Transfer Logins Task and Transfer Database Task in SSIS

Practical Database Change Management (Part 2)

Practical Database Change Management (Part 1)

	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.
	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 clustered index '%.ls' while the table '%.*ls' does not have clustered index.
	Remote Name Could not be Resolved in SQL Server Reporting Services
	Errors in the OLAP Storage Engine: The attribute key cannot be found
	Error 0xC0012050 while loading package file
	There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information
	A Connection Cannot be Made to Redirector
	Invalid zero-length device name. Reissue the BACKUP statement with a valid device name.
	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.
	Cannot specify both READ_ONLY and FOR READ ONLY on a cursor declaration.
	The %S_MSG that starts with '%.*ls' is too long.
	INSERT into an identity column not allowed on table variables.
	Cannot %S_MSG the %S_MSG '%.*ls'.
	Cannot %S_MSG the %S_MSG '%.*ls', because it does not exist or you do not have permission.
	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
	The MUST_CHANGE option is not supported by this version of Microsoft Windows.
	Cannot change the owner of an indexed view.
	Usage: sp_dboption [dbname [,optname [,'true' \| 'false']]]
	User does not have permission to perform this action.
	sp_indexoption is not supported for XML Index. Use ALTER INDEX instead.
	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.
	Could not obtain information about Windows NT group/user '%ls', error code %#lx.
	SQL Web Assistant: Could not execute the SQL statement.
	SQL Web Assistant: Could not open the output file.
	SQL Web Assistant: @singlerow must be 0 or 1. Cannot specify this parameter with @nrowsperpage.
	SQL Web Assistant: The @blobfmt parameter specification is invalid.
	SQL Web Assistant: @fixedfont must be 0 or 1.
	SQL Web Assistant: @bold must be 0 or 1.
	SQL Web Assistant: @italic must be 0 or 1.
	SQL Web Assistant: @colheaders must be 0 or 1.
	SQL Web Assistant: @lastupdated must be 0 or 1.
	SQL Web Assistant: @HTMLheader must be in the range 1 to 6.
	SQL Web Assistant: @whentype must be in the range 1 to 9.
	SQL Web Assistant: @unittype must be in the range 1 to 4.
	SQL Web Assistant: @targetdate is invalid. It must be a valid date after 1900-01-01.
	SQL Web Assistant: The @targettime parameter must be between 0 and 240000.
	SQL Web Assistant: @dayflags must be 1, 2, 4, 8, 16, 32, or 64.
	SQL Web Assistant: @numunits must be greater than 0.
	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.
	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 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 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
	Ad hoc updates to system catalogs are not allowed.
	CREATE FUNCTION failed because a column name is not specified for column %d.
	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.
	The target '%.*ls' of the OUTPUT INTO clause cannot be a view or common table expression.
	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'.
	Only base table columns are allowed in the TEXTPTR function.
	The compute by list does not match 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.
	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.
	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.
	In EXECUTE , procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.
	The object '%.*ls' does not exist or is invalid for this operation.
	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.
	Cannot create two constraints named '%.*ls'. Duplicate constraint names are not allowed.
	'%.*ls' has fewer columns than were specified in the column list.
	'%.*ls' has more columns than were specified in the column list.
	The column '%.ls' was specified multiple times for '%.ls'.
	No column was specified for column %d of '%.*ls'.
	String or binary data would be truncated.
	Both a PRIMARY KEY and UNIQUE constraint have been defined for column '%.ls', table '%.ls'. Only one is allowed.
	Multiple NULL constraints were specified for column '%.ls', table '%.ls'.
	Could not create IDENTITY attribute on nullable column '%.ls', table '%.ls'.
	Procedure %.*ls has no parameters and arguments were supplied.
	%.ls is not a parameter for procedure %.ls.
	More than one key specified in column level %ls constraint, table '%.*ls'.
	None of the result expressions in a CASE specification can be NULL.
	Column '%.ls.%.ls' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.
	Column '%.ls.%.ls' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
	Argument data type %ls is invalid for argument %d of %ls function.
	Attempting to add multiple identity columns to table '%.*ls' using the SELECT INTO statement.
	Cannot add identity column, using the SELECT INTO statement, to table '%.ls', which already has column '%.ls' that inherits the identity property.
	'%.*ls' is not a user table. Cannot perform SET operation.
	'%.*ls' does not contain an identity column.
	The required parameter %.*ls was not specified.
	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.
	NULL textptr (text, ntext, or image pointer) passed to %ls function.
	The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
	Invalid text, ntext, or image pointer type. Must be binary(16).
	The primary xml index '%.ls' does not exist on table '%.ls' column '%.*ls'.
	Cannot create secondary xml index '%.*ls' without a USING XML INDEX clause.
	'%.*ls' is not a valid XML Index name because it starts with '%c' character. XML Index name should not start with '#' or '@'
	Could not create XML index on object '%.*ls' because that object is not a table.
	Could not find %ls XML index named '%.ls' on table '%.ls'
	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.
	Primary XML Index '%.ls' already exists on column '%.ls' on table '%.*ls', and multiple Primary XML Indexes per column are not allowed.
	Column '%.ls' on table '%.ls' is not of type XML, which is required to create an XML index on it.
	KILL command cannot be used inside user transactions.
	You do not have permission to run the RECONFIGURE statement.
	Windowed functions do not support constants as ORDER BY clause expressions.
	Windowed functions do not support integer indices as ORDER BY clause expressions.
	Cannot create file '%ls' because it already exists. Change the file path or the file name, and retry the operation.
	Directory lookup for the file "%ls" failed with the operating system error %ls.
	A file activation error occurred. The physical file name '%.*ls' may be incorrect. Diagnose and correct additional errors, and retry the operation.
	MAXSIZE cannot be less than SIZE for file '%ls'.
	The %S_MSG '%.ls' is dependent on %S_MSG '%.ls'.
	The option "%.*ls" conflicts with another requested option. The options cannot both be requested at the same time.
	Option '%.ls' cannot be set in database '%.ls'.
	Cannot have a filegroup with the name 'DEFAULT'.
	MODIFY FILE failed. File '%.*ls' does not exist.
	MODIFY FILE failed. Size is greater than MAXSIZE.
	MODIFY FILE failed. Specified size is less than current size.
	MODIFY FILE failed for file "%.*ls". At least one property per file must be specified.
	The primary data or log file cannot be removed from a database.
	The master and model databases cannot have files added to them. ALTER DATABASE was aborted.
	One or more files listed in the statement could not be found or could not be initialized.
	ALTER TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table '%.*ls' with ROWGUIDCOL property.
	ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table '%.*ls' with ROWGUIDCOL property.
	%ls failed because column '%.ls' does not exist in table '%.ls'.
	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 %.*ls failed because one or more objects access this column.
	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
	Cannot grant, deny or revoke permissions to or from special roles.
	Grantor does not have GRANT permission.
	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.
	Create View or Function failed because no column name was specified for column %d.
	Views or functions are not allowed on temporary tables. Table names that begin with '#' denote temporary tables.
	View or function '%.*ls' is not updatable because the modification affects multiple base tables.
	Cannot update the view or function "%.*ls" because it contains aggregates or a DISTINCT clause.
	BACKUP LOG cannot be performed because there is no current database backup.
	At least one of the arguments to COALESCE must be a typed NULL.
	The function 'ntile' takes only a positive int or bigint expression as its input.
	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 '%.*ls' takes exactly %d argument(s).
	"%.*ls" is not a valid windowing function, and cannot be used with the OVER clause.
	The ranking function "%.*ls" must have an ORDER BY clause.
	The CREATE SCHEMA statement should be followed by a name or authorization keyword.
	Windowed functions cannot be used in the context of another windowed function or aggregate.
	Windowed functions can only appear in the SELECT or ORDER BY clauses.
	Cannot drop XML Index '%.*ls' using old 'Table.Index' syntax, use 'Index ON Table' syntax instead.
	Cannot drop non-clustered index '%.*ls' using drop clustered index clause.
	Cannot drop a clustered index created on a view using drop clustered index clause. Clustered index '%.ls' is created on view '%.ls'.
	Only a clustered index can be dropped online.
	Could not drop the primary key constraint '%.*ls' because the table has an XML index.
	Cannot use DROP %ls with '%.ls' because '%.ls' is a %S_MSG. Use DROP %ls.
	Cannot %S_MSG the %S_MSG '%.*ls', because it does not exist or you do not have permission.
	BACKUP DATABASE cannot be used on a database opened in emergency mode.
	Cannot access temporary tables from within a function.
	The SELECT INTO statement cannot have same source and destination tables.
	The ROWGUIDCOL property can only be specified on the uniqueidentifier data type.
	SET DEADLOCK_PRIORITY option is invalid. Valid options are {HIGH \| NORMAL \| LOW \| [%d ... %d] of type integer}.
	Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option.
	Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.
	The text, ntext, and image data types are invalid for local variables.
	Cannot create primary xml index '%.ls' on '%.ls' because PRIMARY KEY constraint contains column(s) of type timestamp.
	Cannot schema bind %S_MSG '%.ls' because it references system object '%.ls'.
	Column, parameter, or variable #%d: Cannot find data type %.*ls.
	Column names in each table must be unique. Column name '%.ls' in table '%.ls' is specified more than once.
	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.
	Violation of %ls constraint '%.ls'. Cannot insert duplicate key in object '%.ls'.
	Cannot insert duplicate key row in object '%.ls' with unique index '%.ls'.
	Parameter %d is incorrect for this DBCC statement.
	The CONCAT_NULL_YIELDS_NULL option must be set to ON to run DBCC CHECKCONSTRAINTS.
	Cannot find a table or object with the name "%.*ls". Check the system catalog.
	Index hints cannot be specified within a schema-bound object.
	The object '%.*ls' is not a procedure so you cannot create another procedure under that group name.
	Procedure '%.*ls' has already been created with group number %d. Create procedure with an unused group number.
	Procedures with a group number cannot have parameters of xml or sqlclr user defined types. Parameter '%.ls' of procedure '%.ls' has type '%ls'.
	Cannot create index enforcing primary key constraint '%.*ls' using DROP_EXISTING option while table has an XML Index.
	Cannot rebuild clustered index '%.*ls' online because it is disabled.
	Could not create %S_MSG '%.ls' on table '%.ls'. Only XML Index can be created on XML column '%.*ls'.
	Cannot perform the specified operation on disabled index '%.ls' on %S_MSG '%.ls'.
	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 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 %S_MSG on view "%.ls". The view contains a self join on "%.ls".
	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'. It does not have a unique clustered index.
	Cannot create %S_MSG on view '%.*ls' because the view is not schema bound.
	Statistics cannot be created on object '%.*ls' because the object is not a user table or view.
	There are already statistics on table '%.ls' named '%.ls'.
	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.
	Invalid %S_MSG '%.*ls' specified.
	Column '%.ls' in table '%.ls' is of a type that is invalid for use as a key column in an index.
	Cannot create, rebuild or drop an index on a local temporary table online. Perform the index operation offline.
	CREATE INDEX options %ls and %ls are mutually exclusive.
	Cannot alter a non-unique index with ignore_dup_key index option. Index '%.*ls' is non-unique.
	Index cannot be created on object '%.*ls' because the object is not a user table or view.
	The operation failed because an index or statistics with name '%.ls' already exists on %S_MSG '%.ls'.
	Column name '%.*ls' does not exist in the target table or view.
	Cannot use duplicate column names in %S_MSG. Column name '%.*ls' listed more than once.
	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 create more than one clustered index on %S_MSG '%.ls'. Drop the existing clustered index '%.ls' before creating another.
	The CREATE DATABASE statement failed. The primary file must be at least %d MB to accommodate a copy of the model database.
	CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
	Cannot use CHECKSUM(*) in a computed column definition.
	Cascading foreign key '%.ls' cannot be created where the referencing column '%.ls.%.*ls' is an identity column.
	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.
	Column '%.ls.%.ls' is not the same data type as referencing column '%.ls.%.ls' in foreign key '%.*ls'.
	There are no primary or candidate keys in the referenced table '%.ls' that match the referencing column list in the foreign key '%.ls'.
	Foreign key '%.ls' references invalid column '%.ls' in referenced table '%.*ls'.
	Foreign key '%.ls' references object '%.ls' which is not a user table.
	Foreign key '%.ls' references invalid table '%.ls'.
	Cross-database foreign key references are not supported. Foreign key '%.*ls'.
	Constraints of type %ls cannot be created on columns of type %ls.
	Computed column '%.ls' in table '%.ls' is not allowed to be used in another computed-column definition.
	Skipping FOREIGN KEY constraint '%.*ls' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
	Defaults cannot be created on columns with an IDENTITY attribute. Table '%.ls', column '%.ls'.
	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.
	Could not create constraint. See previous errors.
	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.
	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.
	Cannot find the object "%.*ls" because it does not exist or you do not have permissions.
	Creation of temporary functions is not allowed.
	The SET SHOWPLAN statements must be the only statements in the batch.
	Syntax '%ls' is not allowed in schema-bound objects.
	File option %hs is required in this CREATE/ALTER DATABASE statement.
	The correlation name '%.ls' has the same exposed name as table '%.ls'.
	The correlation name '%.*ls' is specified multiple times in a FROM clause.
	Line %d: Length or precision specification %d is invalid.
	Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.
	The %ls statement conflicted with the %ls constraint "%.ls". The conflict occurred in database "%.ls", table "%.ls"%ls%.ls%ls.
	Difference of two datetime columns caused overflow at runtime.
	Cannot insert the value NULL into column '%.ls', table '%.ls'; column does not allow nulls. %ls fails.
	Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
	Variables are not allowed in the TABLESAMPLE or REPEATABLE clauses.
	Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause.
	Invalid ROWS value or REPEATABLE seed "%I64d" in the TABLESAMPLE clause for table "%.*ls". The value or seed must be greater than 0.
	The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.
	Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table "%.*ls". The value or seed must be an integer.
	Invalid PERCENT tablesample size "%f" for table "%.*ls". The PERCENT tablesample size must be between 0 and 100.
	Outer join 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'.
	DISTINCT operator is not allowed in the recursive part of a recursive common table expression '%.*ls'.
	Invalid collation '%.*ls'.
	The data types %s and %s are incompatible in the %s operator.
	Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.
	The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
	The xml data type cannot be compared or sorted, except when using the IS NULL operator.
	The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.
	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.
	Recursive member of a common table expression '%.*ls' has multiple recursive references.
	Recursive common table expression '%.*ls' does not contain a top-level UNION ALL operator.
	Types don't match between the anchor and the recursive part in column "%.ls" of recursive query "%.ls".
	Cannot convert a char value to money. The char value has incorrect syntax.
	The %ls permission was denied on the object '%.ls', database '%.ls', schema '%.*ls'.
	Operand type clash: %ls is incompatible with %ls
	An INSERT statement cannot contain a SELECT statement that assigns values to a variable.
	The valid range for MAX_QUEUE_READERS is 0 to 32767.
	Table and column names must be supplied for the READTEXT or WRITETEXT utility.
	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.
	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'.
	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
	A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.
	Cannot specify a log file in a CREATE DATABASE statement without also specifying at least one data file.
	The IDENTITY function can only be used when the SELECT statement has an INTO clause.
	Each GROUP BY expression must contain at least one column that is not an outer reference.
	An aggregate may not appear in the OUTPUT clause.
	An aggregate may not appear in the set list of an UPDATE statement.
	Invalid usage of the option %.*ls in the %ls statement.
	Can only use IF UPDATE within a CREATE TRIGGER statement.
	The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum allowed for any data type (%d).
	Cannot use a CONTINUE statement outside the scope of a WHILE statement.
	Cannot use a BREAK statement outside the scope of a WHILE statement.
	A GOTO statement references the label '%.*ls' but the label has not been declared.
	The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.
	Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.
	Cannot update a timestamp column
	The column "%.*ls" cannot be modified because it is either a computed column or is the result of a UNION operator
	Parameters were not supplied for the function '%.*ls'.
	Insert Error: Column name or number of supplied values does not match table definition
	Conversion failed when converting datetime from binary/varbinary string
	Procedure or function '%.ls' expects parameter '%.ls', which was not supplied.
	The scale must be less than or equal to the precision
	The scale (%d) for column '%.*ls' must be within the range %d to %d.
	An aggregate may not appear in a computed column expression or check constraint
	A column has been specified more than once in the order by list. Columns in the order by list must be unique
	Could not drop constraint. See previous errors.
	'%.*ls' is not a constraint.
	The query uses non-ANSI outer join operators.
	Cannot back up the log of the master database. Use BACKUP DATABASE instead
	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
	Incorrect time syntax in time string '%1!' used with WAITFOR.
	Must specify the table and the index name for DROP INDEX statement.
	ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.
	Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
	'%1!' must be the first statement in a query batch.
	The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.
	The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries
	Invalid length parameter passed to the %ls function.
	Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.
	A constant expression was encountered in the ORDER BY list, position %i.
	DEFAULT or NULL are not allowed as explicit identity values.
	The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
	'%.*ls' is not a recognized %S_MSG.
	Conversion failed when converting the %ls value '%.*ls' to data type %ls.
	The %.*ls function requires %d argument(s).
	Incorrect syntax near the keyword '%.*ls'.
	'%.*ls' is not a recognized %ls option.
	Could not find any index named '%1!' for table '%2!'.
	Type %1! is not a defined system type.
	The conversion of the %1! value %2!' overflowed an %3! column.
	Arithmetic overflow error converting expression to data type %1!.
	The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.
	The definition for column '%1!' must include a data type.
	More than one column %1! constraint specified for column '%2!', table 't'.
	Column already has a DEFAULT bound to it.
	Database '%1!' already exists.
	"%1!": Temporary views are not allowed.
	Cannot insert explicit value for identity column in table '%1!' when IDENTITY_INSERT is set to OFF.
	An explicit value for the identity column in table '%1!' can only be specified
	Table '%1!' does not have the identity property. Cannot perform SET operation.
	Operand data type %1! is invalid for %2! operator.
	Ambiguous column name '%.*ls'.
	Invalid column name '%.*ls'.
	Column "%1!.%2!" is invalid in the ORDER BY clause
	Procedure or function %1! has too many arguments specified.
	Could not find stored procedure '%1'.
	%1! is not a valid style number when converting from datetime to a character string.
	Invalid object name '%1!'.
	A TOP N value may not be negative.
	There is already an object named '%1!' in the database.
	A domain error occurred.
	Cannot update identity column '%1!'.
	Cannot define PRIMARY KEY constraint on nullable column in table '%1!'.
	Cannot add multiple PRIMARY KEY constraints to table '%1!'.
	Table '%1!'' already has a primary key defined on it.
	The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
	Divide by zero error encountered.
	Arithmetic overflow error for data type %1!, value = %2!.
	Conversion failed when converting datetime from character string.
	Missing end comment mark '*/'.
	SET DATEFIRST %1! is out of range.
	SET DATEFORMAT date order 'mmy' is invalid.
	Percent values must be between 0 and 100.
	ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
	A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
	Cannot assign a default value to a local variable.
	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.
	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 variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.
	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.
	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.
	Must declare the variable '%.*ls'.
	The column prefix '%.*ls' does not match with a table name or alias name used in the query.
	The ORDER BY position number %ld is out of range of the number of items in the select list.
	Unclosed quotation mark before the character string '%.*ls'.
	Line %d: Incorrect syntax near '%.*ls'.