SQL Server Errors or Failures from Error: 7122 to Error: 7214

SQLServerF1

 

Error: 7122, Severity: 16, Invalid text, ntext, or image pointer type. Must be binary(16).
Error: 7123, Severity: 16, Invalid text, ntext, or image pointer value %hs.
Error: 7124, Severity: 16, The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
Error: 7125, Severity: 16, The text, ntext, or image pointer value conflicts with the column name specified.
Error: 7133, Severity: 16, NULL textptr (text, ntext, or image pointer) passed to %ls function.
Error: 7134, Severity: 16, LOB Locator is not supported as text pointer when using UPDATETEXT/WRITETEXT to update/write a text column.

Error: 7135, Severity: 16, Deletion length %ld is not in the range of available text, ntext, or image data.
Error: 7137, Severity: 16, %s is not allowed because the column is being processed by a concurrent snapshot or is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS) or tracked by Change Data Capture.
Error: 7138, Severity: 16, The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS) or tracked by Change Data Capture.
Error: 7139, Severity: 16, Length of LOB data (%I64d) to be replicated exceeds configured maximum %ld. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit,

Error: 7140, Severity: 16, Cannot create additional orphans with the stored procedure sp_createorphan. Free up some of the orphan handles that you have created by inserting or deleting them.
Error: 7141, Severity: 16, Must create orphaned text inside a user transaction.
Error: 7143, Severity: 16, Invalid locator de-referenced.
Error: 7144, Severity: 16, A text/ntext/image column referenced by a persisted or indexed computed column cannot be updated
Error: 7151, Severity: 16, Insufficient buffer space to perform write operation.
Error: 7201, Severity: 17, Could not execute procedure on remote server ‘%.*ls’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
Error: 7202, Severity: 11, Could not find server ‘%.*ls’ in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Error: 7212, Severity: 16, Could not execute procedure ‘%.*ls’ on remote server ‘%.*ls’.
Error: 7213, Severity: 20, The attempt by the provider to pass remote stored procedure parameters to remote server ‘%.*ls’ failed. Verify that the number of parameters, the order, and the values passed are correct.
Error: 7214, Severity: 16, Remote procedure time out of %d seconds exceeded. Remote procedure ‘%.*ls’ is canceled.

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 *