Category: SQL Server

SQL Server Error Code – 21381 cannot add (drop) column to table ‘%s’ b

In this blog post, you’ll learn more about the SQL Server Error Code 21381 and the error message description that is shown SQL Server Error Code 21381 SQL Server Error Description for the Code :21381 Cannot add (drop) column to table ‘%s’ because the table belongs to publication(s) with an active updatable subscription. Set @force_reinit_subscription to 1 to force reinitialization.

SQL Server Error Code – 21732 using data transformation services (dts)

In this blog post, you’ll learn more about the SQL Server Error Code 21732 and the error message description that is shown SQL Server Error Code 21732 SQL Server Error Description for the Code :21732 Using Data Transformation Services (DTS) packages in replication requires a password that is not NULL or empty. Specify a valid value for parameter ‘%s’.

SQL Server Error Code – 41072 the id of availability group ‘%.*ls’ in

In this blog post, you’ll learn more about the SQL Server Error Code 41072 and the error message description that is shown SQL Server Error Code 41072 SQL Server Error Description for the Code :41072 The ID of availability group ‘%.*ls’ in local data store does not exist in the Windows Server Failover Clustering (WSFC) data store.  The availability group may have been dropped but…

SQL Server Error Code – 3006 the differential backup is not allowed b

In this blog post, you’ll learn more about the SQL Server Error Code 3006 and the error message description that is shown SQL Server Error Code 3006 SQL Server Error Description for the Code :3006 The differential backup is not allowed because it would be based on more than one base backup. Multi-based differential backups are not allowed in the simple recovery model, and are…

SQL Server Error Code – 8661 cannot create the clustered index “%.*ls

In this blog post, you’ll learn more about the SQL Server Error Code 8661 and the error message description that is shown SQL Server Error Code 8661 SQL Server Error Description for the Code :8661 Cannot create the clustered index “%.*ls” on view “%.*ls” because the index key includes columns that are not in the GROUP BY clause. Consider eliminating columns that are not in…