Latest SQL Server 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.
	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
	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 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?
	Error messages when you try to process a database or a cube in SQL Server 2005 Analysis Services: "The attribute key cannot be found" and "The record was skipped because the attribute key was not found"
	How to Eliminate Unions After a Lookup Operation
	How to Integrate Performance Monitor and SQL Profiler
	SSIS Lookups are Case Sensitive
	Convert Number to Words in SSRS
	After installing SP2 on SQL Server 2005 x64, when trying to open existing SSIS package or try to add data component to a new SSIS package, is giving error saying that designer could not be initialised.
	Remote Name Could not be Resolved in SQL Server Reporting Services
	Database Mirror Certificate Expired
	How to Generate an Auto Incremental Number in a SSIS Package?
	How to replicate more than 256 articles in Merge Replication?
	Unable to Enlist in the Transaction
	XML Error when Opening SSIS Packages
	SQL Server 2005 - clients using native client, should clients be upgrade as well
	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
	How to Configure Multiple SQL Server Reporting Service Instances on the Same Computer
	Error When Configuring SSRS Database
	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.
	How to Access a Map Drive from SSIS ?
	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!'.
	How can I force SQL Server 2005 logins to change their passwords periodically?
	What permission does the user need to run PROFILER in SQL Server 2005?
	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.
	Microsoft SQL Sever management Studio: Failed to open connection dialog.
	Experiencing a major performance loss with an Indexed view that is using a INDEX SCAN on a table inspite of relevant clustered indexes on the joined tables?
	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.
	How can I drop all the instances attached to one Database?
	We are unable to install SQL Server 2005 on additional node on top existing cluster setup running Windows 2003 x64 bit operating system?
	How can I confirm whether a SQL Server installation is 32 or x64 bit?
	How to set up database diagram in SQL Server Management Studio Express?
	In SQL Server 2005 how to determine the role memberships and the permissions associated with login yy?
	Using SQL Server 2005 how to find a user or login that has the db_owner role in any database?
	IN SQL Server 2005, how do I backup the sys.asymmetric_keys and sys.symmetric_keys tables?
	Using SQL Server 2005 cannot Connect to a Remote SSIS Server?
	How to resolve SQL Server Management Studio error: 'Could not load file or assembly 'SqlManagerUI ...'?
	For optimum security, is it recommended to use a single domain account the SQL Server instances in a network?
	What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?
	SQL Server Memory Usage Grows and Not Shrinks
	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.
	How to disable database mirroring for a particular database?
	What is the best way to test the upgrade process from SQL Server 7.0 or 2000 to SQL Server 2005, before I perform the actual upgrade?
	What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename SA account in SQL Server 2005?
	Why can't I install multiple instances of SQL Server Integration Services components on the same physical server?
	In SQL Server 2005, when I'm trying to open the Database Maintenance Wizard, I get an error message telling me that "Agent XPs" are not running. How can I resolve this problem, and what are "Agent XPs?"
	What is the purpose of the Surface Area Configuration Tool in SQL Server 2005?
	How can I enable xp-cmdshell on a SQL Server 2005 instance?
	How to view properties when trying to view the same index details in SQL Server Management Studio ?
	How to hide databases in SQL Server Management Studio from unauthorised users?
	What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the Transaction log?
	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'.
	SQL Server Management Studio takes a long time to load, how to improve the load performance of this tool?
	When using SQL Server Management Studio Express I get the error "SQL Server does not allow remote connections". How to resolve this error?
	Is it possible to set the database name in advance when deploying client database with an installer option?
	How do I get the taskpad view in SQL Server Management Studio as it was in SQL Server 2000 version?
	Which edition of SQL Server 2005 is better, the Standard Edition or the Enterprise Edition?
	Line %d: Incorrect syntax near '%.*ls'.
	How to allow access to non sysadmin users to view status of sysadmin owned scheduled jobs?
	Performance delay when a full-text query is executed on a SQL Server with no connection to Internet.
	Managing SQL Server 2005 Express installation & FAQ.
	Reporting Services 2000: Database changes are not updated when exported to Excel?
	DTS package error "Cannot find specified package in the storage location specified".
	Unable to install Service Pack 1 for SQL Server 2005 version.
	How to get resource usage of an executing query in SQL Server without using SYSMON/PERFMON utility?
	Is it a good practice to use SQL Server stored procedures for INSERT, UPDATE, and DELETE statements?
	What happens when my integer IDENTITY runs out of scope?
	How can you use IIf in Transact-SQL?
	How do you determine the Nth row in a SQL Server database?
	Why doesn't ISNUMERIC() always produce the results you expect?
	How do you display NULL values at the end of a resultset?
	How can I determine the maximum value for each data? And which option provides the best performance?
	How do you mimic Access' Ignore Null index behavior in SQL Server?
	Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?
	How do you get rid of users that are already in the database on the backup server when a restore starts?
	Should we automatically reboot our SQL Servers on a weekly basis?
	Why do I get an unordered resultset, although my table has a clustered index?
	Can I downgrade my SQL Server databases to an earlier version?
	How do you create trigger on system tables?
	How do I find the most frequently occurring value for all data in a table? How do I find that value per group?
	My manager has asked me to put together a plan for a backup server for our production server running SQL Server. Should I use log shipping or clustering?
	What are the implications of server clustering on replication?
	How do I change the IP addresses of clustered SQL Servers?
	We are planning a new SQL cluster. We intend to have the two servers separated by 100 meters. Will the cluster's shared disk array be a single point of failure for us?
	We have a SQL Server 2000 cluster. I have been trying to get SQLMail to work with it, but have failed. What am I doing wrong?
	Does a SQL Server cluster support load balancing?
	I am having a problem installing an Active/Active SQL Server cluster.
	I have a question on how to uninstall a SQL Server 2000 instance installation from a Windows 2000 cluster.
	Is it advisable to run both Terminal Services (application mode) and SQL Server on the same cluster together?
	I am trying to backup my databases from my clustered shared array to a local disk, but I can't see the local disk when I run the Backup Wizard. Why?
	We have five SQL Servers and want to not only upgrade, but to cluster these servers as well.
	How do I deal with a SQL Server cluster that is not acting properly?
	How can I create a cluster out of two independent SQL Server boxes?
	Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously?
	Is clustering, log shipping, or replication the best option for high SQL Server availability?
	How do you restore the master database on a SQL Server cluster?
	I want to add an identity or unique identifier column to a table in order to ensure that each row is unique. For best performance, which one should I use?
	I don't know how to transfer an array to a table, and I even if I can, I don't know if it will be any faster than using INSERT INTO?
	How do I estimate how large a database will grow?
	I've been under the impression that joins are costly and should be kept to a minimum. Is this true?
	Since functions are not pre-compiled, is there any performance gain from using user-defined functions as opposed to stored procedures?
	I would like some input on the best, most efficient way to store images for use on a website.
	Can you provide some ways that I might be able to avoid using cursors in my applications?
	Can the use of NULLS in a database affect performance?
	In my stored procedures I have the option of calling the same data from either a table or a view. For best performance, should I be calling a table or a view?
	I don't like to delete records in our production database, even though we will never need them again. Does this affect performance?
	Should I use the old Microsoft JOIN syntax, or the ANSI JOIN syntax for the best JOIN performance?
	Is is more efficient to use SELECT DISTINCT or GROUP BY to perform the same function?
	My application makes heavy use of temp tables. Should I be creating temp tables as needed, or should I be using a permanent table over and over instead?
	Which is faster when using SQL Server 2000 or 2005, temp tables or the table datatype?
	Does SQL Server support table partitioning?
	When creating temp tables within a stored procedure, is it good practice to drop them as soon as they are no longer required?
	Is there any performance difference between using SET or SELECT to assign values in Transact-SQL?
	Can you tell me more about the processor queue length?
	Is there any way to allocate processor utilization to SQL Server jobs?
	Is it better to have one large server running multiple databases, or several smaller servers running one database each?
	Is there any benefit for me in turning on the "lightweight pooling" SQL Server configuration option?
	Is there a practical limit to the size of a table I can pin into memory?
	Why isn't my SQL Server taking full advantage of all the RAM I have available in my server?
	We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?
	In Performance Monitor, there is an object called Network Interface. What does it mean and under what circumstances would you use it?
	Our SQL Server is experiencing lots of blocking, but we don't have any resource bottlenecks.
	We have a growing population of Access users. My question is whether there is a way of lowering these user's priorities on our SQL Server?
	Is it recommended to install SQL Server on a Windows domain controller?
	My question is how do I move already existing log files in a different drive, or how can I separate data files and log files into different drives?
	I am having a problem with table locking that is causing concurrency problems.
	Why is it better to use RAID 1 for the operating system, SQL Server binaries, and the swap file? What advantages does RAID 1 have over RAID 5?
	In the past couple of weeks, my SQL Server seems to be running slower. Queries just don't seem to run as fast. What should I do?
	Will placing the MDF files and the LDF files on two different physical hard drives help performance?
	I need help to justify new hardware for our SQL Server.
	Is it a good idea to run both SQL Server and IIS on the same physical server?
	We have five SQL servers running on different physical servers. What are the downfalls for combining these SQL servers onto a single physical server?
	When I run a stored procedure in Query Analyzer, it runs in about two minutes. But if I execute the same stored procedure as a job, it runs several hours.
	Do you have a recommendation for the maximum number of databases you can place on a single SQL Server?
	Is it normal for the buffer cache size to vary throughout the day?
	Is there a way to control which CPU performs what tasks in SQL Server?
	We have a started experiencing a performance issue with a table that has now grown to over 600,000 rows.
	Should I schedule the indexes in my SQL Server databases to be rebuilt before or after the statistics on my tables are updated (or does it matter)?
	We have had some performance problems with a server that is running Terminal Services, SQL Server, and Access databases.
	How can I help identify the worst performing queries in my SQL Server database application?
	We have an IBM Netfinity server with two network cards. One network connection changes from 100MBs to 10MBs. Is this normal?
	How many indexes can I add to the table before performance degrades?
	T-SQL code in script run faster than it does as a stored procedure. Why?
	A view runs on our development server in 30 seconds, but it takes over 10 minutes on the production server. Why?
	For best performance, should we install Analysis Service and the cubes as the same server as the production database?
	Can I programatically tell SQL Server how to allocate CPU resources?
	When should primary keys be used?
	Our query used to take 30 seconds, and now it takes over 30 minutes. Why?
	When I upgraded by database to the newest version, performance is now much slower. Why?
	We have two stored procedures taking five minutes to run in our development database, but the same stored procedures run quickly on our QA database. Why?
	Is there any option to release the additional memory that has been used by SQL Server after a query is completed?
	Is there a way to configure memory cache or buffers per database?
	I'm a newbie to SQL Server performance monitoring. With all the information on your website, I don't know where to start.
	I am hoping that you may be able to assist me in evaluating the needs of our school district that is purchasing a software package that uses SQL Server as the backend database.
	We run an ERP program that uses SQL Server as the backend database. Does how the ERP program is designed and written affect its performance with SQL Server?
	What are the pros and cons of running more than one instance of SQL Server on a single physical server?
	What is the difference between a table and index scan in an execution plan?
	Why does a query executed from VB run more slowly than when run from Query Analyzer?
	Why does the performance of some queries vary so widely?
	Why doesn't query parellelism use all of the available CPUs?
	What is the difference between SQL Server 2000 standard and enterprise editions?
	Should I use CPU or elapsed time to measure query performance?
	How can I determine if a table is pinned in SQL Server memory or not?
	The tempdb database grows so large I run out of disk space. What can I do?
	How can I capture performance data over time, and review it later?
	At what point should I worry about page splits, and what can I do to help reduce them?
	DBCC INDEXDEFRAG doesn't seem to work like it should.
	Each night we have to run a job that takes about 10 hours to complete. As it runs, it uses 100% of the CPU. What can I do?
	How do I know if my table has redundant indexes?
	Why do I get error messages when my SQL Server is running under a heavy load.
	Are more CPUs better than fewer CPUs for the best performance from SQL Server?
	Why is my Memory: pages/sec counter exceeding 20 for my SQL Server?
	When should I include the WITH RECOMPILE option when creating a stored procedure?
	How do I restore a Master Database in a SQL Server 7.0 or 2000 clustering environment?
	Is there any significant performance difference when joining tables across different databases on the same server?
	Does running the SQL Server Index Wizard or the Database Engine Tuning Advisor find all of the tables in my database that need indexing?
	My application is very INSERT heavy. What can I do to speed up the performance of INSERTs?
	My SQL Server seems to take memory from the operating system, but never releases it. Is this normal?
	Is it possible to keep the entire database in memory?
	What is the difference between DELETE and TRUNCATE? Is one faster than the other?
	What happens during the rebuild of a clustered index?
	What happens when SQL Server executes a stored procedure or query ?
	Why can it take so long to drop a clustered index?