Purchasing.uProductVendor Trigger

Information

NamePurchasing.uProductVendor
Table NamePurchasing.ProductVendor
Created14.10.2005 1:59:54
Modified14.10.2005 1:59:54
Disabled 
For replication 
Instead of trigger 
Activates onUPDATE

SQL Script

CREATE TRIGGER [Purchasing].[uProductVendor] ON [Purchasing].[ProductVendor] 
AFTER UPDATE NOT FOR REPLICATION AS 
BEGIN
    SET NOCOUNT ON;

    UPDATE [Purchasing].[ProductVendor] 
    SET [Purchasing].[ProductVendor].[ModifiedDate] = GETDATE() 
    FROM inserted 
    WHERE inserted.[ProductID] = [Purchasing].[ProductVendor].[ProductID] 
        AND inserted.[VendorID] = [Purchasing].[ProductVendor].[VendorID];
END;