Hi, I have a sql server 2008R2, i have provided a login someone within a domain with write-only access, now I want to trigger a sql server agent job whenever a "insert into" query sucessfully executed by that login.
Following are the lines if i modify the trigger, if this is active than the insert into command is not working.
USE [DB NAME] GO /****** Object: Trigger [dbo].[SMSC] Script Date: 02/25/2013 12:11:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[DB NAME] ON [dbo].[tABLE NAME] AFTER INSERT AS BEGIN