Even if I use sql audit I believe I need a sql job to frequently check the audit log for whatever data I am looking for in it which should...

I tried that . it’s not working

Awesome Jeff Moden...but not enough ....I did not know I could post here and also expect an answer and then give it back to the interviewer all at the same...

if EXISTS (SELECT 1 from inserted)
if EXISTS (SELECT 1 from deleted)
 adding the above two  before begin  in both add and delete triggers did the job.
Thanks

Multiple rows will never be inserted at the same time so it is ok for the code to not handle that situation.
Only 1 row will be inserted at any...

no..the source table is in domain A and the destination table is in Domain B
So a  row gets added to table A, it should be immediately added to TableB...

My Initial table list of servers

My reachable list of servers in successservers table

My not reachable list of servers in failureservers table

Then I use my select against successservers table and collect...

Can this be achieved without using script task (without coding) Please advise

As I said if the servers are reachable then my ssis package loops through the sql table captures relevant data. but once a server is not reachable then my ssis...

As I said if the servers are reachable then my ssis package loops through the sql table captures relevant data. but once a server is not reachable then my ssis...

As I said if the servers are reachable then my ssis package loops through the sql table captures relevant data. but once a server is not reachable then my ssis...

how do you do that?

I get an email when I execute the same code without any attachments.
I don't think the error has anything to do with smtp.