Tag: SQL Server Errors

SQL Server Error Msg 16 – 438

SQL Server Error Msg 34054 – Policy Management cannot be enabled on this edition of SQL Server.

SQL Server Error Msg 33245 – SQL Server Audit failed to write to an audit file related to the audit ‘%s’ in the directory ‘%s’. Make sure that the disk is not full and that the SQL Server service account has the required permissions to create and write to the file.

SQL Server Error Msg 25035 – When distribution database is part of availability group, then distributor and publisher server cannot be same.

SQL Server Error Msg 22943 – Columns used to uniquely identify a row for net change tracking must be included in the list of captured columns. Add either the primary key columns of the source table, or the columns defined for the index specified in the parameter @index_name to the list of captured columns and retry the operation.

SQL Server Error Msg 8674 – The query processor is unable to produce a plan. The table ‘%.*ls’ is unavailable because the heap is corrupted. Take the database offline to rebuild the table and heap, and then run the query processor again.

SQL Server Error Msg 136 – Cannot use a CONTINUE statement outside the scope of a WHILE statement.

SQL Server Error Msg 29316 – The path name for the file matrix.xsd cannot be constructed. (Reason: %d).

SQL Server Error Msg 34019 – Object “%s” is invalid.

SQL Server Error Msg 40006 – Unknown transaction id.

SQL Server Error Msg 4993 – ALTER TABLE SWITCH statement failed. The table ‘%.*ls’ has different setting for Large Value Types Out Of Row table option as compared to table ‘%.*ls’.

SQL Server Error Msg 39119 – %s EXTERNAL LANGUAGE failed because it could not open the physical file ‘%.*ls’: %ls.

SQL Server Error Msg 4627 – Cannot grant, deny, or revoke the connect database permission to application roles.

SQL Server Error Msg 9238 – Query notification subscriptions are not allowed under an active application role context. Consider re-issuing the request without activating the application role.

SQL Server Error Msg 21656 – The data type mapping for %s does not exist. Verify the list of available mappings by querying msdb.dbo.sysdatatypemappings.

SQL Server Error Msg 4188 – Column or parameter ‘%.*ls’ has type ‘%ls’ and collation ‘%.*ls’. The legacy LOB types do not support UTF-8 or UTF-16 encodings. Use types varchar(max), nvarchar(max) or a collation which does not have the _SC or _UTF8 flags.

SQL Server Error Msg 19123 – ‘IpAddress’ registry value is the wrong type.

SQL Server Error Msg 47058 – Reason: Unexpected error on VNET firewall rule table lookup while looking up the IPv4 Allow All rule.

SQL Server Error Msg 3756 – TRUNCATE TABLE statement failed. Index ‘%.*ls’ is not partitioned, but table ‘%.*ls’ uses partition function ‘%.*ls’. Index and table must use an equivalent partition function.

SQL Server Error Msg 45146 – Database copy property ‘%ls’ is required.