Category: SQL Server
Column Alias in SQL Query
When returning the query results , you want to provide an alternate name for the column for readability purpose , you can use the AS clause to specify the column alias in SQL Query. How to specify Column alias in SQL Query ? Below is an example of the usage of the column alias in SQL Query. Every column in the Query result has a…
SQL Server Error Code – 7371 the server option ‘collation name’ in li
In this blog post, you’ll learn more about the SQL Server Error Code 7371 and the error message description that is shown SQL Server Error Code 7371 SQL Server Error Description for the Code :7371 The server option ‘collation name’ in linked server ‘%ls’ for OLE DB provider ‘%ls’ has collation id %08x which is not supported by SQL Server.
SQL Server Error Code – 12805 index name ‘%.*ls’ is too long. maximum
In this blog post, you’ll learn more about the SQL Server Error Code 12805 and the error message description that is shown SQL Server Error Code 12805 SQL Server Error Description for the Code :12805 Index name ‘%.*ls’ is too long. Maximum length for temp table index name is %d characters.
SQL Server Error Code – 10704 to rethrow an error, a throw statement m
In this blog post, you’ll learn more about the SQL Server Error Code 10704 and the error message description that is shown SQL Server Error Code 10704 SQL Server Error Description for the Code :10704 To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.
SQL Server Error Code – 13559 cannot insert rows in a temporal history
In this blog post, you’ll learn more about the SQL Server Error Code 13559 and the error message description that is shown SQL Server Error Code 13559 SQL Server Error Description for the Code :13559 Cannot insert rows in a temporal history table ‘%.*ls’.
SQL Server Error Code – 18355 reason: failed attempted retry of a proc
In this blog post, you’ll learn more about the SQL Server Error Code 18355 and the error message description that is shown SQL Server Error Code 18355 SQL Server Error Description for the Code :18355 Reason: Failed attempted retry of a process token validation.
SQL Server Error Code – 29320 communication involving configuration ma
In this blog post, you’ll learn more about the SQL Server Error Code 29320 and the error message description that is shown SQL Server Error Code 29320 SQL Server Error Description for the Code :29320 Communication involving configuration manager and agent cannot be initialized due to error %d, state %d, severity %d.
SQL Server Error Code – 35464 columnstore indexes are not supported in
In this blog post, you’ll learn more about the SQL Server Error Code 35464 and the error message description that is shown SQL Server Error Code 35464 SQL Server Error Description for the Code :35464 columnstore indexes are not supported in the current SQL Server edition. See SQL Server Books Online for supported editions
SQL Server Error Code – 40702 failed to parse xml rules.
In this blog post, you’ll learn more about the SQL Server Error Code 40702 and the error message description that is shown SQL Server Error Code 40702 SQL Server Error Description for the Code :40702 Failed to parse XML rules.
SQL Server Error Code – 40951 the dns alias ‘%.*ls’ does not exist for
In this blog post, you’ll learn more about the SQL Server Error Code 40951 and the error message description that is shown SQL Server Error Code 40951 SQL Server Error Description for the Code :40951 The Dns Alias ‘%.*ls’ does not exist for the elastic pool ‘%.*ls’ on server ‘%.*ls’.
SQL Server Error Code – 10032 cannot return multiple result sets (not
In this blog post, you’ll learn more about the SQL Server Error Code 10032 and the error message description that is shown SQL Server Error Code 10032 SQL Server Error Description for the Code :10032 Cannot return multiple result sets (not supported by the provider).
SQL Server Error Code – 10307 the fillrowmethodname property of sqlfun
In this blog post, you’ll learn more about the SQL Server Error Code 10307 and the error message description that is shown SQL Server Error Code 10307 SQL Server Error Description for the Code :10307 The FillRowMethodName property of SqlFunctionAttribute does not contain a valid method name.