April 18, 2003 at 1:59 pm
Hopefully the subject gives a good idea of what I'm trying to handle.
We have a Note table that we'd like to put a trigger on to archive the Note record to another table. In the Delete trigger, when I try to do a straight Insert into a new table, its "Error 311 - cannot use text in 'Deleted' table."
I tried using a local variable as an intermediate, but I get "Error 2739 - text, ntext and image datatypes are invalid for local variables."
Is there a way for me to get the information out of the text column in my delete trigger? I know I'd have to wait until SQL Server 2000 to get to it on a BEFORE basis. That's the problem with older systems.
Any help is appreciated.
TIA
AndreQ
April 18, 2003 at 2:13 pm
I don't think so. SQL2K supports instead of triggers which do you let you reference text columns.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply