Production.uCulture Trigger

Information

Name	Production.uCulture
Table Name	Production.Culture
Created	14.10.2005 1:59:51
Modified	14.10.2005 1:59:51
Disabled
For replication
Instead of trigger
Activates on	UPDATE

SQL Script

CREATE TRIGGER [Production].[uCulture] ON [Production].[Culture] 
AFTER UPDATE NOT FOR REPLICATION AS 
BEGIN
    SET NOCOUNT ON;

    UPDATE [Production].[Culture]
    SET [Production].[Culture].[ModifiedDate] = GETDATE()
    FROM inserted
    WHERE inserted.[CultureID] = [Production].[Culture].[CultureID];
END;