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.

I tried that already.Did not work

PS H:\> $File = gci \\abcd\efgh\ijkl | select -last 1
PS H:\> $From = "abcd@gmail.com"
PS H:\> $To = "defg@gmail.com"
PS H:\>...

It did not work

$File = "gci \\abcd\efgh\ijkl | select -last 1"
$From = "abcd@gmail.com"
$To = "efgh@gmail.com"
$Attachment = $File
$Subject = "Here's the Email Subject"
$Body =...

I tried that..it does not work.
It starts searching from the directory I am running the code from.
Send-MailMessage : Could not find file 'H:\files_06-04-2018_02-40-08.html'

My files exists in...