Try to run this query to see reserved/used per table. Then look for "text" fields (ntext, image).

SELECT id, SUM(reserved) AS Reserved, SUM(used) AS Used, SUM(reserved - used) * 8 AS...

Sorry, I mistyped the INSERT...SELECT 🙁

Remove @oldImage from your stored procedure at all. And don't use subquery. Use this:

INSERT INTO SketchTable

(intMasterAcctID,intBuildingID,imgSketch)

SELECT @intNewMasterAcctID,@intNewBuildingID,

imgSketch from SketchTable where intMasterAcctId=@intOldMasterAcctID and intBuildingID=@intOldbuildingId

Try to remove: Declare @oldImage. Replace Select/Insert pair with single INSERT...SELECT statement:

INSERT INTO SketchTable

(intMasterAcctID,intBuildingID,imgSketch)

SELECT @intNewMasterAcctID,@intNewBuildingID,

@oldImage from SketchTable where intMasterAcctId=@intOldMasterAcctID and intBuildingID=@intOldbuildingId