Ok... So add it. I assume you know how to add joins and what the different ones are. It is indicated in previous posts that you do. If...

I don't understand what the question is. It sounds like you already know what you need to do.

I believe the only concerns are for clustering. I believe that you need EE of the OS for that. Otherwise I think SE...

I have no idea, I just googled it and found it. I guess you could have done that for yourself :hehe: Sorry I'm not much help.

Are you talking about 2003 vs 2008 or edition of 2008?

Did you run sp_who2 and see if there is any blocking going on? I believe we had issues with tomcat trying to open connections over and over again and...

Google this: Thesaurus Database Download and it will give you this: http://wordnet.princeton.edu/

😎

J Livingston SQL (1/30/2012)

---

SQLKnowItAll (1/30/2012)

---

I'm not sure that you are supposed to be posting this kind of real data in a public forum. Moderators, you may want to take...

Why use NOLOCK...

I'm not sure that you are supposed to be posting this kind of real data in a public forum. Moderators, you may want to take a look and make...

Well then, use my code sample from above for insert. You can do the opposite for deletes. For updates, use an inner join.

Don't use a cursor for this, it is not needed. You can use MERGE as the previous person said, or simply do an insert with a left join.

INSERT INTO...

Switch your results from grid view to text. Copy and paste.

This happens because in the Security--> Logins on the SERVER, the users default schema is set their own name for this database mapping. Change it to dbo.