I posted this before but I can not find it so I will Post again.

I am looking to find out some more information on the deletes and the response I got from Eric.

I am trying to put a trigger on a table that has a Text column. Because of the text column the Select * from Deleted will not work on the trigger to put the data into table 2.

Is there a way to put a before delete trigger in 7.0? Is there any way to copy the data to another table with the text column?

-- Anonymous, March 12, 2002

Answers

Paul,

SQL Server 2000 offers an INSTEAD OF trigger. Using this you will have to explicitly do the deletion after the rest of the trigger code. SQL Server 7.0 has neither a DELETE nor INSTEAD OF trigger.

Sorry,

Eric

-- Anonymous, March 12, 2002