Search the Blog

Saturday, July 31, 2021

MS SQL Server Error Types

Error Type =14002,/n Error Description Could not find the 'Sync' subsystem with the task ID %ld.. Error Severity  Level=16

How To Increase SQL Server Error Log File Count - Database Tutorials

Error Type =14003, Error Description You must supply a publication name.. Error Severity  Level=16

Error Type =14004, Error Description %s must be in the current database.. Error Severity  Level=16

Error Type =14005, Error Description Cannot drop the publication because at least one subscription exists for this publication. Drop all subscriptions to the publication before attempting to drop the publication. If the problem persists, replication metadata might be incorrect; consult Books. Error Severity  Level=16

Error Type =14006, Error Description Could not drop the publication.. Error Severity  Level=16

Error Type =14008, Error Description There are no publications.. Error Severity  Level=11

Error Type =14009, Error Description There are no articles for publication '%s'.. Error Severity  Level=11

Error Type =14010, Error Description The remote server '%s' is not defined as a subscription server. Ensure you specify the server name rather than a network alias.. Error Severity  Level=16

Error Type =14011, Error Description Unable to mark server '%s' as a non SQL Server subscriber.. Error Severity  Level=16

Error Type =14012, Error Description The @status parameter value must be either 'active' or 'inactive'.. Error Severity  Level=16

Error Type =14013, Error Description This database is not enabled for publication.. Error Severity  Level=16

Error Type =14014, Error Description The synchronization method (@sync_method) must be '[bcp] native', '[bcp] character', 'concurrent', 'concurrent_c', 'database snapshot', or 'database snapshot character'.. Error Severity  Level=16

Error Type =14015, Error Description The replication frequency (@repl_freq) must be either 'continuous' or 'snapshot'.. Error Severity  Level=16

Error Type =14016, Error Description The publication '%s' already exists.. Error Severity  Level=16

Error Type =14017, Error Description Invalid @restricted parameter value. Valid options are 'true' or 'false'.. Error Severity  Level=16

Error Type =14018, Error Description Could not create the publication.. Error Severity  Level=16

Error Type =14019, Error Description The @operation parameter value must be either add, drop, or alter.. Error Severity  Level=16

Error Type =14020, Error Description Could not obtain the column ID for the specified column. Schema replication failed.. Error Severity  Level=16

Error Type =14021, Error Description The column was not added correctly to the article.. Error Severity  Level=16

Error Type =14022, Error Description The @property parameter value must be either 'description', 'sync_object', 'type', 'ins_cmd', 'del_cmd', 'upd_cmd', 'filter', 'dest_table', 'dest_object', 'creation_script', 'pre_creation_cmd', 'status', 'schema_option', or 'destination_owner'.. Error Severity  Level=16

Error Type =14023, Error Description The type must be '[indexed view ]logbased[ (manualview|manualfilter|manualboth)]', '[serializable ]proc exec', or '(view|indexed view|proc|func|aggregate|synonym) schema only'.. Error Severity  Level=16

Error Type =14024, Error Description The value of property 'subscriber_provider' cannot be NULL.. Error Severity  Level=16

Error Type =14025, Error Description Article update successful.. Error Severity  Level=10

Error Type =14026, Error Description The value of property 'subscriber_type is not a supported heterogeneous subscriber type. The value must be 1 (ODBC subscriber), or 3 (OLEDB subscriber).. Error Severity  Level=16

Error Type =14027, Error Description %s does not exist in the current database.. Error Severity  Level=11

Error Type =14028, Error Description Only user tables, materialized views, and stored procedures can be published as 'logbased' articles.. Error Severity  Level=16

Error Type =14029, Error Description The vertical partition switch must be either 'true' or 'false'.. Error Severity  Level=16

Error Type =14030, Error Description The article '%s' exists in publication '%s'.. Error Severity  Level=16

Error Type =14031, Error Description User tables and views are the only valid synchronization objects.. Error Severity  Level=16

Error Type =14032, Error Description The value of parameter %s cannot be 'all'. It is reserved by replication stored procedures.. Error Severity  Level=16

Error Type =14033, Error Description Could not change replication frequency because there are active subscriptions on the publication.. Error Severity  Level=16

Error Type =14034, Error Description The publication name (@publication) cannot be the keyword 'all'.. Error Severity  Level=16

Error Type =14035, Error Description The replication option '%s' of database '%s' has already been set to true.. Error Severity  Level=16

Error Type =14036, Error Description Could not enable database for publishing.. Error Severity  Level=16

Error Type =14037, Error Description The replication option '%s' of database '%s' has been set to false.. Error Severity  Level=16

Error Type =14038, Error Description Could not disable database for publishing.. Error Severity  Level=16

Error Type =14039, Error Description Could not construct column clause for article view. Reduce the number of columns or create the view manually.. Error Severity  Level=16

Error Type =14040, Error Description The server '%s' is already a Subscriber.. Error Severity  Level=16

Error Type =14041, Error Description The '%s' property can only be changed if the publication is enabled for heterogeneous subscriptions. The publication is not enabled.. Error Severity  Level=16

Error Type =14042, Error Description Could not create Subscriber.. Error Severity  Level=16

Error Type =14043, Error Description The parameter %s passed to stored procedure %s cannot be NULL.. Error Severity  Level=16

Error Type =14044, Error Description Unable to clear subscriber status for the server.. Error Severity  Level=16

Error Type =14045, Error Description Unable to update subscriber_type in MSdistribution_agents table.. Error Severity  Level=16

Error Type =14046, Error Description Could not drop article. A subscription exists on it.. Error Severity  Level=16

Error Type =14047, Error Description Could not drop %s.. Error Severity  Level=16

Error Type =14048, Error Description The server '%s' is not a Subscriber.. Error Severity  Level=16

Error Type =14049, Error Description Stored procedures for replication are the only objects that can be used as a filter.. Error Severity  Level=16

Error Type =14050, Error Description No subscription is on this publication or article.. Error Severity  Level=11

Error Type =14051, Error Description The parameter value must be 'sync_type' or 'dest_db'.. Error Severity  Level=16

Error Type =14052, Error Description The @sync_type parameter value must be "automatic", "none", "replication support only", "initialize with backup", or "initialize from lsn".. Error Severity  Level=16

Error Type =14053, Error Description The subscription could not be updated at this time.. Error Severity  Level=16

Error Type =14054, Error Description The subscription was updated successfully.. Error Severity  Level=10

Error Type =14055, Error Description The subscription does not exist.. Error Severity  Level=10

Error Type =14056, Error Description The subscription could not be dropped at this time.. Error Severity  Level=16

Error Type =14057, Error Description The subscription could not be created.. Error Severity  Level=16

Error Type =14058, Error Description Cannot create the subscription because the subscription already exists in the subscription database. Only one subscription to the same publication is allowed in each subscription database. Drop the subscription and add it again if necessary. If the proble. Error Severity  Level=16

Error Type =14059, Error Description Materialized view articles cannot be created for publications with the properties allow_sync_tran, allow_queued_tran, or allow_dts.. Error Severity  Level=16

Error Type =14060, Error Description Subscriber parameters specifying provider properties must be NULL for SQL Server subscribers.. Error Severity  Level=16

Error Type =14061, Error Description The @pre_creation_cmd parameter value must be 'none', 'drop', 'delete', or 'truncate'.. Error Severity  Level=16

Error Type =14062, Error Description The Subscriber was dropped.. Error Severity  Level=10

Error Type =14063, Error Description The remote server does not exist or has not been designated as a valid Subscriber.. Error Severity  Level=11

Error Type =14065, Error Description The @status parameter value must be 'initiated', 'active', 'inactive', or 'subscribed'.. Error Severity  Level=16

Error Type =14066, Error Description The previous status must be 'active', 'inactive', or 'subscribed'.. Error Severity  Level=16

Error Type =14067, Error Description The status value is the same as the previous status value.. Error Severity  Level=16

Error Type =14068, Error Description The subscription status of the object could not be changed.. Error Severity  Level=16

Error Type =14069, Error Description Could not update sysarticles. The subscription status could not be changed.. Error Severity  Level=16

Error Type =14070, Error Description Could not update the distribution database subscription table. The subscription status could not be changed.. Error Severity  Level=16

Error Type =14071, Error Description Could not find the Distributor or the distribution database for the local server. The Distributor may not be installed, or the local server may not be configured as a Publisher at the Distributor.. Error Severity  Level=16

Error Type =14074, Error Description The server '%s' is already listed as a Publisher.. Error Severity  Level=16

Error Type =14075, Error Description The Publisher could not be created at this time.. Error Severity  Level=16

Error Type =14076, Error Description Could not grant replication login permission to '%s'.. Error Severity  Level=16

Error Type =14077, Error Description The publication was updated successfully.. Error Severity  Level=10

Error Type =14078, Error Description The parameter must be 'description', 'taskid', 'sync_method', 'status', 'repl_freq', 'restricted', 'retention', 'immediate_sync', 'enabled_for_internet', 'allow_push', 'allow_pull', 'allow_anonymous', or 'retention'.. Error Severity  Level=16

Error Type =14080, Error Description The remote server "%s" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.. Error Severity  Level=16

Error Type =14085, Error Description The Subscriber information could not be obtained from the Distributor.. Error Severity  Level=16

Error Type =14088, Error Description The table '%s' must have a primary key to be published using the transaction-based method.. Error Severity  Level=16

Error Type =14089, Error Description The clustered index on materialized view '%s' may not contain nullable columns if it is to be published using the transaction-based method.. Error Severity  Level=16

Error Type =14090, Error Description Error evaluating article synchronization object after column drop. The filter clause for article '%s' must not reference the dropped column.. Error Severity  Level=16

Error Type =14091, Error Description The @type parameter passed to sp_helpreplicationdb must be either 'pub' or 'sub'.. Error Severity  Level=16

Error Type =14092, Error Description Could not change article because there is an existing subscription to the article.. Error Severity  Level=16

Error Type =14093, Error Description Cannot grant or revoke access directly on publication '%s' because it uses the default publication access list.. Error Severity  Level=16

Error Type =14094, Error Description Could not subscribe to article '%s' because heterogeneous Subscriber '%s' does not support the @pre_creation_cmd parameter value 'truncate'.. Error Severity  Level=16

Error Type =14095, Error Description The value for the @sync_method parameter is not valid. Could not subscribe to publication '%s' because non-SQL Server Subscriber '%s' only supports values of 'character', 'bcp character', 'concurrent_c', and 'database snapshot character' for the @sync_me. Error Severity  Level=16

Error Type =14096, Error Description The path and name of the table creation script must be specified if the @pre_creation_cmd parameter value is 'drop'.. Error Severity  Level=16

Error Type =14097, Error Description The 'status' value must be 'no column names', 'include column names', 'string literals', 'parameters', 'DTS horizontal partitions' or 'no DTS horizontal partitions'.. Error Severity  Level=16

Error Type =14098, Error Description Cannot drop Distribution Publisher '%s'. The remote Publisher is using '%s' as Distributor. Disable publishing at the Publisher before attempting to drop this relationship.. Error Severity  Level=16

Error Type =14099, Error Description The server '%s' is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard.. Error Severity  Level=16

Error Type =14100, Error Description Specify all articles when subscribing to a publication using concurrent snapshot processing.. Error Severity  Level=16

Error Type =14101, Error Description The publication '%s' already has a Snapshot Agent defined.. Error Severity  Level=16

Error Type =14102, Error Description Specify all articles when unsubscribing from a publication using concurrent snapshot processing.. Error Severity  Level=16

Error Type =14103, Error Description Invalid "%s" value. Valid values are "publisher", "subscriber", or "both".. Error Severity  Level=16

Error Type =14105, Error Description You have updated the distribution database property '%s' successfully.. Error Severity  Level=10

Error Type =14106, Error Description Distribution retention periods must be greater than or equal to 0.. Error Severity  Level=16

Error Type =14107, Error Description The @max_distretention value must be larger than the @min_distretention value.. Error Severity  Level=10

Error Type =14108, Error Description Removed %ld history records from %s.. Error Severity  Level=10

Error Type =14109, Error Description The @security_mode parameter value must be 0 (SQL Server Authentication) or 1 (Windows Authentication).. Error Severity  Level=10

Error Type =14110, Error Description For stored procedure articles, the @property parameter value must be 'description', 'dest_table', 'dest_object', 'creation_script', 'pre_creation_cmd', 'schema_option', or 'destination_owner'.. Error Severity  Level=16

Error Type =14111, Error Description The @pre_creation_cmd parameter value must be 'none' or 'drop'.. Error Severity  Level=16

Error Type =14112, Error Description This procedure can be executed only against table-based articles.. Error Severity  Level=16

Error Type =14113, Error Description Could not execute '%s'. Check '%s' in the install directory.. Error Severity  Level=16

Error Type =14114, Error Description The server '%s' is not configured as a Distributor.. Error Severity  Level=16

Error Type =14115, Error Description The property parameter value must be %s.. Error Severity  Level=16

Error Type =14117, Error Description %s' is not configured as a distribution database.. Error Severity  Level=16

Error Type =14118, Error Description A stored procedure can be published only as a 'serializable proc exec' article, a 'proc exec' article, or a 'proc schema only' article.. Error Severity  Level=16

Error Type =14119, Error Description Could not add the distribution database '%s'. This distribution database already exists.. Error Severity  Level=16

Error Type =14120, Error Description Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.. Error Severity  Level=16

Error Type =14121, Error Description Could not drop the Distributor '%s'. This Distributor has associated distribution databases.. Error Severity  Level=16

Error Type =14122, Error Description The @article parameter value must be 'all' for immediate_sync publications.. Error Severity  Level=16

Error Type =14123, Error Description The subscription @sync_type parameter value 'manual' is no longer supported.. Error Severity  Level=16

Error Type =14124, Error Description A publication must have at least one article before a subscription to it can be created.. Error Severity  Level=16

Error Type =14126, Error Description You do not have the required permissions to complete the operation.. Error Severity  Level=16

Error Type =14128, Error Description Invalid @subscription_type parameter value. Valid options are 'push' or 'pull'.. Error Severity  Level=16

Error Type =14129, Error Description The @status parameter value must be NULL for 'automatic' sync_type when you add subscriptions to an immediate_sync publication.. Error Severity  Level=16

Error Type =14135, Error Description There is no subscription on Publisher '%s', publisher database '%s', publication '%s'.. Error Severity  Level=16

Error Type =14136, Error Description The keyword 'all' is reserved by replication stored procedures.. Error Severity  Level=16

Error Type =14137, Error Description The @value parameter value must be either 'true' or 'false'.. Error Severity  Level=16

Error Type =14138, Error Description Invalid option name '%s'.. Error Severity  Level=16

Error Type =14139, Error Description The replication system table '%s' already exists.. Error Severity  Level=16

Error Type =14143, Error Description Cannot drop Distributor Publisher '%s'. There are Subscribers associated with it in the distribution database '%s'.. Error Severity  Level=16

Error Type =14144, Error Description Cannot drop Subscriber '%s'. There are subscriptions for it in the publication database '%s'.. Error Severity  Level=16

Error Type =14146, Error Description The article parameter '@schema_option' cannot be NULL.. Error Severity  Level=16

Error Type =14147, Error Description Restricted publications are no longer supported.. Error Severity  Level=16

Error Type =14148, Error Description Invalid '%s' value. Valid values are 'true' or 'false'.. Error Severity  Level=16

Error Type =14149, Error Description Removed %ld replication history records in %s seconds (%ld row/secs).. Error Severity  Level=10

Error Type =14150, Error Description Replication-%s: agent %s succeeded. %s. Error Severity  Level=10

Error Type =14151, Error Description Replication-%s: agent %s failed. %s. Error Severity  Level=18

Error Type =14152, Error Description Replication-%s: agent %s scheduled for retry. %s. Error Severity  Level=10

Error Type =14153, Error Description Replication-%s: agent %s warning. %s. Error Severity  Level=10

Error Type =14154, Error Description The Distributor parameter must be '@heartbeat_interval'.. Error Severity  Level=16

Error Type =14155, Error Description Invalid article ID specified for procedure script generation.. Error Severity  Level=16

Error Type =14156, Error Description The custom stored procedure calling the format for the %s command specified in the article definition does not match the %s format.. Error Severity  Level=16

Error Type =14157, Error Description The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped.. Error Severity  Level=10

Error Type =14158, Error Description Replication-%s: agent %s: %s.. Error Severity  Level=10

Error Type =14159, Error Description Could not change property '%s' for article '%s' because there is an existing subscription to the article.. Error Severity  Level=16

Error Type =14160, Error Description One or more subscriptions has exceeded the threshold [%s:%s] for the publication [%s]. Check the status of subscriptions to this publication and change the expiration threshold value if necessary.. Error Severity  Level=10

Error Type =14161, Error Description 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.. Error Severity  Level=10

Error Type =14162, Error Description One or more subscriptions has exceeded the threshold [%s:%s] for the publication [%s]. Check the status of subscriptions to this publication and adjust the threshold value if necessary.. Error Severity  Level=10

Error Type =14163, Error Description One or more subscriptions has exceeded the threshold [%s:%s] for the publication [%s]. Check the status of subscriptions to this publication and adjust the threshold value if necessary.. Error Severity  Level=10

Error Type =14164, Error Description One or more subscriptions has exceeded the threshold [%s:%s] for the publication [%s]. Check the status of subscriptions to this publication and adjust the threshold value if necessary.. Error Severity  Level=10

Error Type =14165, Error Description One or more subscriptions has exceeded the threshold [%s:%s] for the publication [%s]. Check the status of subscriptions to this publication and adjust the threshold value if necessary.. Error Severity  Level=10

Error Type =14166, Error Description Disable publishing ignored error msg %d, severity %d, state %d: %s.. Error Severity  Level=10

Error Type =14167, Error Description Subscription expiration. Error Severity  Level=10

Error Type =14168, Error Description Transactional replication latency. Error Severity  Level=10

Error Type =14169, Error Description Long merge over dialup connection. Error Severity  Level=10

Error Type =14170, Error Description Long merge over LAN connection. Error Severity  Level=10

Error Type =14171, Error Description Slow merge over LAN connection. Error Severity  Level=10

Error Type =14172, Error Description Slow merge over dialup connection. Error Severity  Level=10

Error Type =14196, Error Description The agent has never been run.. Error Severity  Level=10

Error Type =14197, Error Description Value of %s parameter should be in the set %s. Error Severity  Level=10

Error Type =14198, Error Description The value of the %s parameter should be in the range %s. Verify that the specified parameter value is correct.. Error Severity  Level=10

Error Type =14199, Error Description The specified job '%s' is not created for maintenance plans. Verify that the job has at least one step calling xp_sqlmaint.. Error Severity  Level=10

Error Type =14200, Error Description The specified '%s' is invalid.. Error Severity  Level=16

Error Type =, Error Description DDL operations. Error Severity  Level=16

Error Type =Error, Error Description Description. Error Severity  Level=Severity

Error Type =14201, Error Description 0 (all steps) ... Error Severity  Level=10

Error Type =14202, Error Description before or after @active_start_time. Error Severity  Level=10

Error Type =14203, Error Description sp_helplogins [excluding Windows NT groups]. Error Severity  Level=10

Error Type =14204, Error Description 0 (non-idle), 1 (executing), 2 (waiting for thread), 3 (between retries), 4 (idle), 5 (suspended), 7 (performing completion actions). Error Severity  Level=10

Error Type =14205, Error Description (unknown). Error Severity  Level=10

Error Type =14206, Error Description 0..n seconds. Error Severity  Level=10

Error Type =14207, Error Description -1 [no maximum], 0..n. Error Severity  Level=10

Error Type =14208, Error Description 1..7 [1 = E-mail, 2 = Pager, 4 = NetSend]. Error Severity  Level=10

Error Type =14209, Error Description 0..127 [1 = Sunday .. 64 = Saturday]. Error Severity  Level=10

Error Type =14210, Error Description notification. Error Severity  Level=10

Error Type =14211, Error Description server. Error Severity  Level=10

Error Type =14212, Error Description (all jobs). Error Severity  Level=10

Error Type =14213, Error Description Core Job Details:. Error Severity  Level=10

Error Type =14214, Error Description Job Steps:. Error Severity  Level=10

Error Type =14215, Error Description Job Schedules:. Error Severity  Level=10

Error Type =14216, Error Description Job Target Servers:. Error Severity  Level=10

Error Type =14217, Error Description SQL Server Warning: '%s' has performed a forced defection of TSX server '%s'. Run sp_delete_targetserver at the MSX in order to complete the defection.. Error Severity  Level=10

Error Type =14218, Error Description hour. Error Severity  Level=10

Error Type =14219, Error Description minute. Error Severity  Level=10

Error Type =14220, Error Description second. Error Severity  Level=10

Error Type =14221, Error Description This job has one or more notifications to operators other than '%s'. The job cannot be targeted at remote servers as currently defined.. Error Severity  Level=16

Error Type =14222, Error Description Cannot rename the '%s' operator.. Error Severity  Level=16

Error Type =14223, Error Description Cannot modify or delete operator '%s' while this server is a %s.. Error Severity  Level=16

Error Type =14224, Error Description Warning: The server name given is not the current MSX server ('%s').. Error Severity  Level=10

Error Type =14225, Error Description Warning: Could not determine local machine name. This prevents MSX operations from being posted.. Error Severity  Level=16

Error Type =14226, Error Description %ld history entries purged.. Error Severity  Level=10

Error Type =14227, Error Description Server defected from MSX '%s'. %ld job(s) deleted.. Error Severity  Level=10

Error Type =14228, Error Description Server MSX enlistment changed from '%s' to '%s'.. Error Severity  Level=10

Error Type =14229, Error Description Server enlisted into MSX '%s'.. Error Severity  Level=10

Error Type =14230, Error Description SP_POST_MSX_OPERATION: %ld %s download instruction(s) posted.. Error Severity  Level=10

Error Type =14231, Error Description SP_POST_MSX_OPERATION Warning: The specified %s ('%s') is not involved in a multiserver job.. Error Severity  Level=10

Error Type =14232, Error Description Specify either a job_name, job_id, or an originating_server.. Error Severity  Level=16

Error Type =14233, Error Description Specify a valid job_id (or 0x00 for all jobs).. Error Severity  Level=16

Error Type =14234, Error Description The specified '%s' is invalid (valid values are returned by %s).. Error Severity  Level=16

Error Type =14235, Error Description The specified '%s' is invalid (valid values are greater than 0 but excluding %ld).. Error Severity  Level=16

Error Type =14236, Error Description Warning: Non-existent step referenced by %s.. Error Severity  Level=10

Error Type =14237, Error Description When an action of 'REASSIGN' is specified, the New Login parameter must also be supplied.. Error Severity  Level=16

Error Type =14238, Error Description %ld jobs deleted.. Error Severity  Level=10

Error Type =14239, Error Description %ld jobs reassigned to %s.. Error Severity  Level=10

Error Type =14240, Error Description Job applied to %ld new servers.. Error Severity  Level=10

Error Type =14241, Error Description Job removed from %ld servers.. Error Severity  Level=10

Error Type =14242, Error Description Only a system administrator can reassign ownership of a job.. Error Severity  Level=16

Error Type =14243, Error Description Job '%s' started successfully.. Error Severity  Level=10

Error Type =14245, Error Description Specify either the @name, @id, or @loginname of the task(s) to be deleted.. Error Severity  Level=16

Error Type =14250, Error Description The specified %s is too long. It must contain no more than %ld characters.. Error Severity  Level=16

Error Type =14251, Error Description Cannot specify '%s' as the operator to be notified.. Error Severity  Level=16

Error Type =14252, Error Description Cannot perform this action on a job you do not own.. Error Severity  Level=16

Error Type =14253, Error Description %ld (of %ld) job(s) stopped successfully.. Error Severity  Level=10

Error Type =14254, Error Description Job '%s' stopped successfully.. Error Severity  Level=10

Error Type =14255, Error Description The owner ('%s') of this job is either an invalid login, or is not a valid user of database '%s'.. Error Severity  Level=16

Error Type =14256, Error Description Cannot start the job "%s" (ID %s) because it does not have any job server or servers defined. Associate the job with a job server by calling sp_add_jobserver.. Error Severity  Level=16

Error Type =14257, Error Description Cannot stop the job "%s" (ID %s) because it does not have any job server or servers defined. Associate the job with a job server by calling sp_add_jobserver.. Error Severity  Level=16

Error Type =14258, Error Description Cannot perform this operation while SQLServerAgent is starting. Try again later.. Error Severity  Level=16

Error Type =14260, Error Description You do not have sufficient permission to run this command. Contact your system administrator.. Error Severity  Level=16

Error Type =14261, Error Description The specified %s ('%s') already exists.. Error Severity  Level=16

Error Type =14262, Error Description The specified %s ('%s') does not exist.. Error Severity  Level=16

Error Type =14263, Error Description Target server '%s' is already a member of group '%s'.. Error Severity  Level=16

Error Type =14264, Error Description Target server '%s' is not a member of group '%s'.. Error Severity  Level=16

Error Type =14265, Error Description The MSSQLServer service terminated unexpectedly. Check the SQL Server error log and Windows System and Application event logs for possible causes.. Error Severity  Level=24

Error Type =14266, Error Description The specified '%s' is invalid (valid values are: %s).. Error Severity  Level=16

Error Type =14267, Error Description Cannot add a job to the '%s' job category.. Error Severity  Level=16

Error Type =14268, Error Description There are no jobs at this server that originated from server '%s'.. Error Severity  Level=16

Error Type =14269, Error Description Job '%s' is already targeted at server '%s'.. Error Severity  Level=16

Error Type =14270, Error Description Job '%s' is not currently targeted at server '%s'.. Error Severity  Level=16

Error Type =14271, Error Description A target server cannot be named '%s'.. Error Severity  Level=16

Error Type =14272, Error Description Object-type and object-name must be supplied as a pair.. Error Severity  Level=16

Error Type =14273, Error Description You must provide either @job_id or @job_name (and, optionally, @schedule_name), or @schedule_id.. Error Severity  Level=16

Error Type =14274, Error Description Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.. Error Severity  Level=16

Error Type =14275, Error Description The originating server must be either local server or MSX server.. Error Severity  Level=16

Error Type =14276, Error Description %s' is a permanent %s category and cannot be deleted.. Error Severity  Level=16

Error Type =14277, Error Description The command script does not destroy all the objects that it creates. Revise the command script.. Error Severity  Level=16

Error Type =14278, Error Description The schedule for this job is invalid (reason: %s).. Error Severity  Level=16

Error Type =14279, Error Description Supply either @job_name, @job_id or @originating_server.. Error Severity  Level=16

Error Type =14280, Error Description Supply either a job name (and job aspect), or one or more job filter parameters.. Error Severity  Level=16

Error Type =14281, Error Description Warning: The @new_owner_login_name parameter is not necessary when specifying a 'DELETE' action.. Error Severity  Level=10

Error Type =14282, Error Description Supply either a date (created or last modified) and a data comparator, or no date parameters at all.. Error Severity  Level=16

Error Type =14283, Error Description Supply @target_server_groups or @target_servers, or both.. Error Severity  Level=16

Error Type =14284, Error Description Cannot specify a job ID for a new job. An ID will be assigned by the procedure.. Error Severity  Level=16

Error Type =14285, Error Description Cannot add a local job to a multiserver job category.. Error Severity  Level=16

Error Type =14286, Error Description Cannot add a multiserver job to a local job category.. Error Severity  Level=16

Error Type =14287, Error Description The '%s' supplied has an invalid %s.. Error Severity  Level=16

Error Type =14288, Error Description %s cannot be before %s.. Error Severity  Level=16

Error Type =14289, Error Description %s cannot contain '%s' characters.. Error Severity  Level=16

Error Type =14290, Error Description This job is currently targeted at the local server so cannot also be targeted at a remote server.. Error Severity  Level=16

Error Type =14291, Error Description This job is currently targeted at a remote server so cannot also be targeted at the local server.. Error Severity  Level=16

Error Type =14292, Error Description There are two or more tasks named '%s'. Specify %s instead of %s to uniquely identify the task.. Error Severity  Level=16

Error Type =14293, Error Description There are two or more jobs named '%s'. Specify %s instead of %s to uniquely identify the job.. Error Severity  Level=16

Error Type =14294, Error Description Supply either %s or %s to identify the job.. Error Severity  Level=16

Error Type =14295, Error Description Frequency Type 0x2 (OnDemand) is no longer supported.. Error Severity  Level=16

Error Type =14296, Error Description This server is already enlisted into MSX '%s'.. Error Severity  Level=16

Error Type =14297, Error Description Cannot enlist into the local machine.. Error Severity  Level=16

Error Type =14298, Error Description This server is not currently enlisted into an MSX.. Error Severity  Level=16

Error Type =14299, Error Description Server '%s' is an MSX. Cannot enlist one MSX into another MSX.. Error Severity  Level=16

Error Type =14301, Error Description Logins other than the current user can only be seen by members of the sysadmin role.. Error Severity  Level=16

Error Type =14305, Error Description Column '%.*ls' does not exist in table '%.*ls'.. Error Severity  Level=16

Error Type =14306, Error Description The target server (TSX) version is not compatible with the master server (MSX) version (%ld.%ld.%ld).. Error Severity  Level=16

Error Type =14307, Error Description Access to Integration Services package '%s' is denied.. Error Severity  Level=16

Error Type =14350, Error Description Cannot initialize COM library because CoInitialize failed.. Error Severity  Level=16

Error Type =14351, Error Description Cannot complete this operation because an unexpected error occurred.. Error Severity  Level=16

Error Type =14353, Error Description Cannot determine the service account for this SQL Server instance.. Error Severity  Level=16

Error Type =14357, Error Description Cannot list '%s' in Active Directory because the name is too long. Active Directory common names cannot exceed 64 characters.. Error Severity  Level=16

Error Type =14360, Error Description %s is already configured as TSX machine. Error Severity  Level=16

Error Type =14362, Error Description The MSX server must be running the Standard or Enterprise edition of SQL Server. Error Severity  Level=16

Error Type =14363, Error Description The MSX server is not prepared for enlistments [there must be an operator named 'MSXOperator' defined at the MSX]. Error Severity  Level=16

Error Type =14364, Error Description The TSX server is not currently enlisted. Error Severity  Level=16

Error Type =14365, Error Description Specify a valid schedule_uid.. Error Severity  Level=16

Error Type =14366, Error Description Only members of sysadmin role can modify the owner of a schedule.. Error Severity  Level=16

Error Type =14367, Error Description One or more schedules were not deleted because they are being used by at least one other job. Use "sp_detach_schedule" to remove schedules from a job.. Error Severity  Level=16

Error Type =14368, Error Description Schedule "%s" was not deleted because it is being used by at least one other job. Use "sp_detach_schedule" to remove schedules from a job.. Error Severity  Level=16

Error Type =14369, Error Description The schedule ID "%s" is used by more than one job. Specify the job_id.. Error Severity  Level=16

Error Type =14370, Error Description The @originating_server must be either the local server name or the master server (MSX) name for MSX jobs on a target server (TSX).. Error Severity  Level=16

Error Type =14371, Error Description There are two or more schedules named "%s". Specify %s instead of %s to uniquely identify the schedule.. Error Severity  Level=16

Error Type =14372, Error Description The schedule was not deleted because it is being used by one or more jobs.. Error Severity  Level=16

Error Type =14373, Error Description Supply either %s or %s to identify the schedule.. Error Severity  Level=16

Error Type =14374, Error Description The specified schedule name "%s" is not associated with the job "%s".. Error Severity  Level=16

Error Type =14375, Error Description More than one schedule named "%s" is attached to job "%s". Use "sp_update_schedule" to update schedules.. Error Severity  Level=16

Error Type =14376, Error Description More than one schedule named "%s" is attached to job "%s". Use "sp_detach_schedule" to remove schedules from a job.. Error Severity  Level=16

Error Type =14377, Error Description The schedule was not attached to the specified job. The caller must own the job or the operation must be performed by a sysadmin.. Error Severity  Level=16

Error Type =14378, Error Description @sysadmin_only flag is no longer supported by SQLAgent and kept here only for backwards compatibility. Error Severity  Level=16

Error Type =14379, Error Description Table '%s' foreign key 'originating_server_id' does not have a matching value in the referenced view 'dbo.sysoriginatingservers_view'.. Error Severity  Level=16

Error Type =14380, Error Description Field 'originating_server_id' in table sysoriginatingservers is being referenced by either sysjobs or sysschedules.. Error Severity  Level=16

Error Type =14390, Error Description Only members of role sysadmin can specify the %s parameter.. Error Severity  Level=16

Error Type =14391, Error Description Only owner of a job or members of sysadmin role can detach a schedule.. Error Severity  Level=16

Error Type =14392, Error Description Only owner of a job or members of role sysadmin or SQLAgentOperatorRole can purge history of the job.. Error Severity  Level=16

Error Type =14393, Error Description Only owner of a job or members of role sysadmin or SQLAgentOperatorRole can start and stop the job.. Error Severity  Level=16

Error Type =14394, Error Description Only owner of a job schedule or members of sysadmin role can modify or delete the job schedule.. Error Severity  Level=16

Error Type =14395, Error Description %s' is a member of sysadmin server role and cannot be granted to or revoked from the proxy. Members of sysadmin server role are allowed to use any proxy.. Error Severity  Level=16

Error Type =14396, Error Description Only members of sysadmin server role can modify multi-server jobs. Error Severity  Level=16

Error Type =14397, Error Description Only members of sysadmin server role can start/stop multi-server jobs. Error Severity  Level=16

Error Type =14398, Error Description Only members of sysadmin server role can create multi-server jobs. Error Severity  Level=16

Error Type =14399, Error Description Current proxy_id %d and new proxy_id %d cannot be the same.. Error Severity  Level=16

Error Type =14400, Error Description Proxy %d does not have access to subsystem %d. Please use sp_grant_proxy_to_subsystem to grant permissions to this proxy.. Error Severity  Level=16

Error Type =14410, Error Description You must supply either a plan_name or a plan_id.. Error Severity  Level=16

Error Type =14411, Error Description Cannot delete this plan. The plan contains enlisted databases.. Error Severity  Level=16

Error Type =14412, Error Description The destination database is already part of a log shipping plan.. Error Severity  Level=16

Error Type =14413, Error Description This database is already log shipping.. Error Severity  Level=16

Error Type =14414, Error Description A log shipping monitor is already defined.. Error Severity  Level=16

Error Type =14415, Error Description The user name cannot be null when using SQL Server authentication.. Error Severity  Level=16

Error Type =14416, Error Description This stored procedure must be run in msdb.. Error Severity  Level=16

Error Type =14417, Error Description Cannot delete the monitor server while databases are participating in log shipping.. Error Severity  Level=16

Error Type =14418, Error Description The specified @backup_file_name was not created from database '%s'.. Error Severity  Level=16

Error Type =14419, Error Description The specified @backup_file_name is not a database backup.. Error Severity  Level=16

Error Type =14420, Error Description The log shipping primary database %s.%s has backup threshold of %d minutes and has not performed a backup log operation for %d minutes. Check agent log and logshipping monitor information.. Error Severity  Level=16

Error Type =14421, Error Description The log shipping secondary database %s.%s has restore threshold of %d minutes and is out of sync. No restore was performed for %d minutes. Restored latency is %d minutes. Check agent log and logshipping monitor information.. Error Severity  Level=16

Error Type =14422, Error Description Supply either @plan_id or @plan_name.. Error Severity  Level=16

Error Type =14423, Error Description Other databases are enlisted on this plan and must be removed before the plan can be deleted.. Error Severity  Level=16

Error Type =14424, Error Description The database '%s' is already involved in log shipping.. Error Severity  Level=16

Error Type =14425, Error Description The database '%s' does not seem to be involved in log shipping.. Error Severity  Level=16

Error Type =14426, Error Description A log shipping monitor is already defined. Call sp_define_log_shipping_monitor with @delete_existing = 1.. Error Severity  Level=16

Error Type =14427, Error Description A user name is necessary for SQL Server security.. Error Severity  Level=16

Error Type =14428, Error Description Could not remove the monitor as there are still databases involved in log shipping.. Error Severity  Level=16

Error Type =14429, Error Description There are still secondary servers attached to this primary.. Error Severity  Level=16

Error Type =14430, Error Description Destination path %s is not valid. Unable to list directory contents. Specify a valid destination path.. Error Severity  Level=16

Error Type =14440, Error Description Could not set single user mode.. Error Severity  Level=16

Error Type =14441, Error Description Role change succeeded.. Error Severity  Level=16

Error Type =14442, Error Description Role change failed.. Error Severity  Level=16

Error Type =14450, Error Description The specified @backup_file_name was not taken from database '%s'.. Error Severity  Level=16

Error Type =14451, Error Description The specified @backup_file_name is not a database backup.. Error Severity  Level=16

Error Type =14500, Error Description Supply either a non-zero message ID, non-zero severity, non-null performance condition, or non-null WMI namespace and query.. Error Severity  Level=16

Wednesday, June 30, 2021

SQL Error Types

Error Type =3009,/n Error Description Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.. Error Severity  Level=16

Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue ...

Error Type =3011, Error Description All backup devices must be of the same general class (for example, DISK and TAPE).. Error Severity  Level=16

Error Type =3013, Error Description %hs is terminating abnormally.. Error Severity  Level=16

Error Type =3014, Error Description %hs successfully processed %d pages in %d.%03d seconds (%d.%03d MB/sec).. Error Severity  Level=10

Error Type =3015, Error Description %hs is not yet implemented.. Error Severity  Level=16

Error Type =3016, Error Description File '%ls' of database '%ls' has been removed or shrunk since this backup or restore operation was interrupted. The operation cannot be restarted.. Error Severity  Level=16

Error Type =3017, Error Description Could not resume interrupted backup or restore operation. See the SQL Server error log for more information.. Error Severity  Level=16

Error Type =3018, Error Description There is no interrupted backup or restore operation to restart. Reissue the statement without the RESTART clause.. Error Severity  Level=16

Error Type =3019, Error Description The checkpoint file was for a different backup or restore operation. Reissue the statement without the RESTART clause.. Error Severity  Level=16

Error Type =3020, Error Description The backup operation cannot be restarted as the log has been truncated. Reissue the statement without the RESTART clause.. Error Severity  Level=16

Error Type =3021, Error Description Cannot perform a backup or restore operation within a transaction.. Error Severity  Level=16

Error Type =3023, Error Description Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.. Error Severity  Level=16

Error Type =3024, Error Description You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.. Error Severity  Level=16

Error Type =3025, Error Description Missing database name. Reissue the statement specifying a valid database name.. Error Severity  Level=16

Error Type =3026, Error Description Could not find filegroup ID %d in sysfilegroups for database '%ls'.. Error Severity  Level=16

Error Type =3027, Error Description Could not find filegroup '%.*ls' in sysfilegroups for database '%.*ls'.. Error Severity  Level=16

Error Type =3028, Error Description Operation checkpoint file is invalid. Could not restart operation. Reissue the statement without the RESTART option.. Error Severity  Level=16

Error Type =3031, Error Description Option '%ls' conflicts with option(s) '%ls'. Remove the conflicting option and reissue the statement.. Error Severity  Level=16

Error Type =3032, Error Description One or more of the options (%ls) are not supported for this statement. Review the documentation for supported options.. Error Severity  Level=16

Error Type =3033, Error Description BACKUP DATABASE cannot be used on a database opened in emergency mode.. Error Severity  Level=16

Error Type =3034, Error Description No files were selected to be processed. You may have selected one or more filegroups that have no members.. Error Severity  Level=16

Error Type =3035, Error Description Cannot perform a differential backup for database '%ls', because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.. Error Severity  Level=16

Error Type =3036, Error Description Database '%ls' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.. Error Severity  Level=16

Error Type =3037, Error Description Minimally logged operations have occurred prior to this WITH RESTART command. Reissue the BACKUP statement without WITH RESTART.. Error Severity  Level=16

Error Type =3038, Error Description The filename '%ls' is invalid as a backup device name. Reissue the BACKUP statement with a valid filename.. Error Severity  Level=16

Error Type =3039, Error Description Cannot perform a differential backup for file '%ls' because a current file backup does not exist. Reissue BACKUP DATABASE omitting the WITH DIFFERENTIAL option.. Error Severity  Level=16

Error Type =3040, Error Description An error occurred while informing replication of the backup. The backup will continue, but the replication environment should be inspected.. Error Severity  Level=10

Error Type =3041, Error Description BACKUP failed to complete the command %.*ls. Error Severity  Level=16

Error Type =3101, Error Description Exclusive access could not be obtained because the database is in use.. Error Severity  Level=16

Error Type =3108, Error Description RESTORE DATABASE must be used in single user mode when trying to restore the master database.. Error Severity  Level=16

Error Type =3110, Error Description User does not have permission to RESTORE database '%.*ls'.. Error Severity  Level=14

Error Type =3112, Error Description Cannot restore any database other than master when the server is in single user mode.. Error Severity  Level=16

Error Type =3113, Error Description The database owner (DBO) does not have an entry in sysusers in database '%.*ls'.. Error Severity  Level=21

Error Type =3114, Error Description Database '%.*ls' does not have an entry in sysdatabases.. Error Severity  Level=21

Error Type =3123, Error Description Invalid database name '%.*ls' specified for backup or restore operation.. Error Severity  Level=16

Error Type =3127, Error Description Temporary Message: The backup set does not contain pages for file '%ls'.. Error Severity  Level=16

Error Type =3128, Error Description File '%ls' has an unsupported page size (%d).. Error Severity  Level=16

Error Type =3129, Error Description Temporary Message: File '%ls' has changed size from %d to %d bytes.. Error Severity  Level=16

Error Type =3132, Error Description The media set for database '%ls' has %d family members but only %d are provided. All members must be provided.. Error Severity  Level=16

Error Type =3133, Error Description The volume on device '%ls' is not a member of the media family.. Error Severity  Level=16

Error Type =3135, Error Description The backup set in file '%ls' was created by %hs and cannot be used for this restore operation.. Error Severity  Level=16

Error Type =3136, Error Description Cannot apply the backup on device '%ls' to database '%ls'.. Error Severity  Level=16

Error Type =3138, Error Description One or more files in the backup set are no longer part of database '%ls'.. Error Severity  Level=16

Error Type =3140, Error Description Could not adjust the space allocation for file '%ls'.. Error Severity  Level=16

Error Type =3141, Error Description The database to be restored was named '%ls'. Reissue the statement using the WITH REPLACE option to overwrite the '%ls' database.. Error Severity  Level=16

Error Type =3142, Error Description File '%ls' cannot be restored over the existing '%ls'. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files.. Error Severity  Level=16

Error Type =3143, Error Description The data set on device '%ls' is not a SQL Server backup set.. Error Severity  Level=16

Error Type =3144, Error Description File '%.*ls' was not backed up in file %d on device '%ls'. The file cannot be restored from this backup set.. Error Severity  Level=16

Error Type =3145, Error Description The STOPAT option is not supported for RESTORE DATABASE. You can use the STOPAT option with RESTORE LOG.. Error Severity  Level=16

Error Type =3146, Error Description None of the newly-restored files had been modified after the backup was taken, so no further recovery actions are required. The database is now available for use.. Error Severity  Level=16

Error Type =3147, Error Description Backup and restore operations are not allowed on database tempdb.. Error Severity  Level=16

Error Type =3148, Error Description Media recovery for ALTER DATABASE is not yet implemented. The database cannot be rolled forward.. Error Severity  Level=16

Error Type =3150, Error Description The master database has been successfully restored. Shutting down SQL Server.. Error Severity  Level=10

Error Type =3151, Error Description The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.. Error Severity  Level=21

Error Type =3234, Error Description Logical file '%.*ls' is not part of database '%ls'. Use RESTORE FILELISTONLY to list the logical file names.. Error Severity  Level=15

Error Type =3241, Error Description The media family on device '%ls' is incorrectly formed. SQL Server cannot process this media family.. Error Severity  Level=16

Error Type =3242, Error Description The file on device '%ls' is not a valid Microsoft Tape Format backup set.. Error Severity  Level=16

Error Type =3243, Error Description The media family on device '%ls' was created using Microsoft Tape Format version %d.%d. SQL Server supports version %d.%d.. Error Severity  Level=16

Error Type =3244, Error Description Descriptor block size exceeds %d bytes. Use a shorter name and/or description string and retry the operation.. Error Severity  Level=16

Error Type =3245, Error Description Could not convert a string to or from Unicode, %ls.. Error Severity  Level=16

Error Type =3246, Error Description The media family on device '%ls' is marked as nonappendable. Reissue the statement using the INIT option to overwrite the media.. Error Severity  Level=16

Error Type =3247, Error Description The volume on device '%ls' has the wrong media sequence number (%d). Remove it and insert volume %d.. Error Severity  Level=16

Error Type =3248, Error Description >>> VOLUME SWITCH <<< (not for output!). Error Severity  Level=25

Error Type =3249, Error Description The volume on device '%ls' is a continuation volume for the backup set. Remove it and insert the volume holding the start of the backup set.. Error Severity  Level=16

Error Type =3250, Error Description The value '%d' is not within range for the %ls parameter.. Error Severity  Level=16

Error Type =, Error Description DBCC INDEXDEFRAG cannot be used on system table indexes. Error Severity  Level=14

Error Type =3251, Error Description The media family on device '%ls' is complete. The device is now being reused for one of the remaining families.. Error Severity  Level=10

Error Type =3253, Error Description The block size parameter must supply a value that is a power of 2.. Error Severity  Level=16

Error Type =3254, Error Description The volume on device '%ls' is empty.. Error Severity  Level=16

Error Type =3255, Error Description The data set on device '%ls' is a SQL Server backup set not compatible with this version of SQL Server.. Error Severity  Level=16

Error Type =3256, Error Description The backup set on device '%ls' was terminated while it was being created and is incomplete. RESTORE sequence is terminated abnormally.. Error Severity  Level=16

Error Type =3257, Error Description There is insufficient free space on disk volume '%ls' to create the database. The database requires %I64u additional free bytes, while only %I64u bytes are available.. Error Severity  Level=16

Error Type =3258, Error Description The volume on device '%ls' belongs to a different media set.. Error Severity  Level=16

Error Type =3259, Error Description The volume on device '%ls' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set.. Error Severity  Level=16

Error Type =3260, Error Description An internal buffer has become full.. Error Severity  Level=16

Error Type =3261, Error Description SQL Server cannot use the virtual device configuration.. Error Severity  Level=16

Error Type =3262, Error Description The backup set is valid.. Error Severity  Level=16

Error Type =3263, Error Description Cannot use the volume on device '%ls' as a continuation volume. It is sequence number %d of family %d for the current media set. Insert a new volume, or sequence number %d of family %d for the current set.. Error Severity  Level=16

Error Type =3264, Error Description The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.. Error Severity  Level=16

Error Type =3265, Error Description The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.. Error Severity  Level=16

Error Type =3266, Error Description The backup data in '%ls' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.. Error Severity  Level=16

Error Type =3267, Error Description Insufficient resources to create UMS scheduler.. Error Severity  Level=16

Error Type =3268, Error Description Cannot use the backup file '%ls' because it was originally formatted with sector size %d and is now on a device with sector size %d.. Error Severity  Level=16

Error Type =3269, Error Description Cannot restore the file '%ls' because it was originally written with sector size %d; '%ls' is now on a device with sector size %d.. Error Severity  Level=16

Error Type =3270, Error Description An internal consistency error occurred. Contact Technical Support for assistance.. Error Severity  Level=16

Error Type =3271, Error Description Nonrecoverable I/O error occurred on file '%ls'.. Error Severity  Level=16

Error Type =3272, Error Description The '%ls' device has a hardware sector size of %d, but the block size parameter specifies an incompatible override value of %d. Reissue the statement using a compatible block size.. Error Severity  Level=16

Error Type =3273, Error Description The BUFFERCOUNT parameter must supply a value that allows at least one buffer per backup device.. Error Severity  Level=16

Error Type =3274, Error Description Incorrect checksum computed for the backup set on device %ls. The backup set cannot be restored.. Error Severity  Level=16

Error Type =3275, Error Description I/O request 0x%08x failed I/O verification. See the error log for a description.. Error Severity  Level=16

Error Type =3276, Error Description WITH SNAPSHOT can be used only if the backup set was created WITH SNAPSHOT.. Error Severity  Level=16

Error Type =3277, Error Description WITH SNAPSHOT must be used with only one virtual device.. Error Severity  Level=16

Error Type =3278, Error Description Failed to encrypt string %ls. Error Severity  Level=16

Error Type =3279, Error Description Access is denied due to a password failure. Error Severity  Level=16

Error Type =3280, Error Description Backups on raw devices are not supported. '%ls' is a raw device.. Error Severity  Level=16

Error Type =3281, Error Description Released and initiated rewind on '%ls'.. Error Severity  Level=16

Error Type =3301, Error Description Invalid log record found in the transaction log (logop %d).. Error Severity  Level=21

Error Type =3313, Error Description Error while redoing logged operation in database '%.*ls'. Error at log record ID %S_LSN.. Error Severity  Level=21

Error Type =3314, Error Description Error while undoing logged operation in database '%.*ls'. Error at log record ID %S_LSN.. Error Severity  Level=21

Error Type =3315, Error Description During rollback, process %d was expected to hold mode %d lock at level %d for row %S_RID in database '%.*ls' under transaction %S_XID.. Error Severity  Level=10

Error Type =3405, Error Description Recovering database '%.*ls'.. Error Severity  Level=10

Error Type =3406, Error Description %d transactions rolled forward in database '%.*ls' (%d).. Error Severity  Level=10

Error Type =3407, Error Description %d transactions rolled back in database '%.*ls' (%d).. Error Severity  Level=10

Error Type =3408, Error Description Recovery complete.. Error Severity  Level=10

Error Type =3413, Error Description Database ID %d. Could not mark database as suspect. Getnext NC scan on sysdatabases.dbid failed.. Error Severity  Level=21

Error Type =3414, Error Description Database '%.*ls' (database ID %d) could not recover. Contact Technical Support.. Error Severity  Level=10

Error Type =3415, Error Description Database '%.*ls' is read-only or has read-only files and must be made writable before it can be upgraded.. Error Severity  Level=16

Error Type =3417, Error Description Cannot recover the master database. Exiting.. Error Severity  Level=21

Error Type =3429, Error Description Warning: The outcome of transaction %S_XID, named '%.*ls' in database '%.*ls' (database ID %d), could not be determined because the coordinating database (database ID %d) could not be opened. The transaction was assumed to be committed.. Error Severity  Level=10

Error Type =3430, Error Description Warning: Could not determine the outcome of transaction %S_XID, named '%.*ls' in database '%.*ls' (with ID %d) because the coordinating database (ID %d) did not contain the outcome. The transaction was assumed to be committed.. Error Severity  Level=10

Error Type =3431, Error Description Could not recover database '%.*ls' (database ID %d) due to unresolved transaction outcomes.. Error Severity  Level=21

Error Type =3432, Error Description Warning: syslanguages is missing.. Error Severity  Level=16

Error Type =3433, Error Description Name is truncated to '%.*ls'. The maximum name length is %d.. Error Severity  Level=16

Error Type =3434, Error Description Cannot change sort order or locale. Server shutting down. Restart SQL Server to continue with sort order unchanged.. Error Severity  Level=20

Error Type =3435, Error Description Sort order or locale cannot be changed because user objects or user databases exist.. Error Severity  Level=20

Error Type =3436, Error Description Cannot rebuild index for the '%.*ls' table in the '%.*ls' database.. Error Severity  Level=16

Error Type =3437, Error Description Error recovering database '%.*ls'. Could not connect to MSDTC to check the completion status of transaction %S_XID.. Error Severity  Level=21

Error Type =3438, Error Description Database '%.*ls' (database ID %d) failed to recover because transaction first LSN is not equal to LSN in checkpoint. Contact Technical Support.. Error Severity  Level=10

Error Type =3439, Error Description Database '%.*ls' (database ID %d). The DBCC RECOVERDB statement failed due to previous errors.. Error Severity  Level=10

Error Type =3440, Error Description Database '%.*ls' (database ID %d). The DBCC RECOVERDB statement can only be run after a RESTORE statement that used the WITH NORECOVERY option.. Error Severity  Level=21

Error Type =3441, Error Description Database '%.*ls' (database ID %d). The RESTORE statement could not access file '%ls'. Error was '%ls'.. Error Severity  Level=21

Error Type =3442, Error Description Database '%.*ls' (database ID %d). The size of the undo file is insufficient.. Error Severity  Level=21

Error Type =3443, Error Description Database '%.*ls' (database ID %d) was marked for standby or read-only use, but has been modified. The RESTORE LOG statement cannot be performed.. Error Severity  Level=21

Error Type =3445, Error Description File '%ls' is not a valid undo file for database '%.*ls', database ID %d.. Error Severity  Level=21

Error Type =3450, Error Description Recovery of database '%.*ls' (%d) is %d%% complete (approximately %d more seconds) (Phase %d of 3).. Error Severity  Level=10

Error Type =3604, Error Description Duplicate key was ignored.. Error Severity  Level=10

Error Type =3605, Error Description Duplicate row was ignored.. Error Severity  Level=10

Error Type =3606, Error Description Arithmetic overflow occurred.. Error Severity  Level=10

Error Type =3607, Error Description Division by zero occurred.. Error Severity  Level=10

Error Type =3608, Error Description Cannot allocate a GUID for the token.. Error Severity  Level=16

Error Type =3612, Error Description %hsSQL Server Execution Times:%hs CPU time = %lu ms, elapsed time = %lu ms.. Error Severity  Level=10

Error Type =3613, Error Description SQL Server parse and compile time: %hs CPU time = %lu ms, elapsed time = %lu ms.. Error Severity  Level=10

Error Type =3615, Error Description Table '%.*ls'. Scan count %d, logical reads %d, physical reads %d, read-ahead reads %d.. Error Severity  Level=10

Error Type =3618, Error Description The transaction has been terminated.. Error Severity  Level=10

Error Type =3619, Error Description Could not write a CHECKPOINT record in database ID %d because the log is out of space.. Error Severity  Level=10

Error Type =3620, Error Description Automatic checkpointing is disabled in database '%.*ls' because the log is out of space. It will continue when the database owner successfully checkpoints the database. Free up some space or extend the database and then run the CHECKPOINT statement.. Error Severity  Level=10

Error Type =3621, Error Description The statement has been terminated.. Error Severity  Level=10

Error Type =3622, Error Description A domain error occurred.. Error Severity  Level=10

Error Type =3625, Error Description %hs' is not yet implemented.. Error Severity  Level=20

Error Type =3627, Error Description Could not create worker thread.. Error Severity  Level=16

Error Type =3628, Error Description A floating point exception occurred in the user process. Current transaction is canceled.. Error Severity  Level=24

Error Type =3629, Error Description This SQL Server has been optimized for %d concurrent queries. This limit has been exceeded by %d queries and performance may be adversely affected.. Error Severity  Level=10

Error Type =3630, Error Description Concurrency violations since %ls%s 1 2 3 4 5 6 7 8 9 10-100 >100%s%6u%6u%6u%6u%6u%6u%6u%6u%6u%8u%6u. Error Severity  Level=10

Error Type =3631, Error Description Concurrency violations will be written to the SQL Server error log.. Error Severity  Level=10

Error Type =3632, Error Description Concurrency violations will not be written to the SQL Server error log.. Error Severity  Level=10

Error Type =3701, Error Description Cannot %S_MSG the %S_MSG '%.*ls', because it does not exist in the system catalog.. Error Severity  Level=11

Error Type =3702, Error Description Cannot drop the %S_MSG '%.*ls' because it is currently in use.. Error Severity  Level=16

Error Type =3703, Error Description Cannot detach the %S_MSG '%.*ls' because it is currently in use.. Error Severity  Level=16

Error Type =3704, Error Description User does not have permission to perform this operation on %S_MSG '%.*ls'.. Error Severity  Level=16

Error Type =3705, Error Description Cannot use DROP %ls with '%.*ls' because '%.*ls' is a %S_MSG. Use DROP %ls.. Error Severity  Level=16

Error Type =3708, Error Description Cannot %S_MSG the %S_MSG '%.*ls' because it is a system %S_MSG.. Error Severity  Level=16

Error Type =3716, Error Description The %S_MSG '%.*ls' cannot be dropped because it is bound to one or more %S_MSG.. Error Severity  Level=16

Error Type =3718, Error Description Could not drop index '%.*ls' because the table or clustered index entry cannot be found in the sysindexes system table.. Error Severity  Level=11

Error Type =3723, Error Description An explicit DROP INDEX is not allowed on index '%.*ls'. It is being used for %ls constraint enforcement.. Error Severity  Level=16

Error Type =3724, Error Description Cannot %S_MSG the %S_MSG '%.*ls' because it is being used for replication.. Error Severity  Level=16

Error Type =3725, Error Description The constraint '%.*ls' is being referenced by table '%.*ls', foreign key constraint '%.*ls'.. Error Severity  Level=16

Error Type =3726, Error Description Could not drop object '%.*ls' because it is referenced by a FOREIGN KEY constraint.. Error Severity  Level=10

Error Type =3727, Error Description Could not drop constraint. See previous errors.. Error Severity  Level=10

Error Type =3728, Error Description %.*ls' is not a constraint.. Error Severity  Level=16

Error Type =3729, Error Description Cannot DROP TABLE 'Table Name' because it is being referenced by object 'Object Name'.. Error Severity  Level=16

Error Type =3733, Error Description Constraint '%.*ls' does not belong to table '%.*ls'.. Error Severity  Level=16

Error Type =3736, Error Description Cannot drop the %S_MSG '%.*ls' because it is being used for distribution.. Error Severity  Level=16

Error Type =3737, Error Description Could not delete file '%ls'. See the SQL Server error log for more information.. Error Severity  Level=16

Error Type =3738, Error Description Deleting database file '%ls'.. Error Severity  Level=16

Error Type =3739, Error Description Cannot %ls the index '%.*ls' because it is not a statistics collection.. Error Severity  Level=15

Error Type =3902, Error Description The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.. Error Severity  Level=13

Error Type =3903, Error Description The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.. Error Severity  Level=13

Error Type =3904, Error Description Cannot unsplit logical page %S_PGID in object '%.*ls', in database '%.*ls'. Both pages together contain more data than will fit on one page.. Error Severity  Level=21

Error Type =3906, Error Description Could not run BEGIN TRANSACTION in database '%.*ls' because the database is read-only.. Error Severity  Level=16

Error Type =3908, Error Description Could not run BEGIN TRANSACTION in database '%.*ls' because the database is in bypass recovery mode.. Error Severity  Level=16

Error Type =3909, Error Description Session binding token is invalid.. Error Severity  Level=16

Error Type =3910, Error Description Transaction context in use by another session.. Error Severity  Level=16

Error Type =3912, Error Description Cannot bind using an XP token while the server is not in an XP call.. Error Severity  Level=16

Error Type =3914, Error Description The data type '%s' is invalid for transaction names or savepoint names. Allowed data types are char, varchar, nchar, or nvarchar.. Error Severity  Level=16

Error Type =3915, Error Description Cannot use the ROLLBACK statement within an INSERT-EXEC statement.. Error Severity  Level=16

Error Type =3916, Error Description Cannot use the COMMIT statement within an INSERT-EXEC statement unless BEGIN TRANSACTION is used first.. Error Severity  Level=16

Error Type =3917, Error Description Session is bound to a transaction context that is in use. Other statements in the batch were ignored.. Error Severity  Level=16

Error Type =3918, Error Description Statement must be executed in the context of a user transaction.. Error Severity  Level=16

Error Type =3919, Error Description Cannot enlist in the transaction because the transaction has already been committed or rolled back.. Error Severity  Level=16

Error Type =3920, Error Description The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.. Error Severity  Level=10

Error Type =3921, Error Description Cannot get a transaction token if there is no transaction active. Reissue the statement after a transaction has been started. Error Severity  Level=16

Error Type =3922, Error Description Cannot enlist in the transaction because the transaction does not exist.. Error Severity  Level=16

Error Type =3923, Error Description Cannot use transaction marks on database '%.*ls' with bulk-logged operations that have not been backed up. The mark is ignored.. Error Severity  Level=10

Error Type =3924, Error Description The session was enlisted in an active user transaction while trying to bind to a new transaction. The session has defected from the previous user transaction.. Error Severity  Level=10

Error Type =3925, Error Description Invalid transaction mark name. The 'LSN:' prefix is reserved.. Error Severity  Level=16

Error Type =3926, Error Description The transaction active in this session has been committed or aborted by another session.. Error Severity  Level=10

Error Type =3927, Error Description The session had an active transaction when it tried to enlist in a Distributed Transaction Coordinator transaction.. Error Severity  Level=10

Error Type =3928, Error Description The marked transaction '%.*ls' failed. A Deadlock was encountered while attempting to place the mark in the log.. Error Severity  Level=16

Monday, May 31, 2021

Error Type and Severity

Error Type =4003,/n Error Description ODS error. Server is terminating this connection.. Error Severity  Level=21

A High Level Comparison Between Oracle and SQL Server – Part IV ...

Error Type =4004, Error Description Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.. Error Severity  Level=16

Error Type =4015, Error Description Language requested in login '%.*ls' is not an official name on this SQL Server. Using server-wide default %.*ls instead.. Error Severity  Level=16

Error Type =4016, Error Description Language requested in 'login %.*ls' is not an official name on this SQL Server. Using user default %.*ls instead.. Error Severity  Level=16

Error Type =4017, Error Description Neither the language requested in 'login %.*ls' nor user default language %.*ls is an official language name on this SQL Server. Using server-wide default %.*ls instead.. Error Severity  Level=16

Error Type =4018, Error Description User default language %.*ls is not an official language name on this SQL Server. Using server-wide default %.*ls instead.. Error Severity  Level=16

Error Type =4019, Error Description Language requested in login '%.*ls' is not an official language name on this SQL Server. Login fails.. Error Severity  Level=16

Error Type =4020, Error Description Default date order '%.*ls' for language %.*ls is invalid. Using mdy instead.. Error Severity  Level=16

Error Type =4027, Error Description Mount tape for %hs of database '%ls'.. Error Severity  Level=16

Error Type =4028, Error Description End of tape has been reached. Remove tape '%ls' and mount next tape for %hs of database '%ls'.. Error Severity  Level=16

Error Type =4030, Error Description The medium on device '%ls' expires on %hs and cannot be overwritten.. Error Severity  Level=10

Error Type =4035, Error Description Processed %d pages for database '%ls', file '%ls' on file %d.. Error Severity  Level=10

Error Type =4037, Error Description User-specified volume ID '%ls' does not match the volume ID '%ls' of the device '%ls'.. Error Severity  Level=16

Error Type =4038, Error Description Cannot find file ID %d on device '%ls'.. Error Severity  Level=16

Error Type =4060, Error Description Cannot open database requested in login '%.*ls'. Login fails.. Error Severity  Level=11

Error Type =4061, Error Description Cannot open either database requested in login (%.*ls) or user default database. Using master database instead.. Error Severity  Level=11

Error Type =4062, Error Description Cannot open user default database. Using master database instead.. Error Severity  Level=11

Error Type =4063, Error Description Cannot open database requested in login (%.*ls). Using user default '%.*ls' instead.. Error Severity  Level=11

Error Type =4064, Error Description Cannot open user default database. Login failed.. Error Severity  Level=11

Error Type =4104, Error Description The multi-part identifier could not be bound.. Error Severity  Level=16

Error Type =4208, Error Description The statement %hs is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.. Error Severity  Level=16

Error Type =4212, Error Description Cannot back up the log of the master database. Use BACKUP DATABASE instead.. Error Severity  Level=16

Error Type =4214, Error Description There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.. Error Severity  Level=10

Error Type =4215, Error Description The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.. Error Severity  Level=10

Error Type =4216, Error Description Minimally logged operations cannot be backed up when the database is unavailable.. Error Severity  Level=16

Error Type =4217, Error Description BACKUP LOG cannot modify the database because database is read-only. The backup will continue,although subsequent backups will duplicate the work of this backup.. Error Severity  Level=10

Error Type =4301, Error Description Database in use. The system administrator must have exclusive use of the database to restore the log.. Error Severity  Level=16

Error Type =4304, Error Description A USER ATTENTION signal raised during RESTORE LOG is being ignored until the current restore completes.. Error Severity  Level=16

Error Type =4305, Error Description The log in this backup set begins at LSN %.*ls, which is too late to apply to the database. An earlier log backup that includes LSN %.*ls can be restored.. Error Severity  Level=16

Error Type =4306, Error Description The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.. Error Severity  Level=16

Error Type =4316, Error Description Can only RESTORE LOG in the master database if SQL Server is in single user mode.. Error Severity  Level=16

Error Type =4318, Error Description File '%ls' has been rolled forward to LSN %.*ls. This log terminates at LSN %.*ls, which is too early to apply the WITH RECOVERY option. Reissue the RESTORE LOG statement WITH NORECOVERY.. Error Severity  Level=16

Error Type =4320, Error Description File '%ls' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.. Error Severity  Level=16

Error Type =4322, Error Description This log file contains records logged before the designated point-in-time. The database is being left in load state so you can apply another log file.. Error Severity  Level=10

Error Type =4323, Error Description The database is marked suspect. Transaction logs cannot be restored. Use RESTORE DATABASE to recover the database.. Error Severity  Level=16

Error Type =4324, Error Description Backup history older than %ls has been deleted.. Error Severity  Level=10

Error Type =4325, Error Description Could not delete entries for backup set ID '%ls'.. Error Severity  Level=16

Error Type =4326, Error Description The log in this backup set terminates at LSN %.*ls, which is too early to apply to the database. A more recent log backup that includes LSN %.*ls can be restored.. Error Severity  Level=16

Error Type =4327, Error Description The log in this backup set contains minimally logged changes. Point-in-time recovery is inhibited. RESTORE will roll forward to end of logs without recovering the database.. Error Severity  Level=16

Error Type =4328, Error Description File '%ls' is missing. Rollforward stops at log sequence number %.*ls. File is created at LSN %.*ls, dropped at LSN %.*ls. Restore transaction log beyond point in time when file was dropped or restore data to be consistent with rest of database.. Error Severity  Level=16

Error Type =4329, Error Description This log file contains records logged before the designated mark. The database is being left in load state so you can apply another log file.. Error Severity  Level=10

Error Type =4330, Error Description The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database.. Error Severity  Level=16

Error Type =4331, Error Description The database cannot be recovered because the files have been restored to inconsistent points in time.. Error Severity  Level=16

Error Type =4332, Error Description RESTORE LOG has been halted. To use the database in its current state, run RESTORE DATABASE %ls WITH RECOVERY.. Error Severity  Level=16

Error Type =4333, Error Description The database cannot be recovered because the log was not restored.. Error Severity  Level=16

Error Type =4334, Error Description The named mark does not identify a valid LSN.. Error Severity  Level=16

Error Type =4403, Error Description View or function '%.*ls' is not updatable because it contains aggregates.. Error Severity  Level=16

Error Type =4404, Error Description View or function '%.*ls' is not updatable because the definition contains the DISTINCT clause.. Error Severity  Level=16

Error Type =4405, Error Description View or function '%.*ls' is not updatable because the modification affects multiple base tables.. Error Severity  Level=16

Error Type =4406, Error Description Update or insert of view or function '%.*ls' failed because it contains a derived or constant field.. Error Severity  Level=16

Error Type =4408, Error Description The query and the views or functions in it exceed the limit of %d tables.. Error Severity  Level=19

Error Type =4413, Error Description Could not use view or function '%.*ls' because of binding errors.. Error Severity  Level=16

Error Type =4414, Error Description Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (%d) was exceeded.. Error Severity  Level=16

Error Type =4415, Error Description View '%.*ls' is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times in the resulting query.. Error Severity  Level=16

Error Type =4416, Error Description UNION ALL view '%.*ls' is not updatable because the definition contains a disallowed construct.. Error Severity  Level=16

Error Type =4417, Error Description Derived table '%.*ls' is not updatable because the definition contains a UNION operator.. Error Severity  Level=16

Error Type =4418, Error Description Derived table '%.*ls' is not updatable because it contains aggregates.. Error Severity  Level=16

Error Type =4419, Error Description Derived table '%.*ls' is not updatable because the definition contains the DISTINCT clause.. Error Severity  Level=16

Error Type =4420, Error Description Derived table '%.*ls' is not updatable because the modification affects multiple base tables.. Error Severity  Level=16

Error Type =4421, Error Description Derived table '%.*ls' is not updatable because a column of the derived table is derived or constant.. Error Severity  Level=16

Error Type =4422, Error Description View '%.*ls' has an INSTEAD OF UPDATE trigger and cannot be a target of an UPDATE FROM statement.. Error Severity  Level=16

Error Type =4423, Error Description View '%.*ls' has an INSTEAD OF DELETE trigger and cannot be a target of a DELETE FROM statement.. Error Severity  Level=16

Error Type =4424, Error Description Joined tables cannot be specified in a query containing outer join operators. View or function '%.*ls' contains joined tables.. Error Severity  Level=16

Error Type =4425, Error Description Cannot specify outer join operators in a query containing joined tables. View or function '%.*ls' contains outer join operators.. Error Severity  Level=16

Error Type =4427, Error Description The view or function '%.*ls' is not updatable because the definition contains the TOP clause.. Error Severity  Level=16

Error Type =4428, Error Description The derived table '%.*ls' is not updatable because the definition contains the TOP clause.. Error Severity  Level=16

Error Type =4429, Error Description View or function '%.*ls' contains a self-reference. Views or functions cannot reference themselves directly or indirectly.. Error Severity  Level=16

Error Type =4430, Error Description Warning: Index hints supplied for view '%.*ls' will be ignored.. Error Severity  Level=10

Error Type =4431, Error Description Partitioned view '%.*ls' is not updatable because table '%.*ls' has a timestamp column.. Error Severity  Level=16

Error Type =4432, Error Description Partitioned view '%.*ls' is not updatable because table '%.*ls' has a DEFAULT constraint.. Error Severity  Level=16

Error Type =4433, Error Description Cannot INSERT into partitioned view ''%.*ls'' because table ''%.*ls'' has an IDENTITY constraint.. Error Severity  Level=16

Error Type =4434, Error Description Partitioned view '%.*ls' is not updatable because table '%.*ls' has an INSTEAD OF trigger.. Error Severity  Level=16

Error Type =4435, Error Description Partitioned view '%.*ls' is not updatable because a value was not specified for partitioning column '%.*ls'.. Error Severity  Level=16

Error Type =4436, Error Description UNION ALL view '%.*ls' is not updatable because a partitioning column was not found.. Error Severity  Level=16

Error Type =4437, Error Description Partitioned view '%.*ls' is not updatable as the target of a bulk operation.. Error Severity  Level=16

Error Type =4438, Error Description Partitioned view '%.*ls' is not updatable because it does not deliver all columns from its member tables.. Error Severity  Level=16

Error Type =4439, Error Description Partitioned view '%.*ls' is not updatable because the source query contains references to partition table '%.*ls'.. Error Severity  Level=16

Error Type =4440, Error Description UNION ALL view '%.*ls' is not updatable because a primary key was not found on table '%.*ls'.. Error Severity  Level=16

Error Type =4441, Error Description Partitioned view '%.*ls' is not updatable because the table '%.*ls' has an index on a computed column.. Error Severity  Level=16

Error Type =4442, Error Description UNION ALL view '%.*ls' is not updatable because base table '%.*ls' is used multiple times.. Error Severity  Level=16

Error Type =4443, Error Description UNION ALL view '%.*ls' is not updatable because column '%.*ls' of base table '%.*ls' is used multiple times.. Error Severity  Level=16

Error Type =4444, Error Description UNION ALL view '%.*ls' is not updatable because the primary key of table '%.*ls' is not included in the union result.. Error Severity  Level=16

Error Type =4445, Error Description UNION ALL view '%.*ls' is not updatable because the primary key of table '%.*ls' is not unioned with primary keys of preceding tables.. Error Severity  Level=16

Error Type =4446, Error Description UNION ALL view '%.*ls' is not updatable because the definiton of column '%.*ls' of view '%.*ls' is used by another view column.. Error Severity  Level=16

Error Type =4447, Error Description View '%.*ls' is not updatable because the definition contains a set operator.. Error Severity  Level=16

Error Type =4448, Error Description Cannot INSERT into partitioned view '%.*ls' because values were not supplied for all columns.. Error Severity  Level=16

Error Type =4449, Error Description Using defaults is not allowed in views that contain a set operator.. Error Severity  Level=16

Error Type =4450, Error Description Cannot update partitioned view '%.*ls' because the definition of the view column '%.*ls' in table '%.*ls' has a IDENTITY constraint.. Error Severity  Level=16

Error Type =4451, Error Description Views referencing tables on multiple servers are not updatable on this SKU of SQL Server.. Error Severity  Level=16

Error Type =4501, Error Description View or function ''%.*ls'' has more columns defined than column names given.. Error Severity  Level=16

Error Type =4502, Error Description View or function <View or Function Name> has more column names specified than columns defined.. Error Severity  Level=16

Error Type =4505, Error Description CREATE VIEW failed because column '%.*ls' in view '%.*ls' exceeds the maximum of %d columns.. Error Severity  Level=16

Error Type =4506, Error Description Column names in each view or function must be unique. Column name '<Column Name>' in view or function '<View or Function Name>' is specified more than once.. Error Severity  Level=10

Error Type =4508, Error Description Views or functions are not allowed on temporary tables. Table names that begin with '#' denote temporary tables.. Error Severity  Level=16

Error Type =4509, Error Description Could not perform CREATE VIEW because WITH %ls was specified and the view contains set operators.. Error Severity  Level=16

Error Type =4510, Error Description Could not perform CREATE VIEW because WITH %ls was specified and the view is not updatable.. Error Severity  Level=16

Error Type =4511, Error Description Create View or Function failed because no column name was specified for column <Column Number>.. Error Severity  Level=16

Error Type =4512, Error Description Cannot schema bind %S_MSG '%.*ls' because name '%.*ls' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.. Error Severity  Level=16

Error Type =4513, Error Description Cannot schema bind %S_MSG '%.*ls'. '%.*ls' is not schema bound.. Error Severity  Level=16

Error Type =4514, Error Description CREATE FUNCTION failed because a column name is not specified for column <Column Number>.. Error Severity  Level=16

Error Type =4515, Error Description CREATE FUNCTION failed because column '%.*ls' in function '%.*ls' exceeds the maximum of %d columns.. Error Severity  Level=16

Error Type =4516, Error Description Cannot schema bind function '%.*ls' because it contains an EXECUTE statement.. Error Severity  Level=16

Error Type =, Error Description %d transactions rolled back in database '%.*ls' (%d).. Error Severity  Level=10

Error Type =4602, Error Description Only members of the sysadmin role can grant or revoke the CREATE DATABASE permission.. Error Severity  Level=14

Error Type =4604, Error Description There is no such user or group '%.*ls'.. Error Severity  Level=16

Error Type =4606, Error Description Granted or revoked privilege %ls is not compatible with object.. Error Severity  Level=16

Error Type =4610, Error Description You can only grant or revoke permissions on objects in the current database.. Error Severity  Level=16

Error Type =4611, Error Description To revoke grantable privileges, specify the CASCADE option with REVOKE.. Error Severity  Level=16

Error Type =4613, Error Description Grantor does not have GRANT permission.. Error Severity  Level=16

Error Type =4615, Error Description Invalid column name '%.*ls'.. Error Severity  Level=16

Error Type =4617, Error Description Cannot grant, deny or revoke permissions to or from special roles.. Error Severity  Level=16

Error Type =4618, Error Description You do not have permission to use %.*ls in the AS clause.. Error Severity  Level=16

Error Type =4619, Error Description CREATE DATABASE permission can only be granted in the master database.. Error Severity  Level=16

Error Type =4701, Error Description Could not truncate table '%.*ls' because this table does not exist in database '%.*ls'.. Error Severity  Level=11

Error Type =4706, Error Description Could not truncate table '%.*ls' because there is not enough room in the log to record the deallocation of all the index and data pages.. Error Severity  Level=17

Error Type =4707, Error Description Could not truncate object '%.*ls' because it or one of its indexes resides on a READONLY filegroup.. Error Severity  Level=16

Error Type =4708, Error Description Could not truncate object '%.*ls' because it is not a table.. Error Severity  Level=16

Error Type =4709, Error Description You are not allowed to truncate the system table '%.*ls'.. Error Severity  Level=16

Error Type =4711, Error Description Cannot truncate table '%.*ls' because it is published for replication.. Error Severity  Level=16

Error Type =4712, Error Description Cannot truncate table <Table Name> because it is being referenced by a FOREIGN KEY constraint.. Error Severity  Level=16

Error Type =4803, Error Description Received invalid row length %d from bcp client. Maximum row size is %d.. Error Severity  Level=21

Error Type =4804, Error Description Premature end-of-message while reading current row from host. Host program may have terminated.. Error Severity  Level=21

Error Type =4805, Error Description The front-end tool you are using does not support the feature of bulk insert from host. Use the proper tools for this command.. Error Severity  Level=17

Error Type =4807, Error Description Received invalid row length %d from bcp client. Minimum row size is %d.. Error Severity  Level=21

Error Type =4808, Error Description Bulk copy operations cannot trigger BULK INSERT statements.. Error Severity  Level=16

Error Type =4810, Error Description Expected the TEXT token in data stream for bulk copy of text or image data.. Error Severity  Level=16

Error Type =4811, Error Description Expected the column offset in data stream for bulk copy of text or image data.. Error Severity  Level=16

Error Type =4812, Error Description Expected the row offset in data stream for bulk copy of text or image data.. Error Severity  Level=16

Error Type =4813, Error Description Expected the text length in data stream for bulk copy of text, ntext, or image data.. Error Severity  Level=16

Error Type =4815, Error Description Received invalid column length from bcp client.. Error Severity  Level=21

Error Type =4817, Error Description Could not bulk insert. Invalid sorted column '%.*ls'. Assuming data stream is not sorted.. Error Severity  Level=16

Error Type =4818, Error Description Could not bulk insert. Sorted column '%.*ls' was specified more than once. Assuming data stream is not sorted.. Error Severity  Level=16

Error Type =4819, Error Description Could not bulk insert. Bulk data stream was incorrectly specified as sorted.. Error Severity  Level=16

Error Type =4820, Error Description Could not bulk insert. Unknown version of format file '%s'.. Error Severity  Level=16

Error Type =4821, Error Description Could not bulk insert. Error reading the number of columns from format file '%s'.. Error Severity  Level=16

Error Type =4822, Error Description Could not bulk insert. Invalid number of columns in format file '%s'.. Error Severity  Level=16

Error Type =4823, Error Description Could not bulk insert. Invalid column number in format file '%s'.. Error Severity  Level=16

Error Type =4824, Error Description Could not bulk insert. Invalid data type for column number %d in format file '%s'.. Error Severity  Level=16

Error Type =4825, Error Description Could not bulk insert. Invalid prefix for column number %d in format file '%s'.. Error Severity  Level=16

Error Type =4826, Error Description Could not bulk insert. Invalid column length for column number %d in format file '%s'.. Error Severity  Level=16

Error Type =4827, Error Description Could not bulk insert. Invalid column terminator for column number %d in format file '%s'.. Error Severity  Level=16

Error Type =4828, Error Description Could not bulk insert. Invalid destination table column number for source column %d in format file '%s'.. Error Severity  Level=16

Error Type =4829, Error Description Could not bulk insert. Error reading destination table column name for source column %d in format file '%s'.. Error Severity  Level=16

Error Type =4830, Error Description Bulk Insert: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.. Error Severity  Level=10

Error Type =4831, Error Description Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.. Error Severity  Level=16

Error Type =4832, Error Description Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.. Error Severity  Level=16

Error Type =4833, Error Description Bulk Insert: Version mismatch between the provider dynamic link library and the server executable.. Error Severity  Level=16

Error Type =4834, Error Description You do not have permission to use the BULK INSERT statement.. Error Severity  Level=16

Error Type =4835, Error Description Bulk copying into a table with computed columns is not supported for downlevel clients.. Error Severity  Level=16

Error Type =4837, Error Description Error: Cannot bulk copy into a table '%s' enabled for immediate-updating subscriptions. Error Severity  Level=16

Error Type =4838, Error Description The bulk data source does not support the SQLNUMERIC or SQLDECIMAL data types.. Error Severity  Level=16

Error Type =4839, Error Description Cannot perform bulk insert. Invalid collation name for source column %d in format file '%s'.. Error Severity  Level=16

Error Type =4840, Error Description The bulk data source provider string has an invalid %ls property value %ls.. Error Severity  Level=16

Error Type =4841, Error Description The data source name is not a simple object name.. Error Severity  Level=16

Error Type =4842, Error Description The required FormatFile property is missing from the provider string of the server.. Error Severity  Level=16

Error Type =4843, Error Description The bulk data source provider string has a syntax error ('%lc') near character position %d.. Error Severity  Level=16

Error Type =4844, Error Description The bulk data source provider string has an unsupported property name (%ls).. Error Severity  Level=16

Error Type =4845, Error Description The bulk data source provider string has a syntax error near character position %d. Expected '%lc', but found '%lc'.. Error Severity  Level=16

Error Type =4846, Error Description The bulk data provider failed to allocate memory.. Error Severity  Level=16

Error Type =4847, Error Description Bulk copying into a table with bigint columns is not supported for versions earlier than SQL Server 2000.. Error Severity  Level=16

Error Type =4848, Error Description Bulk copying into a table with sql_variant columns is not supported for versions earlier than SQL Server 2000.. Error Severity  Level=16

Error Type =4849, Error Description Could not import table '%ls'. Error %d.. Error Severity  Level=16

Error Type =4850, Error Description Data import: Table '%ls' is already locked by another user.. Error Severity  Level=10

Error Type =4851, Error Description Data import: Table '%ls' already has data. Skipping to next table.. Error Severity  Level=10

Error Type =4852, Error Description Data import: Table '%ls' does not exist or it is not a user table.. Error Severity  Level=10

Error Type =4853, Error Description %hs. Error Severity  Level=10

Error Type =4854, Error Description %hs. Error Severity  Level=21

Error Type =4860, Error Description Could not bulk insert. File '%ls' does not exist.. Error Severity  Level=16

Error Type =4861, Error Description Could not bulk insert because file '%ls' could not be opened. Operating system error code %ls.. Error Severity  Level=16

Error Type =4862, Error Description Could not bulk insert because file '%ls' could not be read. Operating system error code %ls.. Error Severity  Level=16

Error Type =4863, Error Description Bulk insert data conversion error (truncation) for row %d, column %d (%ls).. Error Severity  Level=16

Error Type =4864, Error Description Bulk insert data conversion error (type mismatch) for row %d, column %d (%ls).. Error Severity  Level=16

Error Type =4865, Error Description Could not bulk insert because the maximum number of errors (%d) was exceeded.. Error Severity  Level=16

Error Type =4866, Error Description Bulk Insert fails. Column is too long in the data file for row %d, column %d. Make sure the field terminator and row terminator are specified correctly.. Error Severity  Level=16

Error Type =4867, Error Description Bulk insert data conversion error (overflow) for row %d, column %d (%ls).. Error Severity  Level=16

Error Type =4868, Error Description Bulk Insert fails. Codepage '%d' is not installed. Install the codepage and run the command again.. Error Severity  Level=16

Error Type =4869, Error Description Bulk Insert failed. Unexpected NULL value in data file row %d, column %d. Destination column (%ls) is defined NOT NULL.. Error Severity  Level=16

Error Type =4880, Error Description Could not bulk insert. When using the FIRSTROW and LASTROW parameters, the value for FIRSTROW cannot be greater than the value for LASTROW.. Error Severity  Level=16

Error Type =4881, Error Description Note: Bulk Insert through a view may result in base table default values being ignored for NULL columns in the data file.. Error Severity  Level=10

Error Type =4882, Error Description Could not bulk insert. Prefix length, field length, or terminator required for source column %d in format file '%s'.. Error Severity  Level=16

Error Type =4901, Error Description ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column '<Column Name>;' cannot be added to table '<Table Name>' because it does not allow nulls and does not specify a DEFAULT definition.. Error Severity  Level=16

Error Type =4902, Error Description Cannot alter table '%.*ls' because this table does not exist in database '%.*ls'.. Error Severity  Level=11

Error Type =4909, Error Description Cannot alter '%.*ls' because it is not a table.. Error Severity  Level=16

Error Type =4910, Error Description Only the owner or members of the sysadmin role can alter table '%.*ls'.. Error Severity  Level=16

Error Type =4916, Error Description Could not enable or disable the constraint. See previous errors.. Error Severity  Level=16

Error Type =4917, Error Description Constraint '%.*ls' does not exist.. Error Severity  Level=16

Error Type =4920, Error Description ALTER TABLE failed because trigger '%.*ls' on table '%.*ls' does not exist.. Error Severity  Level=16

Error Type =4921, Error Description ALTER TABLE failed because trigger '%.*ls' does not belong to table '%.*ls'.. Error Severity  Level=16

Error Type =4922, Error Description %ls %.*ls failed because one or more objects access this column.. Error Severity  Level=16

Error Type =4923, Error Description ALTER TABLE DROP COLUMN failed because '%.*ls' is the only data column in table '%.*ls'. A table must have at least one data column.. Error Severity  Level=16

Error Type =4924, Error Description %ls failed because column '%.*ls' does not exist in table '%.*ls'.. Error Severity  Level=16

Error Type =4925, Error Description ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table '%.*ls' with ROWGUIDCOL property.. Error Severity  Level=16

Error Type =4926, Error Description ALTER TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table '%.*ls' with ROWGUIDCOL property.. Error Severity  Level=16

Error Type =4927, Error Description Cannot alter column '%.*ls' to be data type %.*ls.. Error Severity  Level=16

Error Type =4928, Error Description Cannot alter column <Column Name> because it is COMPUTED.. Error Severity  Level=16

Error Type =4929, Error Description Cannot alter the %S_MSG '%.*ls' because it is being published for replication.. Error Severity  Level=16

Error Type =4930, Error Description Warning: Columns added to the replicated table %S_MSG '%.*ls' will be ignored by existing articles.. Error Severity  Level=10

Error Type =4931, Error Description Cannot add columns to %S_MSG '%.*ls' because it is being published for merge replication.. Error Severity  Level=16

Error Type =4932, Error Description ALTER TABLE DROP COLUMN failed because '%.*ls' is currently replicated.. Error Severity  Level=16

Translate