Tag: SQL Server Errors

SQL Server Error Msg sp_migrate_user_to_contained cannot be used to copy a password to an old hash algorithm. – 16

SQL Server Error Msg 5287 – DBCC THROWERROR bypass exception. This is an informational message only. No user action is required.

SQL Server Error Msg 10100 – Cannot create %S_MSG on view “%.*ls” because it contains the DISTINCT keyword. Consider removing DISTINCT from the view or not indexing the view. Alternatively, consider replacing DISTINCT with GROUP BY or COUNT_BIG(*) to simulate DISTINCT on grouping columns.

SQL Server Error Msg 4162 – A PROB_MATCH table can only be used inside of a PROB_MATCH query.

SQL Server Error Msg 13057 – a planguide batch

SQL Server Error Msg 47009 – Reason: FedAuth RPS Authentication failed when fetching Session Key.

SQL Server Error Msg 4208 – The statement %hs is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.

SQL Server Error Msg 10920 – Cannot %S_MSG user-defined function ‘%.*ls’. It is being used as a resource governor classifier.

SQL Server Error Msg 3072 – Backup encryption is incompatible with file snapshot backup if TDE is not enabled on the database.

SQL Server Error Msg 15368 – Failed to generate a user instance of SQL Server due to a failure in reading registry keys. The connection will be closed.%.*ls

SQL Server Error Msg 9799 – The connection was closed by the remote end, or an error occurred while receiving data: ‘%.*ls’

SQL Server Error Msg 47011 – Reason: FedAuth RPS Authentication failed when computing HMAC Hash Signature.

SQL Server Error Msg 17172 – SNIInitialize() failed with error 0x%lx.

SQL Server Error Msg 7141 – Must create orphaned text inside a user transaction.

SQL Server Error Msg 22986 – Could not allocate memory for Change Data Capture population. Verify that SQL Server has sufficient memory for all operations. Check the physical and virtual memory settings on the server and examine memory usage to see if another application is consuming excessive memory.

SQL Server Error Msg 3147 – Backup and restore operations are not allowed on database tempdb.

SQL Server Error Msg 19035 – OLE task allocator failed to initialize. Heterogeneous queries, distributed queries, and remote procedure calls are unavailable. Confirm that DCOM is properly installed and configured.

SQL Server Error Msg 22207 – Internal error. Unable to get a valid dbtable. Error Code 22207.

SQL Server Error Msg 20 – 622

SQL Server Error Msg 4348 – The online restore to database ‘%ls’ failed. It may be appropriate to perform an offline restore instead. An offline restore is initiated by using BACKUP LOG WITH NORECOVERY.