Please read the first article I reference below in my signature block regarding asking for assistance. To really help you it would help to have the DDL for the...

Very!! I can't wait to see her on October 15th!!

I'd recommend you read about database mirroring in BOL (Books Online, the SQL Server Help System). That should provide you was some basic knowledge regarding DB Mirroring. After...

IIRC, Index Seeks are better than Index Scans for the most part. If I am wrong, I'm sure someone else will come along and correct me.

Not really. If you need help it would be better to ask for it giving the a complete description instead of in small pieces here and there. I'd...

Jack Corbett (10/7/2009)

---

Lynn Pettis (10/6/2009)

---

RBarryYoung (10/6/2009)

---

Lynn Pettis (10/5/2009)

---

Sorry, but I'd rather be here in person for those events.

I'm taking a 2 week vacation starting next week, and I may or...

I am curious what it is you are trying to accomplish and why you think you need to use a loop to accomplish it?

Steve Jones - Editor (10/6/2009)

---

It's hard to stay in the top 5-10 here since you get points for questions. It seems that we'll have a few people every month answering...

RBarryYoung (10/6/2009)

---

Lynn Pettis (10/5/2009)

---

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least...

Hari.Sharma (10/6/2009)

---

ramonaraujop (10/5/2009)

---

to do rollback in a right way,

I wrote:

-----------------

BEGIN Tran t1

DROP TABLE T

go

ROLLBACK

GO

----------------

SELECT * FROM T

the Question of the Day was wrong, I guess, so, was completed...

Grant Fritchey (10/6/2009)

---

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least four...

RBarryYoung (10/5/2009)

---

Woo-hoo! Back in 6th place. 🙂

Now all I need to do is to keep this up for three years... And for at least four people to...

Matt Whitfield (10/5/2009)

---

Jack Corbett (10/5/2009)

---

Anyone else notice less responsiveness from OP's lately? Seems like the threads I respond to have other people post, but the OP doesn't even answer...

Mark Marinovic (10/5/2009)

---

Personally, I have NEVER done a restore through the GUI, either in SSMS or through EM :blush:

I have a script that I use over and over again in...

Yep, I...