yes I understand it and thanks everyone for providing the answers.

Actually Application is stable and live since many years and such kind of issue happened only few times. I am still trying to find anyway I can see the what...

Thanks for you reply.

You mean I need to create two separate triggers lime below?

CREATE TRIGGER TR_OrderDetails

ON dbo.OrderDetails

AFTER INSERT

AS

SELECT *

FROM Inserted;

GO

CREATE TRIGGER TR_OrderDetails_Del

ON dbo.OrderDetails

AFTER DELETE

AS

SELECT *

FROM Deleted;

GO

Thank you. This seems good idea.

Hi,

Yes scenario is:

1:App Team , DBA team , Automated App Service Account have permission to do DML operations against table, e.g. they can only do the insert /update/delete against any...

Hi,

I only want to track user based insert/delete and not the insert/update made by app(automated process). As there are 1000+ tables so I also don't want the performance of database...

Thanks but this is more related to create DDL trigger and send alert for any DB OBJECT CHANGE events like Create/Alter/Drop etc

I am looking to alert if someone disable the...

Hi Jeff,

I have added the user as described above in earlier post and default database I have given is EMP. The user has just public access.

I added this line to...

Hi Both,

the code is same as I posted.

However if I use the single quote in second query then also same issue.

again posting the same code which is giving error

declare @subject...

Sorry, It is single quote only in first query but still getting same exception.

Yes I have put in job step.

full script as requested.

declare @subject varchar(255)

, @query nvarchar(4000)

, @body varchar(255)

, @sep varchar(1)

, @att varchar(50)

, @recip varchar(255)

select @recip = 's.smith@xyz.com;'

select @body = ''

select @subject =...

Hi, I have setup sql job and used below query to get the data and then send email as attachment

select @query = 'SET NOCOUNT ON;select TicketDate, TicketNum,UploadDate,Amount, Name, DOB from...

Thanks John for reply.

Yes due to some reason we can't stop loading duplicate at first place. we can't modify the table schema as it used by other processes.

How I can...

I am using Sql Server 2016

My main requirement is to store the login account information , date and time into sql table whenever any one login to specific Database.

If the...

Thanks 🙂