Site sponsored by: Idera Try Idera’s new SQL admin toolset
SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • 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

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...
Latest Articles

Slowly Changing Dimensions in SQL Server 2005
Audit Data Modifications
SQL Server 2008’s Management Data Warehouse
Same Report but Different Methods in SQL Server Reporting Services ...

More     

Latest SQL Server Error Messages FAQ's

 
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.