Tag: SQL Server Errors

SQL Server Error Msg 295 – Conversion failed when converting character string to smalldatetime data type.

SQL Server Error Msg 9939 – Current user or role ‘%.*ls’ does not have the required permission to set the owner.

SQL Server Error Msg 4174 – Delayed CLR type instantiation fetch value query may only reference column of a large object or large value type.

SQL Server Error Msg 11406 – ALTER TABLE SWITCH statement failed. Source and target partitions have different values for the DATA_COMPRESSION option.

SQL Server Error Msg 27160 – The Stored Procedure, ‘%ls’, failed to run because the Integration Services database (SSISDB) is not in single-user mode. In SQL Server Management Studio, launch Database Properties dialog box for SSISDB, switch to the Options tab, and set the Restrict Access property to single-user mode (SINGLE_USER). Then, try to run the stored procedure again.

SQL Server Error Msg 14161 – The threshold [%s:%s] for the publication [%s] has been set. Make sure that the logreader and distribution agents are running and can match the latency requirement.

SQL Server Error Msg 4405 – View or function ‘%.*ls’ is not updatable because the modification affects multiple base tables.

SQL Server Error Msg 22500 – Unexpected

SQL Server Error Msg 16 – 13798

SQL Server Error Msg 41933 – Failed to initialize detours and local time for Managed Instance. %ls

SQL Server Error Msg 46620 – SHARD_MAP_MANGER

SQL Server Error Msg 4426 – View ‘%.*ls’ is not updatable because the definition contains a UNION operator.

SQL Server Error Msg 8172 – The argument %d of the XML data type method “%.*ls” must be a string literal.

SQL Server Error Msg 25013 – Cannot perform alter table because the table is published in one or more publications with a publication_compatibility_level of lower than ’90RTM’. Use sp_repladdcolumn or sp_repldropcolumn.

SQL Server Error Msg 9987 – The max gap argument in NEAR clause must be either the word MAX or an integer greater than or equal to 0.

SQL Server Error Msg 8676 – Invalid plan.

SQL Server Error Msg 4838 – The bulk data source does not support the SQLNUMERIC or SQLDECIMAL data types.

SQL Server Error Msg 14575 – @freq_relative_interval must be one of 1st (0x1), 2nd (0x2), 3rd [0x4], 4th (0x8) or Last (0x10).

SQL Server Error Msg 35225 – Could not process the operation. The  instance of SQL Server is running under WOW64 (Windows 32-bit on Windows 64-bit), which does not support Always On Availability Groups.  Reinstall SQL Server in the native 64-bit edition, and re-enable Always On Availability Groups. Then, restart the SQL Server service, and retry the operation. For information about how to enable and disable Always On Availability Groups, see SQL Server Books Online.

SQL Server Error Msg 15715 – Setting Automatic Tuning option %.*ls to DEFAULT is not allowed while in CUSTOM database tuning mode for database %.*ls.