Here is the problem. The code is not interpreted, it is compiled and executed. Take your original code, and instead of pressing the EXECUTE button, press the PARSE...

I agree with Grant and Clive, with one exception. If you really want to get down and dirty with SQL Server, spend the approximately $50.00 USD and get the...

Why would I leave SSC? ...

Jeff Moden (6/5/2009)

---

99.99% SQLServerCentral.com - I like folks like you and the others I've come to know and some of the other sites just seem to bloody rude at times.

You...

Why does it have to an object oriented database? If you are starting this project, I start by ask what it needs to do, not how it needs to...

You asked for help, forum etiquette asks that you post your resolution. Others may have a similar problem and seeing how you resolved the problem may help.

I'd also want to see the table DDL, sample data (in a readily consummable format for a cut, paste, and execute in SSMS or QA), expected results based on the...

The first time I mentioned BOL I did spell it out, but I didn't put the TLA along with it. You'll see that if you look at my post...

GilaMonster (6/5/2009)

---

Lynn Pettis (6/5/2009)

---

What I am thinking of doing in the future when I suggest to OP's to read Books Online is to add an additional statement that this is...

Peer-to-Peer replication??

GilaMonster (6/5/2009)

---

Lynn Pettis (6/5/2009)

---

GilaMonster (6/5/2009)

---

He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and...

GilaMonster (6/5/2009)

---

He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and was told to...

I'd also like to suggest this blog entry as well, The Flip Side. It may also provide you with additional insight in how to deal with those of us...

Here is another OMG moment.

I'm not telling you to buy ANY books. Books Online is the SQL Server Help file. While in SSMS, press F1, it will bring it up.