Category: SQL Server

SQL Server Error Code – 8183 only unique or primary key constraints c

In this blog post, you’ll learn more about the SQL Server Error Code 8183 and the error message description that is shown SQL Server Error Code 8183 SQL Server Error Description for the Code :8183 Only UNIQUE or PRIMARY KEY constraints can be created on computed columns, while CHECK, FOREIGN KEY, and NOT NULL constraints require that computed columns be persisted.

SQL Server Error Code – 17153 processor affinity turned on: node %d, p

In this blog post, you’ll learn more about the SQL Server Error Code 17153 and the error message description that is shown SQL Server Error Code 17153 SQL Server Error Description for the Code :17153 Processor affinity turned on: node %d, processor mask 0x%0*I64x. Threads will execute on CPUs per affinity settings. This is an informational message; no user action is required.

SQL Server Error Code – 41176 failed to acquire exclusive access to lo

In this blog post, you’ll learn more about the SQL Server Error Code 41176 and the error message description that is shown SQL Server Error Code 41176 SQL Server Error Description for the Code :41176 Failed to acquire exclusive access to local availability group configuration data (SQL OS error: %d).  If the problem persists, you might need to restart the instance of SQL Server.

SQL Server Error Code – 13769 setting system_versioning to on failed f

In this blog post, you’ll learn more about the SQL Server Error Code 13769 and the error message description that is shown SQL Server Error Code 13769 SQL Server Error Description for the Code :13769 Setting SYSTEM_VERSIONING to ON failed for table ‘%.*ls’ because ‘%.*ls’ with REMOTE_DATA_ARCHIVE enabled cannot be used as a history table when a finite retention period is specified.

SQL Server Error Code – 5520 upgrade of filestream container id %d in

In this blog post, you’ll learn more about the SQL Server Error Code 5520 and the error message description that is shown SQL Server Error Code 5520 SQL Server Error Description for the Code :5520 Upgrade of FILESTREAM container ID %d in the database ID %d failed because of container size recalculation error. Examine the previous errorlog entries for errors, and take the appropriate corrective…

SQL Server Error Code – 18053 error: %d, severity: %d, state: %d. (par

In this blog post, you’ll learn more about the SQL Server Error Code 18053 and the error message description that is shown SQL Server Error Code 18053 SQL Server Error Description for the Code :18053 Error: %d, Severity: %d, State: %d. (Params:%ls). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.