Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy Text fields from within Trigger
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Copy Text fields from within Trigger
Miscellaneous
Thread ID:
00194175
Message ID:
00194175
Views:
51
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
Next
Reply
Map
View

Click here to load this message in the networking platform