I just now mounted the 2005 instance in my copy of 2008 R2 and tried to do some DDL against it from in there, same error. It has to...

So - I installed SQLPrompt from Red Gate, and still no luck (didn't find the object at all on that db in question).

So - I completely uninstalled and reinstalled SQL...

Yep - still get the same error after restoring the db from a backup. Blaaaaaaaaaaaah. I am guessing that for some reason (in my local instance only) this...

Hi Homebrew - great question, and my apologies for the vagueness of my question here. The problem has been essentially this...

I have 1 database in particular (in my local...

Hi Brian - no - unfortunately others are getting this too, and it is happening on the server itself (we RDP over to it and try to open SSMS up...

Just in case anyone is interested (or not), I did finally resolve this issue, but here is what I had to do.

I needed to do the export from an Agent...

Hi Kraig - no worries, I too have been hit-n-miss out here.

No, the package does not disappear or get moved or anything like that. I have tried it from...

Still really needing anyone's insight into this issue. The package seems to work the very first time I recreate the job, but there after - it fails as described...

Evil Kraig F (8/23/2012)

---

Two things are going on here, and they're not entirely independent but a few questions.

I assume you originally built this package from your local system, but the...

Yep - it needed indexing at the very least...I thought about that last night before running it.

OK - let me do a little more reading on how to implement a log backup in this query from your article earlier, and do some testing on this today....

Also - is doing this in batches instead of all at once not the best approach? The environment I am supporting is not a very robust one, and the...

Let me give it a try - also, in addition to indexing, would there be a better benefit to increasing the batch size, or would making the batch size smaller...

Lynn - Would I need to modify the WHERE clause in the sub-query if I wanted to do this in batches? So it's not trying to eat the elephant...

Since I first posted this question, I have done other research and scouring - I cannot find a single documented instance where mirroring was used as a migration tool. ...