Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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 = ] TextPtrValue ]
[ ; ]
Arguments
[ @TextPtrValue = ] TextPtrValue
The in-row text pointer that to be invalidated. @TextPtrValue is varbinary(16), with a default of 0x00. 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 more in-row text pointers.
For more information about the text in row option, see sp_tableoption.
Permissions
Requires membership in the public role.