Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Makes the specified in-row text pointer, or all in-row text pointers, in the transaction invalid. sp_invalidate_textptr can be used only on in-row text pointers, which are from tables with the text in row option enabled.


sp_invalidate_textptr [ [ @TextPtrValue = ] textptr_value ]


[ @TextPtrValue = ] textptr_value

Is the in-row text pointer that will be invalidated. textptr_value is varbinary(16), with a default of NULL. If NULL, sp_invalidate_textptr will invalidate all in-row text pointers in the transaction.

Return Code Values

0 (success) or 1 (failure)


SQL Server allows a maximum of 1024 active valid in-row text pointers per transaction per database; however, a transaction spanning more than one database can have 1024 in-row text pointers in each database. sp_invalidate_textptr can be used to invalidate in-row text pointers and thus free up space for additional in-row text pointers.

For more information about the text in row option, see sp_tableoption.


Execute permissions for sp_invalidate_textptr default to all users.

See Also

Managing ntext, text, and image Data




Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft