I have found a much better way of doing this, just thought I'd add it to this post

I am keeping my import process (importing from Excel sheets into SQL tables...

Thanks

I am able to store both Korean text and English in the same field (either for different records or for the same record) but the way I achieved this was...

Am I mistaken in thinking most of the information posted in this thread is more about translating static (or semi static) information back to the end user? Such as within...

Sorry if I'm asking the obvious being a newbie and all, but is Named Pipes enabled in the SQL Server 2005 Network Configuration area of SQL Server Configuration Manager?

You haven't really asked a question here, just posted the output of the error you are getting

What are you trying to do? The Validation process is telling you that there...

This is telling you that some data within tables is failing validation, meaning that at least one table has data in it which is different between the Publisher and Subscriber....

Do you receive an error when trying to synchronize? If so, what?

There's a big difference between pausing the replication (no...

If you remove the table from the replication model, which can be done via the Properties > Articles of the replication model, you should then be able to drop the...

TRACEY (9/16/2008)

---

Never really thought about that hmmm now im thinking over here why replicate all 1500 some of these are static tables and never change perhaps i rethink that only...

The way I determined what was out of synch was by using the Validate Subscription option

If you open Replication Monitor > click on the Subscription Watch List Tab > double...

Sorry, I don't know of a way to do it for all tables at once, only one table specified at a time

When I had a similar issue I only had...

Rather than creating the publisher/distributor/subscriber straight away, you can tell the GUI to script out the procedure instead (so it's just a something.sql file) and save this file wherever you...

If you look at the test2.sql file that you created (although you have -q and -o immediately after -f, so not sure if this would prevent the file from being...

what kind of articles are they?

Tables?

Views?

Functions?

I was referring to tables when mentioning "it worked fine" in my earlier post