Software

Ask something
Discussion Locked

SQL Server 2000 error 7116

0 helpful
2 replies

by mlucasg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does someone got error 7116 on SQL 2000?

The message is: "Offset XXXXX is not in the range of available text, ntext or image data". What is raising or causing this error?

Thanks!

2 replies

by hypersoniq mcse

SQL7 Books Online is very vauge about the error
What was the query that generated the error?
I'm already done the SQL part of my MCDBA, last test (70-216 windows network infrastructure) this friday. I also have the desktop version at home and the full server at school. email query to hypersoniq_punk@hotmail.com or post it here. The error itself seems to be indicating a data type mismatch (certain data types do NOT allow text, ntext or image data), but the only way to debug this would be to see the query that caused the error. After the nightmare test that was 70-028 (SQL 7 database design), I am ready to tackle all things SQL ;-)

This discussion is closed to new replies.