Category: SQL Server
SQL Server Error Code – 26022 server is listening on [ %s %d].
In this blog post, you’ll learn more about the SQL Server Error Code 26022 and the error message description that is shown SQL Server Error Code 26022 SQL Server Error Description for the Code :26022 Server is listening on [ %s %d].
SQL Server Error Code – 1470 the alter database for this partner conf
In this blog post, you’ll learn more about the SQL Server Error Code 1470 and the error message description that is shown SQL Server Error Code 1470 SQL Server Error Description for the Code :1470 The alter database for this partner config values may only be initiated on the current principal server for database ?%.*ls?.
SQL Server Error Code – 21017 cannot perform sql server 7.0 compatible
In this blog post, you’ll learn more about the SQL Server Error Code 21017 and the error message description that is shown SQL Server Error Code 21017 SQL Server Error Description for the Code :21017 Cannot perform SQL Server 7.0 compatible checksum operation on a merge article that has a vertical or horizontal partition. Rowcount validation and SQL Server 2000 compatible binary checksum operation can…
SQL Server Error Code – 9613 the queue ‘%.*ls’ cannot be activated be
In this blog post, you’ll learn more about the SQL Server Error Code 9613 and the error message description that is shown SQL Server Error Code 9613 SQL Server Error Description for the Code :9613 The queue ‘%.*ls’ cannot be activated because the activation user is not specified.
SQL Server Error Code – 33438 cannot enable change tracking on the fil
In this blog post, you’ll learn more about the SQL Server Error Code 33438 and the error message description that is shown SQL Server Error Code 33438 SQL Server Error Description for the Code :33438 Cannot enable Change Tracking on the FileTable ‘%.*ls’. Change Tracking is not supported for FileTable objects.
SQL Server Error Code – 35486 memory optimized tables that have a colu
In this blog post, you’ll learn more about the SQL Server Error Code 35486 and the error message description that is shown SQL Server Error Code 35486 SQL Server Error Description for the Code :35486 memory optimized tables that have a column store index
SQL Server Error Code – 2327 %sthe content or definition of is
In this blog post, you’ll learn more about the SQL Server Error Code 2327 and the error message description that is shown SQL Server Error Code 2327 SQL Server Error Description for the Code :2327 %sThe content or definition of is missing.
SQL Server Error Code – 2762 sp_setapprole was not invoked correctly.
In this blog post, you’ll learn more about the SQL Server Error Code 2762 and the error message description that is shown SQL Server Error Code 2762 SQL Server Error Description for the Code :2762 sp_setapprole was not invoked correctly. Refer to the documentation for more information.
SQL Server Error Code – 12308 table-valued functions are not supported
In this blog post, you’ll learn more about the SQL Server Error Code 12308 and the error message description that is shown SQL Server Error Code 12308 SQL Server Error Description for the Code :12308 Table-valued functions are not supported with %S_MSG.
SQL Server Error Code – 21668 the constraint “%s” was not created beca
In this blog post, you’ll learn more about the SQL Server Error Code 21668 and the error message description that is shown SQL Server Error Code 21668 SQL Server Error Description for the Code :21668 The constraint “%s” was not created because one or more columns in the constraint is not published. Either include all columns in the published article, or alter the constraint to…
SQL Server Error Code – 22512 cannot use partition groups with unfilte
In this blog post, you’ll learn more about the SQL Server Error Code 22512 and the error message description that is shown SQL Server Error Code 22512 SQL Server Error Description for the Code :22512 Cannot use partition groups with unfiltered publications. Set “use_partition_groups” to “false” using sp_changemergepublication.
SQL Server Error Code – 41502 failed to deregister client (id %ls) fro
In this blog post, you’ll learn more about the SQL Server Error Code 41502 and the error message description that is shown SQL Server Error Code 41502 SQL Server Error Description for the Code :41502 Failed to deregister client (ID %ls) from asynchronous operations administrator. The client has not registered with the administrator. Check that the specified client ID is correct, then retry the operation.
SQL Server Error Code – 45130 parameter “%ls” is invalid.
In this blog post, you’ll learn more about the SQL Server Error Code 45130 and the error message description that is shown SQL Server Error Code 45130 SQL Server Error Description for the Code :45130 Parameter “%ls” is invalid.
SQL Server Error Code – 21561 the value specified for parameter %s = %
In this blog post, you’ll learn more about the SQL Server Error Code 21561 and the error message description that is shown SQL Server Error Code 21561 SQL Server Error Description for the Code :21561 The value specified for parameter %s = %d is not valid.
SQL Server Error Code – 21792 the table ‘%s.%s’ already appears in the
In this blog post, you’ll learn more about the SQL Server Error Code 21792 and the error message description that is shown SQL Server Error Code 21792 SQL Server Error Description for the Code :21792 The table ‘%s.%s’ already appears in the transactional publication ‘%s’ on Publisher ‘%s’. The Oracle Gateway publishing option (the default) allows a table to be included as an article in…
SQL Server Error Code – 33239 an error occurred while auditing this op
In this blog post, you’ll learn more about the SQL Server Error Code 33239 and the error message description that is shown SQL Server Error Code 33239 SQL Server Error Description for the Code :33239 An error occurred while auditing this operation. Fix the error in the audit and then retry this operation.
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.