Tag: SQL Server Errors

SQL Server Error Msg 1762 – Cannot create the foreign key “%.*ls” with the SET DEFAULT referential action, because one or more referencing not-nullable columns lack a default constraint.

SQL Server Error Msg 1765 – Foreign key ‘%.*ls’ creation failed. Only NO ACTION and CASCADE referential delete actions are allowed for referencing computed column ‘%.*ls’.

SQL Server Error Msg 8018 – Invalid parameter %d (‘%.*ls’):  Data type 0x%02X is a deprecated large object, or LOB, but is marked as output parameter.  Deprecated types are not supported as output parameters.  Use current large object types instead.

SQL Server Error Msg 33504 – The attempted operation failed because the target object ‘%.*ls’ has a block predicate that conflicts with this operation. If the operation is performed on a view, the block predicate might be enforced on the underlying table. Modify the operation to target only the rows that are allowed by the block predicate.

SQL Server Error Msg 14838 – Table ‘%.*ls’ cannot be accessed in SNAPSHOT transaction isolation level because it has REMOTE_DATA_ARCHIVE option enabled.

SQL Server Error Msg Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online. – 16

SQL Server Error Msg Table and column names must be supplied for the READTEXT or WRITETEXT utility. – 15

SQL Server Error Msg 4078 – The statement failed because column ‘%.*ls’ (ID=%d) uses collation %.*ls, which is not recognized by older client drivers. Try upgrading the client operating system or applying a service update to the database client software, or use a different collation. See SQL Server Books Online for more information on changing collations.

SQL Server Error Msg 16 – 584

SQL Server Error Msg 22951 – Could not remove captured column entries in the Change Data Capture metadata for capture instance ‘%s’ and 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 33060 – The format of supplied parameter sid is invalid. The sid might be incorrect or the sid might describe the wrong type of user.

SQL Server Error Msg 9814 – The date provided is before the start of the Hijri calendar which in Microsoft’s ‘Kuwaiti Algorithm’ is July 15th, 622 C.E. (Julian calendar) or July 18th, 622 C.E (proleptic Gregorian calendar).

SQL Server Error Msg 15259 – The DEFAULT_SCHEMA clause cannot be used with principals mapped to certificates or asymmetric keys.

SQL Server Error Msg 40546 – Cannot create UCS task pool

SQL Server Error Msg 40815 – Could not change database edition to or from Premium for a Federation member.

SQL Server Error Msg 13030 – database

SQL Server Error Msg 2797 – The default schema does not exist.

SQL Server Error Msg 45106 – Cannot create new item. The max provision count has been reached.

SQL Server Error Msg 21032 – Could not subscribe because non-SQL Server Subscriber ‘%s’ does not support ‘sync tran’ update mode.

SQL Server Error Msg 15810 – Error trying to retrieve schema from the data file ‘%.*ls’. Make sure the file matches the ‘%.*ls’ format.