Hi all,
First of all I am a novice. I have googled and spent a lot of time on this problem but can't get a solution that works for me.
I have a two simple trigger that works fine on a local sql dbase. see below
TRIGGER 1
CREATE TRIGGER [dbo].[trplayermediaCreateDate] ON [dbo].[PlayerMedia]
AFTER INSERT
AS
UPDATE playermedia
SET playermedia.DateAdded=getdate()
FROM playermedia
INNER JOIN Inserted ON playermedia.PlayerMediaID= Inserted.PlayerMediaID
However when i transfer the same trigger to Azure and add a record, I get
"The Target Table 'dbo.PlayerMedia' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT without INTO clause"
Any help much appreciated.