Person.uContact Trigger

Information

Name	Person.uContact
Table Name	Person.Contact
Created	14.10.2005 1:59:50
Modified	14.10.2005 1:59:50
Disabled
For replication
Instead of trigger
Activates on	UPDATE

SQL Script

CREATE TRIGGER [Person].[uContact] ON [Person].[Contact] 
AFTER UPDATE NOT FOR REPLICATION AS 
BEGIN
    SET NOCOUNT ON;

    UPDATE [Person].[Contact] 
    SET [Person].[Contact].[ModifiedDate] = GETDATE() 
    FROM inserted 
    WHERE inserted.[ContactID] = [Person].[Contact].[ContactID];
END;