SQL Server

How to get day of a week in SQL Server ?

SQL Server Error Msg 41000 – Failed to obtain the local Windows Server Failover Clustering (WSFC) handle (Error code %d).  If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state.  Otherwise, contact your primary support provider.  For information about this error code, see “System Error Codes” in the Windows Development documentation.

SQL Server Error Msg 2555 – Cannot move all contents of file “%.*ls” to other places to complete the emptyfile operation.

SQL Server Error Msg 3948 – The transaction was terminated because of the availability replica config/state change or because ghost records are being deleted on the primary and the secondary availability replica that might be needed by queries running under snapshot isolation. Retry the transaction.

SQL Server Error Msg 31021 – Could not get winfab log directory when performing DTA tuning related task.

SQL Server Error Msg 4016 – Language requested in ‘login %.*ls’ is not an official name on this SQL Server. Using user default %.*ls instead.

SQL Server Error Msg 40624 – Operation is not allowed because server ‘%.*ls’ is disabled.

SQL Server Error Msg 22941 – Could not retrieve column information for index ‘%s’ of source table ‘%s.%s’. Refer to previous errors in the current session to identify the cause and correct any associated problems.

SQL Server Error Msg 20088 – Only assign priorities that are greater than or equal to 0 and less than 100.

SQL Server Error Msg 6001 – SHUTDOWN is waiting for %d process(es) to complete.

SQL Server Error Msg 11704 – The current value ‘%.*ls’ for sequence object ‘%.*ls’ must be between the minimum and maximum value of the sequence object.

SQL Server Error Msg 28906 – Configuration manager agent enlistment completed with ‘%s’.

SQL Server Error Msg 21366 – Could not add filter ‘%s’ because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.

SQL Server Error Msg %S_MSG is not allowed in %S_MSG. – 15

SQL Server Error Msg 33579 – Cannot drop a value for the column encryption key ‘%.*ls’; dropping the value makes the key enclave disabled, and one or more objects that are schema-bound to column ‘%.*ls’ depend on it.

SQL Server Error Msg 4339 – This RESTORE statement successfully performed some actions, but the database could not be brought online because one or more RESTORE steps are needed. Previous messages indicate reasons why recovery cannot occur at this point.

SQL Server Error Msg 46803 – Failed to locate entry point for global query module.

SQL Server Error Msg 8064 – Parameter %d ([%.*ls].[%.*ls].[%.*ls]): The CLR type does not exist or you do not have permissions to access it.

SQL Server Error Msg The table (and its columns) returned by a table-valued method need to be aliased. – 16

SQL Server Error Msg 3074 – Failed while getting attributes for the file snapshot %.*ls. Error code %ld.