By using sp_invalidate_textptr, Each database can have only 1,024 active pointers to text in-row data in a single transaction, so if you need create new ones, you need to invalidate old ones. This stored procedure can do that if you pass in the text pointer value.