-- =============================================
-- Create trigger basic template(After trigger)
-- =============================================
if exists (select Name 
           from sysobjects
           where Name = N'<trigger_name, sysname, TR_TST_TriggerTest>' 
             and TYPE = N'TR')
    DROP TRIGGER <trigger_name, sysname, TR_TST_TriggerTest>
GO

/******************************************************************************

  <trigger_name, sysname, TR_TST_TriggerTest>

  purpose     : <purpose_of_trigger, ,>

  author      : <author_of_trigger, ,>
  created     : <creation_date, ,>

  history     :
    <creation_date, ,> - <author_of_trigger, ,> - creation of the trigger

******************************************************************************/
CREATE TRIGGER <trigger_name, sysname, TR_TST_TriggerTest>
ON <table_name, sysname, pubs.dbo.sales>
FOR DELETE, INSERT, UPDATE 
AS 
BEGIN
    RAISERROR (50009, 16, 10)
END
GO