RedGate has a wicked awesome tool called Virtual Restore. I can't remember the limitations but they do offer a ...wait for it...

<angels singing>

--->[FREE]<---

</angels singing>

trial. If...

Fair warning:

The "REORGANIZE/ALL" thing doesn't work so well on tables with indexes that have allow_page_locks set off (read: "SharePoint 2010").

Cheers,

Ken

Hm. Maybe using SQL Profiler? Trap all "CREATE TABLE #" commands? ...just a thought...

:exclamationmark:

I get it now. Thanks!

@GSquared:

Sorry to be thick-headed (read: slow-witted) but I have to ask: why did you SELECT TOP (8000) ROW_NUMBER... when it [seems] to work with TOP (10). Since...

<LOL>

And my way is wrong! I [just] realized dblist.txt will be [overwritten] for each server. My bad. Here's a corrected batch file:

[font="Courier New"]

@ECHO OFF

SQLCMD -Lc > serverlist.txt

FOR...

@angelspawn

Part of the challenge to be a successful DBA is to use the tools at our disposal to answer these types of questions. There are [several] ways...

@SAinCA

I apologize - I sort of rushed through carving out the relevant chunks of code for you yesterday and I realized just now that I inadvertently made a judgement call...

Sorry to be a bit off-topic but this thread flashed me back to an interview I had years ago. The 'technical' questions about troubleshooting were surprisingly specific and detailed....

Cool. I gave it a test ride before I sent it but I'd appreciate your input. Sadly, the font came over in the post but the spacing didn't....

Sorry. Sometimes I miss the point. DBMail setup.

Here's the code I use for setting up DBMail - I carved the other junk out. There are probably several...

The script references some scripts and a few batch files that I put on the server to handle maintenance, backups and disaster recovery. I'm not sure what would be...

I have a post-install script that sets up all of my nightly maintenance and backup stuff as well as the alerts, operators, DBMail config, etc.

Considering the number of servers I...

Sorry for the "Captain Obvious" fly-by but...

If you have the database at a point where it's barking about running DBCC CHECKDB, have you given that a shot? Let DBCC...

Sorry, I forgot to mention the point of my little adventure story: if I could have rolled that one transaction back, I wouldn't have had to restore the database.

BTW: