Could you tell me how it was unclear? The schema was included in the question:

CREATE TABLE Customers(

PrimaryName varchar(30),

LastUpdate timestamp)

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Hmmmm, not sure about the study guide, but if you look at any SP documentation readme.htm file, it's quite consistent on upgrading distributor first. Also in the info on upgrading...

quote:

---

Doesn't there have to be an "END TRANS" for this statement? I'm not familiar with using transactions, but I could have swore...

quote:

---

This has to be the most ridiculous QOD I've seen. The result you get depends on which database you run the query...

🙂 Must've been a real longgggg day that day. I went ahead and set the question to appear in full tomorrow. It's fixed now on the QOD side but will...

All fixed . The problem is that I haven't built an admin GUI for entering the questions in and I mis-guessed the past few days what the...

Please see http://support.microsoft.com/default.aspx?scid=kb;en-us;268363 for a bit of backup on the answer.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

quote:

---

A. You only have to acquire licenses for processors that are accessible to any copy of the operating system upon which...

Antares, good points. Since you have a multiple-instance cluster, you would have to have an Active/Active cluster. The FAQ on MS for licensing states you have to license the physical...

quote:

---

After these attempts, and not seeing the error message in the QOD, I assumed that it must result when a non-system administrator...

quote:

---

I think maybe the wording needs a bit of tweaking personally. Instead of "best way" (which is subjective) maybe what is the...

quote:

---

The fact remains that while the answer will work for the rows presented, it's still not correct for retreiving only those records...

Stinkin' SMTP server was hung. All fixed now. Thanks!

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight