Category: SQL Server
SQL Server Error Code – 16113 sensitivity rank must not be provided as
In this blog post, you’ll learn more about the SQL Server Error Code 16113 and the error message description that is shown SQL Server Error Code 16113 SQL Server Error Description for the Code :16113 Sensitivity rank must not be provided as string.
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 – 13925 cannot drop or disable index or constrai
In this blog post, you’ll learn more about the SQL Server Error Code 13925 and the error message description that is shown SQL Server Error Code 13925 SQL Server Error Description for the Code :13925 Cannot drop or disable index or constraint ‘%.*s’ because the last unique index or constraint on ‘%.*s’ cannot be dropped or disabled.
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 – 8129 the new disk size must be greater than %
In this blog post, you’ll learn more about the SQL Server Error Code 8129 and the error message description that is shown SQL Server Error Code 8129 SQL Server Error Description for the Code :8129 The new disk size must be greater than %d. Consider using DBCC SHRINKDB.
SQL Server Error Code – 15131 usage: sp_dbremove [,dropdev]
In this blog post, you’ll learn more about the SQL Server Error Code 15131 and the error message description that is shown SQL Server Error Code 15131 SQL Server Error Description for the Code :15131 Usage: sp_dbremove [,dropdev]
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…
SQL Server Error Code – 21084 publication ‘%s’ does not allow anonymou
In this blog post, you’ll learn more about the SQL Server Error Code 21084 and the error message description that is shown SQL Server Error Code 21084 SQL Server Error Description for the Code :21084 Publication ‘%s’ does not allow anonymous subscriptions.
SQL Server Error Code – 21532 cannot add a data definition language tr
In this blog post, you’ll learn more about the SQL Server Error Code 21532 and the error message description that is shown SQL Server Error Code 21532 SQL Server Error Description for the Code :21532 Cannot add a data definition language trigger for replicating ‘%.*ls’ events.
SQL Server Error Code – 40975 partner managed instance’s dns zone does
In this blog post, you’ll learn more about the SQL Server Error Code 40975 and the error message description that is shown SQL Server Error Code 40975 SQL Server Error Description for the Code :40975 Partner managed instance’s DNS Zone does not match the DNS Zone of the source managed instance.
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…