SQL Server Errors or Failures from Error: 40138 to Error: 40161

SQLServerF1

Error: 40138, Severity: 16, Query references entities from multiple partitions.

Error: 40139, Severity: 16, The data node does not host a replica of the requested partition.
Error: 40140, Severity: 16, Set partition failed since a different partition already was set in the current transaction.
Error: 40141, Severity: 16, Partition has to be set using sp_set_partition before executing this query.
Error: 40142, Severity: 16, Accessing a different partition in the same transaction is not allowed.
Error: 40143, Severity: 16, The replica that the data node hosts for the requested partition is not primary.

Error: 40144, Severity: 16, Cannot find the object “%.*ls” because it does not exist or you do not have permissions.
Error: 40145, Severity: 16, Database is not found.
Error: 40146, Severity: 16, Table group object is not found.
Error: 40147, Severity: 16, Stored procedure ‘%.*ls’ is only for CloudDB.
Error: 40148, Severity: 16, The existing persisted queue snapshot CSN (%d, %I64d) at %S_LSN is greater than the requested snapshot CSN (%d, %I64d) at %S_LSN.
Error: 40149, Severity: 16, The database does not host any partitions.
Error: 40151, Severity: 16, Partition is in transactionally inconsistent state.
Error: 40152, Severity: 16, Partition delete expects no context transaction.

Error: 40153, Severity: 16, The current database has been shutdown. The current database has been switched to master.
Error: 40157, Severity: 16, Too many secondaries. At most 32 are currently supported.
Error: 40158, Severity: 16, Could not change database collation for database id %d.
Error: 40159, Severity: 16, Database scoping cannot be run inside a transaction.
Error: 40160, Severity: 16, Heartbeat message version mismatch. Actual version is %d and the expected is %d.
Error: 40161, Severity: 16, Invalid partition type. Only 1 or 2 is supported.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures from Error: 4901 to Error: 4921

SQLServerF1

 

Error: 4901, Severity: 16, ALTR TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be e
Error: 4902, Severity: 16, Cannot find the object “%.*ls” because it does not exist or you do not have permissions.
Error: 4903, Severity: 10, Warning: The specified partition %d for the table ‘%.*ls’ was ignored in ALTR TABLE SWITCH statement because the table is not partitioned.
Error: 4904, Severity: 16, ALTR TABLE SWITCH statement failed. The specified partition %d of target table ‘%.*ls’ must be empty.

Error: 4905, Severity: 16, ALTR TABLE SWITCH statement failed. The target table ‘%.*ls’ must be empty.
Error: 4906, Severity: 16, ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ is %S_MSG partitioned while index ‘%.*ls’ is %S_MSG partitioned.
Error: 4907, Severity: 16, ‘%ls’ statement failed. The %S_MSG ‘%.*ls’ has %d partitions while index ‘%.*ls’ has %d partitions.
Error: 4908, Severity: 16, ‘%ls’ statement failed. The range boundary values used to partition the %S_MSG ‘%.*ls’ are different from the range boundary values used for index ‘%.*ls’.
Error: 4909, Severity: 16, Cannot alter ‘%.*ls’ because it is not a table.
Error: 4911, Severity: 16, Cannot specify a partitioned table without partition number in ALTR TABLE SWITCH statement. The table ‘%.*ls’ is partitioned.

Error: 4912, Severity: 16, ‘%ls’ statement failed. The columns set used to partition the %S_MSG ‘%.*ls’ is different from the column set used to partition index ‘%.*ls’.
Error: 4913, Severity: 16, ALTR TABLE SWITCH statement failed. The table ‘%.*ls’ has clustered index ‘%.*ls’ while the table ‘%.*ls’ does not have clustered index.
Error: 4914, Severity: 16, The ALTR TABLE SWITCH statement failed. The table “%.*ls” has a disabled clustered index.
Error: 4915, Severity: 16, ‘%ls’ statement failed. The parameter type of the partition function used to partition the %S_MSG ‘%.*ls’ is different from the parameter type of the partition function used to partition index ‘%.*ls’.
Error: 4916, Severity: 16, Could not enable or disable the constraint. See previous errors.
Error: 4917, Severity: 16, Constraint ‘%.*ls’ does not exist.
Error: 4918, Severity: 16, ALTR TABLE SWITCH statement failed because the table ‘%.*ls’ has fulltext index on it.
Error: 4919, Severity: 16, PERSISTED attribute cannot be altered on column ‘%.*ls’ because this column is not computed.
Error: 4920, Severity: 16, ALTR TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.
Error: 4921, Severity: 16, ALTR TABLE failed because trigger ‘%.*ls’ does not belong to table ‘%.*ls’.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures from Error: 4627 to Error: 4810

SQLServerF1

 

Error: 4627, Severity: 16, Cannot grant, deny, or revoke the connect database permission to application roles.,
Error: 4628, Severity: 16, The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.,
Error: 4629, Severity: 16, Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.,
Error: 4701, Severity: 16, Cannot find the object “%.*ls” because it does not exist or you do not have permissions.,

Error: 4707, Severity: 16, Could not truncate object ‘%.*ls’ because it or one of its indexes resides on a READONLY filegroup ‘%.*ls’.,
Error: 4708, Severity: 16, Could not truncate object ‘%.*ls’ because it is not a table.,
Error: 4709, Severity: 16, You are not allowed to truncate the system table ‘%.*ls’.,
Error: 4710, Severity: 16, Could not truncate object ‘%.*ls’ because it or one of its indexes resides on an offline filegroup ‘%.*ls’.,
Error: 4711, Severity: 16, Cannot truncate table ‘%.*ls’ because it is published for replication or enabled for Change Data Capture.,
Error: 4712, Severity: 16, Cannot truncate table ‘%.*ls’ because it is being referenced by a FOREIGN KEY constraint.,

Error: 4801, Severity: 16, Insert bulk is not supported over this access protocol.,
Error: 4802, Severity: 16, The SINGLE_LOB, SINGLE_CLOB, and SINGLE_NCLOB options are mutually exclusive with all other options.,
Error: 4803, Severity: 21, The bulk copy (bcp) client has sent a row length of %d. This is not a valid size. The maximum row size is %d. Use a supported client application programming interface (API).,
Error: 4804, Severity: 21, While reading current row from host, a premature end-of-message was encountered–an incoming data stream was interrupted when the server expected to see more data. The host program may have terminated. Ensure that you are using a supported client applicat,
Error: 4805, Severity: 17, The front-end tool you are using does not support bulk load from host. Use the supported tools for this command.,
Error: 4806, Severity: 16, SINGLE_CLOB requires a double-byte character set (DBCS) (char) input file. The file specified is Unicode.,
Error: 4807, Severity: 21, The bulk copy (bcp) client sent a row length of %d. This size is not valid. The minimum row size is %d. Use a supported client application programming interface (API).,
Error: 4808, Severity: 16, Bulk copy operations cannot trigger bulk load statements.,
Error: 4809, Severity: 16, SINGLE_NCLOB requires a UNICODE (widechar) input file. The file specified is not Unicode.,
Error: 4810, Severity: 16, Expected the TEXT token in data stream for bulk copy of text or image data.,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

SQL Server Errors or Failures Error: 1087 to Error: 1124

SQLServerF1

 

Error: 1087, Severity: 15,
Must declare the table variable “%.*ls”.

Error: 1088, Severity: 15,
Cannot find the object “%.*ls” because it does not exist or you do not have permissions.

Error: 1089, Severity: 15,
The SET FMTONLY OFF statement must be the last statement in the batch.

Error: 1090, Severity: 15,
Invalid default for parameter %d.

Error: 1091, Severity: 15,
The option “%ls” is not valid for this function.

Error: 1092, Severity: 16,
In this context %d statistics name(s) cannot be specified for option ‘%ls’.

Error: 1093, Severity: 16,
%.*ls is not a valid broker name.

Error: 1094, Severity: 15,
Cannot specify a schema name as a prefix to the trigger name for database and server level triggers.

Error: 1095, Severity: 15,
%.*ls has already been specified as an event type.

Error: 1096, Severity: 15,
Default parameter values for CLR types, nvarchar(max), varbinary(max), and xml are not supported.

Error: 1097, Severity: 15,
Cannot use If UPDATE within this CREATE TRIGGER statement.

Error: 1098, Severity: 15,
The specified event type(s) is/are not valid on the specified target object.

Error: 1099, Severity: 15,
The ON clause is not valid for this statement.

Error: 1101, Severity: 17,
Could not allocate a new page for database ‘%.*ls’ because of insufficient disk space in filegroup ‘%.*ls’. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing fi

Error: 1105, Severity: 17,
Could not allocate space for object ‘%.*ls’%.*ls in database ‘%.*ls’ because the ‘%.*ls’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on

Error: 1119, Severity: 16,
Removing IAM page %S_PGID failed because someone else is using the object that this IAM page belongs to.

Error: 1121, Severity: 17,
Space allocator cannot allocate page in database %d.

Error: 1122, Severity: 14,
Table error: Page %S_PGID. Test (%ls) failed. Address 0x%x is not aligned.

Error: 1123, Severity: 14,
Table error: Page %S_PGID. Unexpected page type %d.

Error: 1124, Severity: 14,
Table error: Page %S_PGID. Test (%ls) failed. Slot %d, offset 0x%x is invalid.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.