name is sysname(128) = 128

number and colid are smallint = 4

Text is nvarchar(4000) = 8000

So you can definitly bust the 8094 limit there. But as John suggested, you can convert the text to varchar (unless you use chinese text in there) and it'll go down 4000 characters.