SQL Server

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.

SQL Server Error Msg 26058 – A TCP provider is enabled, but there are no TCP listening ports configured. The server cannot accept TCP connections.

SQL Server Error Msg 33117 – Transparent Data Encryption is not available in the edition of this SQL Server instance. See books online for more details on feature support in different SQL Server editions.

SQL Server Error Msg 14426 – A log shipping monitor is already defined. Call sp_define_log_shipping_monitor with @delete_existing = 1.

SQL Server Error Msg 6376 – For selective XML index ‘%.*ls’, MAX_LENGTH optimization hint cannot be specified if length or maxLength facet is specified in schema for an element.

SQL Server 2014 Tutorial – Install SQL Server 2014 on Windows 10 machine

SQL Server Error Msg 5595 – .PhysicalPathName is disabled.

SQL Server Error Msg 11544 – Could not deduce type for parameter in position ‘%d’ for remote call to module ‘%.*ls’.

SQL Server Error Msg 7435 – The OLE DB provider “%ls” for linked server “%ls” returned unexpected NULL pointer for string column “%ls.%ls”.

SQL Server Error Msg 5828 – User connections are limited to %d.

SQL Server Error Msg 25656 – Error validating action. %ls

SQL Server Error Msg 7732 – Cannot specify partition number in Alter index statement along with keyword ALL to rebuild partitions of table ‘%.*ls’ when the table does not have any regular indexes.

SQL Server Error Msg 8428 – The message type “%.*ls” is not found.