Hi--

When creating a trigger for an INSERT, I read that text/ntext/images fields can NOT be used inside the trigger, how can I then display the next field that is type=text, or ntext then?

I've tried:
SET @x = (SELECT test FROM dbname WHERE ID = @id)

But when it says that I can't use the text type on the trigger.

Any work arounds? Thanks!