I don't know where you're getting "Output.ColumnName" from. It's either Inserted.ColumnName or Deleted.ColumnName. Do it like it's shown in the examples, and don't be afraid to try stuff...

Because there's no such virtual table as "Updated". Like I said, Inserted is the values after the update; Deleted is the values before.

John

Edit: By way of further explanation, an...

I'm not sure what you mean. There are plenty of examples on that page I linked to. "Inserted." refers to the new value of the column after the...

If I understand correctly, you need an OUTPUT clause in your UPDATE statement.

John

Extended Events is one of the few things I recommend doing in the GUI rather than with scripts. There are some promising-looking events in the session category that you...

Yes. Capture the lock_escalation event in an Extended Events session.

John

But you said in your original post

Are you now saying it exists on all servers? If it does, try setting up an extended...

Is the SQL Server Browser service running on the remote server? I'm not sure whether or not it tries to connect on 1433 for a named instance. If...

Surely your stored procedure is attempting to execute sqlbackup at the remote server? I'm guessing that the domain group in question has permissions on it on server1 but not...

Start here:

Have a look at the connection string. Does it look right? If it does, please post it here, changing any sensitive information.

John

Yes, it will. First, make sure you don't have any duplicate jobids in the second table so that you don;t get unpredictable results, then use UPDATE...FROM to join and...

Not out of the box, as far as I know. You could set up individual alerts that run a job that writes to a table, and have a trigger...

Excellent. So which column is the clustered index on? Please post the execution plan as requested, plus DDL (including indexes) for all tables.

John

Is the clustered index on the column you're updating? That's going to cause major pain. Aside from that, can't really help without seeing the (actual) execution plan.

John

Yes! I like that. I think I prefer going with explicit dates rather than integers - it makes it easier to see at a glance what it's doing....