The "sp_whoisactive" tool show % complete. Not sure how accurate it is.

You could set up a server side trace to capture events for the future. I have 1 running 24/7 and have found it useful from time to time. I set...

Are both servers on the same domain ?

Thanks Sean !

How would the hacker pass that variable to the stored procedure ? If it's part of a form on a website, then hackers can enter character strings. But...

Could someone include the "how" and "why" that dynamic SQL is vulnerable to SQL injection ?

Yes, that is what I did too.

set @CMD = 'copy...

It might not be a "normal" size for that database if it grew large due to a lack of t-log backups some time in the past. But now that you...

Why are you running code from files, instead of having the code in stored procedures, then executing the stored procedures. Is there an advantage to files ?

You can increase the history for future job runs.

Maybe if you restored MSDB backups to a temporary database you could query the job history tables. They may still have older...

Wouldn't the LEFT OUTER JOIN only work for new records, not changed records ?

I was also thinking replication would work.

Do you mean .MDF file ?

There are many ways it could be processed & scheduled. Have you looked at the SQL scheduled jobs ?

What is done with the file ?...

Rather than dig up an old thread to post a different question, I think you'd be better served by starting a new thread.

These bugs have been around for a long time. They must be very low on the priority list.

My snippet is not very clear.

Job_Date is a DATETIME column in the table, and it's also getting named as a field as a result of the convert. So...