You said tempDB only...

The "single drive" is actually a SAN. It's either Raid 5 or Raid 1 + 0, but I'm betting on Raid 5.

The plan is to keep everything in the...

Just remember that xp_cmdshell is off by default and you'll have to turn it on before you can use it in this manner.

OLTP database. The partition would be storing historical records, but apparently the end users like to do a lot of "inception to current" summary reports. (I just found out about...

Sorry, forgot to...

1053MB is NOT MUCH when it comes to TempDB.

Understand that just because it's showing free right now, does not mean there's enough space to do what your transaction is attempting...

SWITCH? Is this something available in SQL 2005?

I don't see it in BOL.

The only tools I'm aware of compare Folders to Folders and Databases to Databases, not Databases to Folders.

The best thing you can do is set up dual monitors on your...

Have you checked the actual hard drive space? Locate not only your user db files, but the tempDB files. If tempDB is full, it can also cause this error.

AFA the...

Ditto to the T-SQL script creation. Easiest and quickest way.

You could also try to use SSIS's Copy Database tasks. Though it tends to be messy and not create things in...

Gift,

I have an end user who does what you're describing. But in the end, no matter what numbers he plugs in to come up with his scenarios, he's still basing...

WHOOHOO!

Found the workaround.

Create a new database called ReportDesign. Give the report writers whatever perms they need on that database.

Give db_datareader and db_denydatawriter on the "source" databases (from which the...

That link just shows another question. It doesn't actually show what you did for a final solution.

But if you post the final solution in either thread, then reference that solution...

Julie Breutzmann (12/4/2009)

---

But what about the companies that received and made use of what was clearly stolen data; it's improbable that someone could purcahse data with renewal dates for customers...

Oh, yeah. Steve's line gives me an idea for a whole 'nother story. @=)