Object type: Trigger

AFTER UPDATE trigger setting the ModifiedDate column in the SalesOrderHeaderSalesReason table to the current date.

Summary 

On table:	Delete	Update	Insert	Type
Sales.SalesOrderHeaderSalesReason	No	Yes	Yes	After

Properties 

Modifies data	Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
Yes	No	No	No	No	No

Data Source Activity 

Modifications	Description
Sales.SalesOrderHeaderSalesReason	Cross-reference table mapping sales orders to sales reason codes.

Applies to

Triggers | Modifies data | On update | After table changes

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation