In SQL Server 6.5 it was possible to access text fields in the deleted
and inserted cursors from within a trigger. In 7.0 that appears to be
no longer possible. Does anyone know a way to accomplish the same
task in 7.0.
Specifically what I am trying to do is in the delete trigger of a
particular table copy some of the data to another table for archiving
purposes.
Thanks in advance.
Jacob Bruner
Computer Software Solutions
Jacob@compsoft.com