Database

<br />
-- ================================================<br />
-- Template generated from Template Explorer using:<br />
-- Create Trigger (New Menu).SQL<br />
--<br />
-- Use the Specify Values for Template Parameters <br />
-- command (Ctrl-Shift-M) to fill in the parameter <br />
-- values below.<br />
--<br />
-- See additional Create Trigger templates for more<br />
-- examples of different Trigger statements.<br />
--<br />
-- This block of comments will not be included in<br />
-- the definition of the function.<br />
-- ================================================<br />
SET ANSI_NULLS ON<br />
GO<br />
SET QUOTED_IDENTIFIER ON<br />
GO<br />
-- =============================================<br />
-- Author:		<Author,,Name><br />
-- Create date: <Create Date,,><br />
-- Description:	<Description,,><br />
-- =============================================<br />
CREATE TRIGGER tr_stagingEmployer_Update<br />
   ON  Employer<br />
   AFTER UPDATE<br />
   AS<br />
	-- SET NOCOUNT ON added to prevent extra result sets from<br />
	-- interfering with SELECT statements.<br />
	SET NOCOUNT ON;<br />
<br />
	INSERT INTO stagingEmployer<br />
	SELECT<br />
		*, 'U' as [Action]<br />
	FROM<br />
		Inserted<br />
GO

<br />
Msg 311, Level 16, State 1, Procedure tr_stagingEmployer_Update, Line 14<br />
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.<br />