Category: SQL Server

SQL Server Error Code – 5252 file id %d of database id %d cannot be s

In this blog post, you’ll learn more about the SQL Server Error Code 5252 and the error message description that is shown SQL Server Error Code 5252 SQL Server Error Description for the Code :5252 File ID %d of database ID %d cannot be shrunk to the expected size. The high concurrent workload is leading to too many deadlocks during the shrink operation.   Re-run the…

SQL Server Error Code – 14022 the @property parameter value must be ei

In this blog post, you’ll learn more about the SQL Server Error Code 14022 and the error message description that is shown SQL Server Error Code 14022 SQL Server Error Description for the Code :14022 The @property parameter value must be either  ‘description’, ‘sync_object’, ‘type’, ‘ins_cmd’, ‘del_cmd’, ‘upd_cmd’, ‘filter’, ‘dest_table’, ‘dest_object’, ‘creation_script’, ‘pre_creation_cmd’, ‘status’, ‘schema_option’, or ‘destination_owner’.

SQL Server Error Code – 40105 the local partition map for database %.*

In this blog post, you’ll learn more about the SQL Server Error Code 40105 and the error message description that is shown SQL Server Error Code 40105 SQL Server Error Description for the Code :40105 The local partition map for database %.*ls is starting up in reduced functionality mode because of log full. Pending partition deletes will not be processed until the log is truncated.