If that data file is in use, then you can only attach it to the one instance at a time.

Honeycut

@SQLFRNDZ (12/20/2012)

---

This is what I got so far and I need help with looping script to add files to number of times based on condition cpu_count.

Here is the script I'm...

Does that mean it is working now?

Is advanced power management enabled in the bios on either machine?

Also, please submit actual execution plans for both servers. It will help us to troubleshoot.

Steve Jones - SSC Editor (12/20/2012)

---

I checked the SQL Servers, but everything seemed to be in order there. I suspect the mail servers had some issue.

Looks like they're working as...

Awesome

L' Eomot Inversé (12/20/2012)

---

Last notification I got about thread messages was between...

I have some writing to do (maybe a book), and some projects that have been started that need to be finished or enhanced.

Well, what have you got for your script so far?

Anybody else not receiving the topic notifications from SSC?

I have not received any since early this morning (1am-ish).

(Bob Brown) (12/20/2012)

---

I knew there might be a controversy over this question but I took a stab at YES because of the Itsik Ben-Gan article I read on...

True dat!

I would like to see a better explanation that is more on-point with...

Koen Verbeeck (12/20/2012)

---

Gopi S (12/20/2012)

---

Technically there is no difference between Unique Index and Unique Constraint. Even though syntax are different the effect is the same.

Unique Constraint creates Unique Index...

dawryn (12/20/2012)

---

SQLRNNR (12/20/2012)

---

I don't disagree with the correct answer. I disagree with the explanation. I also do disagree with many of the complaints thus far about the question....