Once you've removed mirroring (http://msdn.microsoft.com/en-us/library/ms189112%28v=SQL.90%29.aspx), you can just restore both dbs and re-setup mirroring.

paul.knibbs (11/30/2011)

---

Anyway, I actually prefer to prune my e-mails while I'm away so I have fewer to go through on my return to work...it just stresses me out if I...

Me either, until I got a...

Very nice!

The question now reader:

====

Assuming you have a database called playpen on SQL Server 2008 and above, what is the resul of the select statement in the following code?

use playpen

go

begin

declare

...

Grumpy DBA (11/30/2011)

---

Steve - Where did you go riding? I'm taking my family to Breck in a couple of months (first time snowboarding in CO), any tips you can...

Just a second on what Suresh says. That's likely the issue. If you post the query you ran, I'm sure Suresh can help you alter it to prevent issues on...

Jeff Moden (11/29/2011)

---

Steve Jones - SSC Editor (11/29/2011)

---

I tend to agree with Bruce that Powershell is a nice multi-server tool. It's easily deployable to multiple machines, and it allows you...

We have one. I'll see if I can get a test account posted.

Yes, and Yes. We want to expand and cover things that are in BOL in a different way. A practical use for this in a short article that someone has...

Feel free. Submit a draft using the "Write for Us" link on the left.

Congrats, I think I just clinched up 🙁

I tend to agree with Bruce that Powershell is a nice multi-server tool. It's easily deployable to multiple machines, and it allows you to potentially do things that are harder...

too true....

Second vote for the SQLFool script.

Small tables don't defragment well because there just isn't enough extents/pages. Once they grow and you start to get hundreds or thousands of pages, fragmentation...