The only way you're going to track down that information is if you already had a SQL Audit or a security-related Trace running at the time the access was lost.

Regardless of the tool used, your full backup is going to take a fair amount of time.  Keep in mind, the backup only backs up the *DATA* not the file,...

A year or so back, I convinced a customer with a database on my servers to go the route suggested in the article.  The application in question has an MS...

Based on the fact that you said the query ran fine again in production after you did index maintenance (I'm presuming reorganized) and updated statistics, most likely your statistics in...

I would think you could do this using the Resource Governor feature.  Create a resource pool to limit the CPU usage for the login in question.

Please note, I...

So, of course what happens?
No one came by needing anything...

Ever have one of those days where you know that as soon as you go put your lunch in the microwave, someone's going to call your desk or walk over...

Vic,
Presuming your server is using Windows Authentication and your front end (which you indicated is MS Access) is being run as the logged in user on the workstation, SQL...

Has anyone had any issues enabling the two registry keys to enable the Meltdown / Spectre fixes for the OS?
https://support.microsoft.com/en-us/help/4072698/windows-server-guidance-to-protect-against-the-speculative-execution
I enabled these yesterday on...