Tag: MS SQL Server Error Codes
SQL Server Error Code – 4911 cannot specify a partitioned table witho
In this blog post, you’ll learn more about the SQL Server Error Code 4911 and the error message description that is shown SQL Server Error Code 4911 SQL Server Error Description for the Code :4911 Cannot specify a partitioned table without partition number in ALTER TABLE SWITCH statement. The table ‘%.*ls’ is partitioned.
SQL Server Error Code – 14237 when an action of ‘reassign’ is specifie
In this blog post, you’ll learn more about the SQL Server Error Code 14237 and the error message description that is shown SQL Server Error Code 14237 SQL Server Error Description for the Code :14237 When an action of ‘REASSIGN’ is specified, the New Login parameter must also be supplied.
SQL Server Error Code – 1835 unable to create/attach any new database
In this blog post, you’ll learn more about the SQL Server Error Code 1835 and the error message description that is shown SQL Server Error Code 1835 SQL Server Error Description for the Code :1835 Unable to create/attach any new database because the number of existing databases has reached the maximum number allowed: %d.
SQL Server Error Code – 5581 filestream feature has been disabled. re
In this blog post, you’ll learn more about the SQL Server Error Code 5581 and the error message description that is shown SQL Server Error Code 5581 SQL Server Error Description for the Code :5581 FILESTREAM feature has been disabled. Restart the instance of SQL Server for the settings to fully take effect. If you have data in FILESTREAM columns, it will not be accessible…
SQL Server Error Code – 9809 the style %d is not supported for conver
In this blog post, you’ll learn more about the SQL Server Error Code 9809 and the error message description that is shown SQL Server Error Code 9809 SQL Server Error Description for the Code :9809 The style %d is not supported for conversions from %s to %s.
SQL Server Error Code – 11563 the stored procedure ‘sp_set_session_res
In this blog post, you’ll learn more about the SQL Server Error Code 11563 and the error message description that is shown SQL Server Error Code 11563 SQL Server Error Description for the Code :11563 The stored procedure ‘sp_set_session_resource_group’ is not available in this edition of SQL Server.
SQL Server Error Code – 13244 select
In this blog post, you’ll learn more about the SQL Server Error Code 13244 and the error message description that is shown SQL Server Error Code 13244 SQL Server Error Description for the Code :13244 SELECT
SQL Server Error Code – 15141 the server principal owns one or more %s
In this blog post, you’ll learn more about the SQL Server Error Code 15141 and the error message description that is shown SQL Server Error Code 15141 SQL Server Error Description for the Code :15141 The server principal owns one or more %S_MSG(s) and cannot be dropped.
SQL Server Error Code – 22527 invalid value specified for %s. valid va
In this blog post, you’ll learn more about the SQL Server Error Code 22527 and the error message description that is shown SQL Server Error Code 22527 SQL Server Error Description for the Code :22527 Invalid value specified for %s. Valid values are ‘day’, ‘days’, ‘dd’, ‘year’, ‘years’, ‘yy’, ‘yyyy’, ‘month’, ‘months’, ‘mm’, ‘week’, ‘weeks’, ‘wk’, ‘hour’, ‘hours’, ‘hh’, ‘minute’, ‘minutes’, ‘mi’.
SQL Server Error Code – 22960 change data capture instance ‘%s’ has no
In this blog post, you’ll learn more about the SQL Server Error Code 22960 and the error message description that is shown SQL Server Error Code 22960 SQL Server Error Description for the Code :22960 Change data capture instance ‘%s’ has not been enabled for the source table ‘%s.%s’. Use sys.sp_cdc_help_change_data_capture to verify the capture instance name and retry the operation.
SQL Server Error Code – 49917 default collation: %ls (%ls %u)
In this blog post, you’ll learn more about the SQL Server Error Code 49917 and the error message description that is shown SQL Server Error Code 49917 SQL Server Error Description for the Code :49917 Default collation: %ls (%ls %u)
SQL Server Error Code – 29601 sm force closing channel to recover afte
In this blog post, you’ll learn more about the SQL Server Error Code 29601 and the error message description that is shown SQL Server Error Code 29601 SQL Server Error Description for the Code :29601 SM force closing channel to recover after errors
SQL Server Error Code – 923 database ?%.*ls? is in restricted mode.
In this blog post, you’ll learn more about the SQL Server Error Code 923 and the error message description that is shown SQL Server Error Code 923 SQL Server Error Description for the Code :923 Database ?%.*ls? is in restricted mode. Only the database owner and members of the dbcreator and sysadmin roles can access it.
SQL Server Error Code – 961 warning: index ?%.*ls? (index_id = %d) o
In this blog post, you’ll learn more about the SQL Server Error Code 961 and the error message description that is shown SQL Server Error Code 961 SQL Server Error Description for the Code :961 Warning: Index ?%.*ls? (index_id = %d) on object ID %d in database ?%.*ls? was renamed to ?%.*ls? because its name is a duplicate of another index on the same object.
SQL Server Error Code – 1074 creation of temporary functions is not a
In this blog post, you’ll learn more about the SQL Server Error Code 1074 and the error message description that is shown SQL Server Error Code 1074 SQL Server Error Description for the Code :1074 Creation of temporary functions is not allowed.
SQL Server Error Code – 1957 cannot create %s_msg on view ?%.*ls? bec
In this blog post, you’ll learn more about the SQL Server Error Code 1957 and the error message description that is shown SQL Server Error Code 1957 SQL Server Error Description for the Code :1957 Cannot create %S_MSG on view ?%.*ls? because view uses imprecise user-defined function ?%.*ls?. Consider removing reference to function or altering it to be precise.
SQL Server Error Code – 5256 table error: alloc unit id %i64d, page %
In this blog post, you’ll learn more about the SQL Server Error Code 5256 and the error message description that is shown SQL Server Error Code 5256 SQL Server Error Description for the Code :5256 Table error: alloc unit ID %I64d, page %S_PGID contains an incorrect page ID in its page header. The PageId in the page header = %S_PGID.
SQL Server Error Code – 6339 specified collection ‘%.*ls’ cannot be m
In this blog post, you’ll learn more about the SQL Server Error Code 6339 and the error message description that is shown SQL Server Error Code 6339 SQL Server Error Description for the Code :6339 Specified collection ‘%.*ls’ cannot be modified because it is SQL Server built-in XML Schema Collection.
SQL Server Error Code – 8683 could not force query plan because xml s
In this blog post, you’ll learn more about the SQL Server Error Code 8683 and the error message description that is shown SQL Server Error Code 8683 SQL Server Error Description for the Code :8683 Could not force query plan because XML showplan provided in USE PLAN hint contains invalid Star Join specification. Consider specifying a USE PLAN hint that contains an unmodified XML showplan…
SQL Server Error Code – 45105 cannot assign a deprecated setting as su
In this blog post, you’ll learn more about the SQL Server Error Code 45105 and the error message description that is shown SQL Server Error Code 45105 SQL Server Error Description for the Code :45105 Cannot assign a deprecated setting as successor.