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....

You could try [font="Courier New"]sqlcmd -L[/font]. It works better on some networks than others, though. Read the sqlcmd page in Books Online so that you understand the limitations.

John

This will return 1st April from the year two years before the given date. If you need the date presented in a particular way, do that in the application....

Or you could go with 13, 26 and 39 weeks, to make it more likely that the manger will be informed on a working day. Start with a query...

Jeff Moden (7/20/2016)

---

John Mitchell-245523 (7/20/2016)

---

The reason for changing to single-user isn't to get a connection to the database; it's to remove all other connections to the database. I've done...