Sql Error #7107, Severity 16

Sql Error Number:7107
Severity: 16

Description: You can have only 1,024 in-row text pointers in one transaction

Possibly related links:

Errors 7000 - 7999
You cannot set option 'text in row' for table %s. 7104. 16. Offset or size type ... You can have only 1,024 in-row text pointers in one transaction. 7116. 16 ...

Errors 7000 - 7999
You need an active user transaction in order to use text pointers for a table ... You can have only 1,024 in-row text pointers in one transaction. 7108. 22. Yes ...

sp_invalidate_textptr (Transact-SQL)
sp_invalidate_textptr can be used only on in-row text pointers. ... transaction spanning more than one database can have 1,024 in-row text pointers in each database. ...

Microsoft SQL Server 7.0 Storage Engine Capacity Planning Tips
... database has at least one data file and one transaction log file. ... For each text, ntext, or image value, only a 16-byte pointer is stored in the data row. ...

sp_invalidate_textptr (Transact-SQL)
sp_invalidate_textptr can be used only on in-row text pointers. ... transaction spanning more than one database can have 1,024 in-row text pointers in each database. ...

Microsoft SQL Server 7.0 Storage Engine Capacity Planning Tips
... database has at least one data file and one transaction log file. ... For each text, ntext, or image value, only a 16-byte pointer is stored in the data row. ...

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!