Hmm. It won't directly capture the output of RESTORE VERIFYONLY, but doing a SELECT @@ERROR immediately after RESTORE VERIFYONLY will return the count of errors encountered in the RESTORE...

Ah, I see. That clears quite a few things up!

There's still the question of what you'd like the query to do, however; I'm guessing that the [langue] column is...

Hmm. Someone with more experience will probably be more useful here, but there's a few things that are out of the ordinary with this question.

First, second-guessing the query optimizer...

Haven't had much time to post in The Thread or elsewhere lately due to work and other social commitments eating much of my time lately, but I wanted to drop...

Seems like the Buffer team did a great job indeed with their situation. I'm honestly surprised to see a company own up to a breach and try so extensively...

A cursor certainly wouldn't be needed here; this could be accomplished with a temp table or CTE quite easily. You could do something like so:

CREATE TABLE #Temp(Order# varchar(100))

INSERT INTO...

I believe there shouldn't be a problem with doing that; I restored an MSDB copy on a test server (since this whole thing's gotten me kinda interested in the problem),...

Hm, I may have hit on something. I found an old thread here on SSC from someone having a similar problem:

Thread

Seemingly, SQL Server 2005 (and maybe further versions?) can...

Ah, my apologies. I was looking at a few old jobs that were apparently using the "append" option with the log table; by default, they shouldn't be appending. ...

One thing to note is that the storage field for the table's output is NVARCHAR(MAX), so it holds quite a bit of data, and every time the job runs, it...

It's possible to edit a job's schedule through T-SQL, certainly; I put together this kinda wonky looking bit of code. There may well be a simpler way of doing...

Hm. Deleting 2.5 million records will be quite a bit of work to do; even more so if you have foreign keys that need cascading, or deletion triggers. ...

It's quite possible to use Access to call a SQL Server procedure; you'll need to have a link to your SQL Server established in the Access file first, however. ...

Hm. From the error message, it seems someone or something is using the file you're trying to delete. If you accidentally opened it before you deleted it and...

Hm. In my area (Chattanooga, TN), tech jobs are quite rare, unfortunately, and the local government was outsourcing some of its database personnel when I inquired about it last...