How do you decide which process should run the stored procedure?  What are these processes - are they from the application?  Why do you need to do this, by the...

Prasanna

I'm not sure why you're getting that error message.  But you need to use ALTER LOGIN instead of CREATE LOGIN, since the sa login already exists. - then...

If the stored procedure is located on Sever A then specifying ServerB in your four-part name isn't going to get you anywhere.  You can get this to work by (a)...

Since INSERT is your only course of action (part from doing nothing), I don't think I'd bother with the MERGE statement.  Try something like this.  If it doesn't work, it...

Thanks for providing DDL and sample data, but please test before posting.

What results are you expecting?

John

Yes, because IF @newEnabled <> @oldEnabled will always evaluate to False for an insert or delete,  That's because there will only be an Inserted or a Deleted table and therefore @newEnabled or...

You don't appear to have taken ZZartin's advice about using FOR UPDATE, nor mine (five days ago) about making the trigger work for multiple modifications.  Nor does it look like...

OK, you've posted the code that does work.  If you show us what you've tried that doesn't work for added and deleted jobs, we should be able to help out.

How (or why) do you have a stored procedure that includes CREATE FUNCTION statements?!

I'd start by searching this site for string splitter functions.  The ones in your codes...

Stefan

It works for me.  Note my modifications to your code:
DECLARE @command varchar(1000)
SELECT @command = 'SELECT ''?'', * FROM sys.symmetric_keys'
EXEC sp_MSforeachdb @command

John

As far as I know, those numbers identify the components of the package.  Since the error message provides the respective names of those components (UAT tablename Destination.Inputs[OLE DB Destination Input]...