Category: SQL Server

SQL Server Error Code – 21814 ddl replication failed to refresh custom

In this blog post, you’ll learn more about the SQL Server Error Code 21814 and the error message description that is shown SQL Server Error Code 21814 SQL Server Error Description for the Code :21814 DDL replication failed to refresh custom procedures, please run “exec sp_register_custom_scripting ‘CUSTOM_SCRIPT’, your_script, ‘%s’, ‘%s’ “and try again

SQL Server Error Code – 20695 only %ld out of %ld rows were updated in

In this blog post, you’ll learn more about the SQL Server Error Code 20695 and the error message description that is shown SQL Server Error Code 20695 SQL Server Error Description for the Code :20695 Only %ld out of %ld rows were updated in the batched update procedure for table %s; other rows could not be updated because they have been deleted. No action is…

SQL Server Error Code – 21389 warning: only subscribers running sql se

In this blog post, you’ll learn more about the SQL Server Error Code 21389 and the error message description that is shown SQL Server Error Code 21389 SQL Server Error Description for the Code :21389 Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because column-level collation is scripted out with the article schema creation script.

SQL Server Error Code – 3936 the transaction could not be committed b

In this blog post, you’ll learn more about the SQL Server Error Code 3936 and the error message description that is shown SQL Server Error Code 3936 SQL Server Error Description for the Code :3936 The transaction could not be committed because an error occurred while tyring to flush FILESTREAM data to disk. A file may have been open at commit time or a disk…

How to remove a column from an existing table in SQL Server?

Use the DDL (Data definition language) query to remove a column from an existing table in SQL Server. How to remove a column from an existing table in SQL Server? ALTER command will allow the user to remove a column from the table. Syntax to remove the column from the table. ALTER TABLE <tablename> DROP COLUMN <columnname>; For example , assume that you have a…

SQL Server Error Code – 7986 system table pre-checks: object id %d ha

In this blog post, you’ll learn more about the SQL Server Error Code 7986 and the error message description that is shown SQL Server Error Code 7986 SQL Server Error Description for the Code :7986 System table pre-checks: Object ID %d has cross-object chain linkage. Page %S_PGID points to %S_PGID in alloc unit ID %I64d (should be %I64d). Check statement terminated due to unrepairable error.

SQL Server Error Code – 9715 the conversation endpoint with conversat

In this blog post, you’ll learn more about the SQL Server Error Code 9715 and the error message description that is shown SQL Server Error Code 9715 SQL Server Error Description for the Code :9715 The conversation endpoint with conversation handle ‘%ls’ is in an inconsistent state. Check the SQL Server error logs and the operating system error log for information on possible hardware problems….