A trace might work and it might not. If the queries are calling for tables that don't exist, or columns within tables that don't exist, or the data types are...

Have you explored the option of using Replication? It's set up to do a lot of what you just outlined. I'd try that as a first choice.

I would only model in Visio if someone held a gun to my head. But if it's unclear where I stand, let me know and I'll try to be less...

Steve Jones - SSC Editor (10/14/2010)

---

jcrawf02 (10/14/2010)

---

Steve Jones - SSC Editor (10/14/2010)

---

Doesn't bode well for lots of jobs, and I hope that some level of "bookstore" still remains in the...

CirquedeSQLeil (10/14/2010)

---

Grant Fritchey (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

Kit G (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

They have color e-ink now, it just isn't in commercial devices yet. There was a Sci-Am article about it a year...

Rob Schripsema (10/14/2010)

---

Grant,

Thanks for the reply. Sounds like there isn't complete consensus on whether GUIDs are valid for clustered indexes or not. So far, we've not seen significant performance impact...

Dave Ballantyne (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

Kit G (10/14/2010)

---

Stefan Krzywicki (10/14/2010)

---

They have color e-ink now, it just isn't in commercial devices yet. There was a Sci-Am article about it a year or...

Stefan Krzywicki (10/14/2010)

---

Kit G (10/14/2010)

---

Neato!...

Alvin Ramard (10/14/2010)

---

Steve Jones - SSC Editor (10/14/2010)

---

Direct sun is hard. I usually read with a black background inside, but I switch to black text on white when I'm outside....

Another way to generate procedures, that many people don't take advantage of, is to use the Templates offered by SSMS. If you click on the View menu and then Template...

If it's two really distinct entities, then, yeah, I agree with everyone else, two tables. From the names you gave, Sponsor & Offer, it sure sounds like two distinct entities....

Alvin Ramard (10/13/2010)

---

Grant Fritchey (10/13/2010)

---

Alvin Ramard (10/13/2010)

---

Change of topic for a second.

Has anyone here tried reading a pdf format ebook on a Kindle3? I'm thinking about getting a Kindle...

Alvin Ramard (10/13/2010)

---

Change of topic for a second.

Has anyone here tried reading a pdf format ebook on a Kindle3? I'm thinking about getting a Kindle and I'm just wondering...

I'll...

The LOOP join is a hint where they're trying to force a choice on the optimizer. In addition to fixing the scan, I'd test taking out that hint to see...