Category: SQL Server

SQL Server Error Code – 21682 cannot publish table [%s].[%s]. the repl

In this blog post, you’ll learn more about the SQL Server Error Code 21682 and the error message description that is shown SQL Server Error Code 21682 SQL Server Error Description for the Code :21682 Cannot publish table [%s].[%s]. The replication administraive user requires an explicit SELECT grant, or a SELECT grant through PUBLIC, in order to publish this table. A role-based SELECT grant, if…

SQL Server Error Code – 4970 alter table switch statement failed. tar

In this blog post, you’ll learn more about the SQL Server Error Code 4970 and the error message description that is shown SQL Server Error Code 4970 SQL Server Error Description for the Code :4970 ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ has a table level check constraint ‘%.*ls’ but the source table ‘%.*ls’ does not have a corresponding constraint.

SQL Server Error Code – 8389 the all permission will be removed in a

In this blog post, you’ll learn more about the SQL Server Error Code 8389 and the error message description that is shown SQL Server Error Code 8389 SQL Server Error Description for the Code :8389 The ALL permission will be removed in a future version of SQL Server. Avoid using this permission in new development work and plan to modify applications that currently use it.

SQL Server Error Code – 21170 the specified subscriber cannot use tran

In this blog post, you’ll learn more about the SQL Server Error Code 21170 and the error message description that is shown SQL Server Error Code 21170 SQL Server Error Description for the Code :21170 The specified Subscriber cannot use transformable subscriptions using Data Transformation Services. Only SQL Server 2000, SQL Server 2005, and OLE DB Subscribers can use transformable subscriptions.