Hi Ron,
full script is :-
CREATE TRIGGER [dbo].[TASSIGNMENT_DTRIG] ON [dbo].[TASSIGNMENT] FOR DELETE AS
SET NOCOUNT ON
INSERT INTO utils..TassignmentLogging
SELECT
deleted.* ,
HOST_NAME() HostName ,
GETDATE() TheDate ,
DB_NAME() TheDb ,
APP_NAME() UserApp
FROM
deleted
INNER JOIN dbo.TTASK
ON deleted.TASKID = dbo.TTASK.UNIQUEID
WHERE
ttask.id = 23
Unless I've mis-understood you
Thanks for the offer - got a few things to look at before I go today - most likely won't be posting that until tomorrow.
Will be free to answer any general queries before then though
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx