Category: SQL Server

Alias Names for Tables in SQL Query

There are times when you write query and end up qualifying the columns references by indicating the table name. For example , In the above query , the Department table is referred in the GroupName and Name column. Instead of mentioning the table table , we could provide a shortname or alias name for the table and use the alias name instead. The full use…

SQL Server Error Code – 2531 table error: object id %d, index id %d,

In this blog post, you’ll learn more about the SQL Server Error Code 2531 and the error message description that is shown SQL Server Error Code 2531 SQL Server Error Description for the Code :2531 Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) B-tree level mismatch, page %S_PGID. Level %d does not match level %d from…

SQL Server Error Code – 21778 cannot add publisher objects to the orac

In this blog post, you’ll learn more about the SQL Server Error Code 21778 and the error message description that is shown SQL Server Error Code 21778 SQL Server Error Description for the Code :21778 Cannot add Publisher objects to the Oracle Publisher for article ‘%s’. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS. Ensure that…

SQL Server Error Code – 22978 could not update the cdc.captured_column

In this blog post, you’ll learn more about the SQL Server Error Code 22978 and the error message description that is shown SQL Server Error Code 22978 SQL Server Error Description for the Code :22978 Could not update the cdc.captured_columns entry for column ‘%s’ of change table ‘%s’ to reflect a data type change in the corresponding column of the source table ‘%s’. Change Data…

SQL Server Error Code – 7348 the ole db provider “%ls” for linked ser

In this blog post, you’ll learn more about the SQL Server Error Code 7348 and the error message description that is shown SQL Server Error Code 7348 SQL Server Error Description for the Code :7348 The OLE DB provider “%ls” for linked server “%ls” could not set the range for table “%ls”. %ls. For possible cause of this issue, see the extended error message.