USE SalesOne;
GO
IF OBJECT_ID ('SalesOne.reminder4', 'TR') IS NOT NULL
DROP TRIGGER SalesOne.reminder4;
GO
CREATE TRIGGER reminder4
ON SalesOne.dbo.Assets
AFTER INSERT,UPDATE
AS
--RAISERROR ('Notify Customer Relations', 16, 10);
UPDATE Assets SET LastUpdated = {fn now()}
GO
No comments:
Post a Comment