Stefan,

I've actually had to do that at my work place. If those solutions don't work for some reason, let us know and I'll check my production environment to see what...

It also depends on how you have your environment set up. You can find it in Tools-> Options. I use "Open Empty Environment" so I don't have to log into...

So far as I know, you can't go back without...

SQL Server 2008 Replication

If you're looking to upgrade, it comes free with SQL Server 2008.

Thanks, diamond, but I'm not enough of a geek to be able to easily translate that. Any chance you could explain what you just said using English examples?

Thank you, Ninja. I appreciate the new info. I will definitely dig around.

Oh, learning time.

I've never heard the phrase "untrusted constraint." Please explain.

Found the problem.

The mapping table has duplicate new product numbers. I didn't see it because there are so many new products, and so few dups. And the dups each have...

The problem is, we don't understand what you mean by N+1 JOIN conditions. Real life examples would help us give you the proper code. We're not asking about company data....

Jack Corbett (5/16/2011)

---

Saw Steve's mention of Denver for next year's US SQLRally, I say US because there is SQLRally Nordic in Sweden in November and I believe Australia is in...

Stefan Krzywicki (5/16/2011)

---

Brandie Tarvin (5/16/2011)

---

Stefan Krzywicki (5/16/2011)

---

Here's an interesting article on Oracle satisfaction[/url]

SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for...

GilaMonster (5/16/2011)

---

Brandie Tarvin (5/16/2011)

---

Declare @Result int;

Execute TestProc 'ID','Email', @Result output;

That's how you call...

Peter Trast (5/16/2011)

---

No, just a horrible song... some 70's music is best forgotten. Hey, I...

Stefan Krzywicki (5/16/2011)

---

Here's an interesting article on Oracle satisfaction[/url]

SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for very large databases. A...

Ray K (5/16/2011)

---

Brandie Tarvin (5/16/2011)

---

Ray K (5/16/2011)

---

Mainly force of habit -- I copy/pasted...