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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *