Darren

I have ran sp_who2 and it did not show up any blocks. The disk space on the sever is fine. We have not lost any data all day!?

sorry me being a muppit.

sorry again,

got it sorted thanks for the help

wade montague

Edited by - wade on 02/18/2002 08:59:54 AM

Thanks, sorry and also,

CREATE TRIGGER [tr_addtotimeline] ON [paper_orders]

FOR INSERT

AS

DECLARE @publication_id INT

DECLARE @delivery_date DATETIME

/* get pub_id and date from the inserted data */

SELECT @publication_id AS...

I just assumed that would be three logical tables, inserted to retrieve data after an insert, deleted for a delete

and updated for an update. If this is not the case,...