Tag: SQL Server Errors

SQL Server Error Msg 7340 – Cannot create a column accessor for OLE DB provider “%ls” for linked server “%ls”.

SQL Server Error Msg 35252 – The command can only be run on a secondary database. Connect to the correct secondary replica, and retry the command.

SQL Server Error Msg 22977 – Unable to update DDL history information to reflect columns changes applied to the tracked table associated with change table ‘%s’. Refer to previous errors in the current session to identify the cause and correct any associated problems.

SQL Server Error Msg 3624 – A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support.

SQL Server Error Msg 455 – The last statement included within a function must be a return statement.

SQL Server Error Msg 8917 – Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), index extents %I64d, pages %I64d, mixed extent pages %I64d.

SQL Server Error Msg 35485 – security policy

SQL Server Error Msg 5247 – Repair:  insert a secondary index row based on its base table row.

SQL Server Error Msg 18467 – The login failed for user “%.*ls”. The password change failed. The password does not meet the requirements of the password filter DLL. %.*ls

SQL Server Error Msg 1009 – The keyword DEFAULT is not allowed in DBCC commands.

SQL Server Error Msg 9328 – %sType specification expected, found ‘%ls’.

SQL Server Error Msg 1472 – The database mirroring connection terminated. Communications error sending message for database “%.*ls”.

SQL Server Error Msg 4916 – Could not enable or disable the constraint. See previous errors.

SQL Server Error Msg 33299 – Encryption scheme mismatch for columns/variables %.*ls. The encryption scheme for the columns/variables is %ls and the expression near line ‘%d’ expects it to be %ls (or weaker).

SQL Server Error Msg 4846 – The bulk data provider failed to allocate memory.

SQL Server Error Msg 4506 – Column names in each view or function must be unique. Column name ‘%.*ls’ in view or function ‘%.*ls’ is specified more than once.

SQL Server Error Msg 8469 – Remote service has been altered.

SQL Server Error Msg 15421 – The database principal owns a database role and cannot be dropped.

SQL Server Error Msg 1224 – An invalid application lock resource was passed to %ls.

SQL Server Error Msg 18322 – Reason: Access to server validation failed while revalidating the login on the connection.