Production.uProductModelProductDescriptionCulture Trigger

Information

Name	Production.uProductModelProductDescriptionCulture
Table Name	Production.ProductModelProductDescriptionCulture
Created	14.10.2005 1:59:54
Modified	14.10.2005 1:59:54
Disabled
For replication
Instead of trigger
Activates on	UPDATE

SQL Script

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

    UPDATE [Production].[ProductModelProductDescriptionCulture]
    SET [Production].[ProductModelProductDescriptionCulture].[ModifiedDate] = GETDATE()
    FROM inserted
    WHERE inserted.[ProductModelID] = [Production].[ProductModelProductDescriptionCulture].[ProductModelID]
        AND inserted.[ProductDescriptionID] = [Production].[ProductModelProductDescriptionCulture].[ProductDescriptionID]
        AND inserted.[CultureID] = [Production].[ProductModelProductDescriptionCulture].[CultureID];
END;