Sql Error #8161, Severity 15

Sql Error Number:8161
Severity: 15

Description: A grouping function argument does not match any of the expressions in the GROUP BY clause.

Possibly related links:

Troubleshooting GROUP BY Errors
... does not appear as an argument of another grouping function or aggregate. ... function does not match any of the expressions in the GROUP BY clause. ...

Errors 8000 - 8999
... not contained in either an aggregate function or the GROUP ... A grouping function argument does not match any of the expressions in the GROUP BY clause. ...

Microsoft Beefs Up VBScript with Regular Expressions
Function. Only match the beginning of a string. "^A" matches first "A" in "An A+ for Anita. ... Grouping a clause to create a clause. May be nested. "( ab)?(c) ...

SQLGetInfo Function
... source supports expressions in the ORDER BY list; "N" if it does not. ... If none of the options is supported, the GROUP BY clause is not supported by the ...

SQLGetInfo Function
... source supports expressions in the ORDER BY list; "N" if it does not. ... If none of the options is supported, the GROUP BY clause is not supported by the ...

Errors 8000 - 8999
A GROUPING or GROUPING_ID function can only be specified ... Argument %d of the %.*ls function does not match any of the expressions in the GROUP BY clause. ...

SQL Server 2005 Beta 2 Transact-SQL Enhancements
... use the PARTITION BY clause and specify a list of expressions that identify ... to the first (EmpOrdersCTE); the third (NumsCTE) does not refer to any CTE. ...

Query Processor Errors
The count of column names and source expressions do not match. ... In aggregate and grouping expressions, the ORDER BY clause can contain only ...

Engine Errors
The specified password does not match the database password. Not applicable ... In aggregate and grouping expressions, the ORDER BY clause can contain only ...

International Features in Microsoft SQL Server 2005
... batch, a function or stored procedure, or an argument of a function or stored ... Any locale that does not have a supported, unique Unicode collation should use ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8160, Severity 15

Sql Error Number:8160
Severity: 15

Description: A grouping function can only be specified when either CUBE or ROLLUP is specified in the GROUP BY clause.

Possibly related links:

Errors 8000 - 8999
A grouping function can only be specified when either CUBE or ROLLUP is specified in the GROUP BY clause. ... A grouping function argument does not match any ...

SELECT
... can only be specified if an ORDER BY clause is specified. < select_list > ... A maximum of 10 grouping expressions is permitted when CUBE or ROLLUP is specified. ...

SELECT
... can only be specified if an ORDER BY clause is specified. < select_list > ... A maximum of 10 grouping expressions is permitted when CUBE or ROLLUP is specified. ...

Errors 8000 - 8999
A GROUPING or GROUPING_ID function can only be specified when there is a GROUP BY clause. ... clause unless it is contained in either an aggregate function or ...

SELECT Examples
... group does not include any rows that meet the qualification specified in the WHERE clause. ... The GROUPING function can be used only with CUBE or ROLLUP. ...

SELECT Examples
... group does not include any rows that meet the qualification specified in the WHERE clause. ... The GROUPING function can be used only with CUBE or ROLLUP. ...

Improving Performance with SQL Server 2000 Indexed Views
Must not contain HAVING, CUBE, or ROLLUP. ... clustered index can reference only the columns specified in the GROUP BY clause. ...

Introduction to New T-SQL Programmability Features in SQL Server 2008
The SWITCHOFFSET function adjusts an input DATETIMEOFFSET value to a specified ... are: the GROUPING SETS, CUBE, and ROLLUP subclauses of the GROUP BY clause and ...

Summary Rows in DataGrid Controls
... function that works in conjunction with ROLLUP in the body of a GROUP BY clause. ... according to the order in which the grouping columns are specified. ...

Glossary
... cube, the set of properties, including a value, specified ... A character encoding in which the code points can be either 1 or 2 bytes. download-only article ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8159, Severity 15

Sql Error Number:8159
Severity: 15

Description: '%.*ls' has fewer columns than were specified in the column list.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8158, Severity 15

Sql Error Number:8158
Severity: 15

Description: '%.*ls' has more columns than were specified in the column list.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8156, Severity 15

Sql Error Number:8156
Severity: 15

Description: The column '%.*ls' was specified multiple times for '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8155, Severity 15

Sql Error Number:8155
Severity: 15

Description: No column was specified for column %d of '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8154, Severity 15

Sql Error Number:8154
Severity: 15

Description: The table '%.*ls' is ambiguous.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8153, Severity 10

Sql Error Number:8153
Severity: 10

Description: Warning: Null value is eliminated by an aggregate or other SET operation.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8152, Severity 16

Sql Error Number:8152
Severity: 16

Description: String or binary data would be truncated.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8151, Severity 16

Sql Error Number:8151
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8150, Severity 16

Sql Error Number:8150
Severity: 16

Description: Multiple NULL constraints were specified for column '%.*ls', table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8149, Severity 16

Sql Error Number:8149
Severity: 16

Description: OLE Automation objects are not supported in fiber mode.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8148, Severity 16

Sql Error Number:8148
Severity: 16

Description: More than one column %ls constraint specified for column '%.*ls', table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8147, Severity 16

Sql Error Number:8147
Severity: 16

Description: Could not create IDENTITY attribute on nullable column '%.*ls', table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8146, Severity 16

Sql Error Number:8146
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8145, Severity 16

Sql Error Number:8145
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8144, Severity 16

Sql Error Number:8144
Severity: 16

Description: Procedure or function %.*ls has too many arguments specified.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8143, Severity 16

Sql Error Number:8143
Severity: 16

Description: Parameter '%.*ls' was supplied multiple times.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8141, Severity 16

Sql Error Number:8141
Severity: 16

Description: Column %ls constraint for column '%.*ls' references another column, table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8140, Severity 16

Sql Error Number:8140
Severity: 16

Description: More than one key specified in column level %ls constraint, table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8139, Severity 16

Sql Error Number:8139
Severity: 16

Description: Number of referencing columns in foreign key differs from number of referenced columns, table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8138, Severity 16

Sql Error Number:8138
Severity: 16

Description: More than 16 columns specified in foreign key column list, table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8137, Severity 16

Sql Error Number:8137
Severity: 16

Description: Illegal use of xml data type method '%.*ls'. A non-mutator method is expected in this context.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8136, Severity 16

Sql Error Number:8136
Severity: 16

Description: Duplicate columns specified in %ls constraint key list, table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8135, Severity 16

Sql Error Number:8135
Severity: 16

Description: Table level constraint does not specify column list, table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8134, Severity 16

Sql Error Number:8134
Severity: 16

Description: Divide by zero error encountered.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8133, Severity 16

Sql Error Number:8133
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8132, Severity 10

Sql Error Number:8132
Severity: 10

Description: Extended stored procedure DLL '%s' reports its version is %d.%d. The expected version is %d.%d.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8131, Severity 10

Sql Error Number:8131
Severity: 10

Description: Extended stored procedure DLL '%s' does not export __GetXpVersion(). Refer to the topic "Backward Compatibility Details (Level 1) - Open Data Services" in the documentation for more information.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8129, Severity 16

Sql Error Number:8129
Severity: 16

Description: The new disk size must be greater than %d. Consider using DBCC SHRINKDB.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8128, Severity 10

Sql Error Number:8128
Severity: 10

Description: Using '%s' version '%s' to execute extended stored procedure '%s'. This is an informational message only; no user action is required.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8127, Severity 16

Sql Error Number:8127
Severity: 16

Description: Column "%.*ls.%.*ls" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8126, Severity 16

Sql Error Number:8126
Severity: 16

Description: Column "%.*ls.%.*ls" is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8125, Severity 16

Sql Error Number:8125
Severity: 16

Description: An aggregated expression containing an outer reference must be contained in either the select list, or a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8124, Severity 16

Sql Error Number:8124
Severity: 16

Description: Multiple columns are specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8123, Severity 16

Sql Error Number:8123
Severity: 16

Description: A correlated expression is invalid because it is not in a GROUP BY clause.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8121, Severity 16

Sql Error Number:8121
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8120, Severity 16

Sql Error Number:8120
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8119, Severity 16

Sql Error Number:8119
Severity: 16

Description: Column '%.*ls.%.*ls' is invalid in the HAVING clause because it is not contained in an aggregate function and there is no GROUP BY clause.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8118, Severity 16

Sql Error Number:8118
Severity: 16

Description: Column '%.*ls.%.*ls' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8117, Severity 16

Sql Error Number:8117
Severity: 16

Description: Operand data type %ls is invalid for %ls operator.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8116, Severity 16

Sql Error Number:8116
Severity: 16

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

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8115, Severity 16

Sql Error Number:8115
Severity: 16

Description: Arithmetic overflow error converting %ls to data type %ls.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8114, Severity 16

Sql Error Number:8114
Severity: 16

Description: Error converting data type %ls to %ls.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8113, Severity 16

Sql Error Number:8113
Severity: 16

Description: Illegal use of xml data type method '%.*ls'. A mutator method is expected in this context.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8112, Severity 16

Sql Error Number:8112
Severity: 16

Description: Cannot add more than one clustered index for constraints on table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8111, Severity 16

Sql Error Number:8111
Severity: 16

Description: Cannot define PRIMARY KEY constraint on nullable column in table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8110, Severity 16

Sql Error Number:8110
Severity: 16

Description: Cannot add multiple PRIMARY KEY constraints to table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8109, Severity 16

Sql Error Number:8109
Severity: 16

Description: Attempting to add multiple identity columns to table '%.*ls' using the SELECT INTO statement.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #8107, Severity 16

Sql Error Number:8107
Severity: 16

Description: IDENTITY_INSERT is already ON for table '%.*ls.%.*ls.%.*ls'. Cannot perform SET operation for table '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!