sp_invalidate_textptr (Transact-SQL)
Applies to:
SQL Server
Invalidates the specified in-row text pointer, or all in-row text pointers, in the transaction. sp_invalidate_textptr can be used only on in-row text pointers. These pointers are from tables that have the text in row option enabled.
Transact-SQL syntax conventions
Syntax
sp_invalidate_textptr [ [ @TextPtrValue = ] textptr_value ]
Arguments
[ @TextPtrValue = ] textptr_value
Is the in-row text pointer that to be invalidated. textptr_value is varbinary(16), with a default of NULL. If NULL, sp_invalidate_textptr invalidates all in-row text pointers in the transaction.
Return Code Values
0 (success) or 1 (failure)
Remarks
SQL Server allows for a maximum of 1,024 active valid in-row text pointers per transaction per database; however, a transaction spanning more than one database can have 1,024 in-row text pointers in each database. sp_invalidate_textptr can be used to invalidate in-row text pointers and, therefore, free space for additional in-row text pointers.
For more information about the text in row option, see sp_tableoption (Transact-SQL).
Permissions
Requires membership in the public role.
See Also
Database Engine Stored Procedures (Transact-SQL)
System Stored Procedures (Transact-SQL)
sp_tableoption (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru