restore database [A B C] from disk = 'D:\backup\A B C.bak'

This sounds like an ideal opportunity to provide feedback to Microsoft.

Within SSMS hit the Community menu link, then "Send Feedback". Login and you can send feedback as regards improving the...

Try using the sql_handle process, it will show the code running for each spid in query.

You can run for each spid in the blocking tree and you'll get all the...

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT is the file

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ is where you should find the logs, and ERRORLOG is the SQL log, there is no txt file

I think this might have to go up the chain to Microsoft product support. They will help you capture information about the install and work with you to find resolution.

And there are no dump files in the log directory, or informative entries in the event logs?

When it occurs next time, could you grab a copy of the cluster log?

EXEC sp_OAMethod @ObjectToken, ''Write'', NULL, '+@IMG_PATH+'

Just curious, have you tried removing the quotes and just having (not sure this will work)

EXEC sp_OAMethod @ObjectToken, ''Write'', NULL, @IMG_PATH

One other thought, if you only need the index for the update, and don't actually need it for queries, why not drop it after the update is completed?

Out of curiousity, are all the inserts and updates happening on the same tables for all of the sql files? If that's the case could you drop the index, import...

Start simple. Work on what you need to do to check the values in sp_configure. Once you know what those values are work on changing them to what values you'd...

Look up SQLCMD, you can call this from the OS and use SQL within that to check all the values that you want.

Or you could just create a TSQL script...

execute sp_helptrigger UserStats

This will tell you if there are any triggers on the table.

A trigger is fired depending upon the action performed, they can be set for insert/update/delete and...

I didn't realise that textcopy doesn't come with 2005, that's what happens when you get stuck in 2000 for many years.

You can pull textcopy off 2000 media if you have...

It will commit on the principal, and the transaction log will continue to grow until either the full mirror partnership is back up (so the transactions can be moved over...