How does it display in SSMS? If you look at the raw data, is it correct?

I'm guessing that you have some word wrap issue in SSRS. Does the text box...

Probably, and glad it's moving faster.

Large deletions across a table should be done in batches of 10,000 or 100,1000 or some reasonable level that allows you to stop it if...

The distributor cannot be a lower version than the publisher, that's the issue.

If you log ship to ServerB, it will work, but if you failover, you are stuck on 2008...

Are they all located in the same network area? Same subnet, physical location?

Check the Event logs for service information.

Pass, you type it, you're on the hook for it.

How does what help?

If this is just text data, is there a reason you can't just index the text data? If it's in Filestream, I know you can full text...

What updates? Are you talking about updating at the source or destination? It's not clear from what you are posting.

Your subquery 1 after the WHERE clause looks to be pulling lots of data for the NOT IN. I think that's your problem. You need to build some join so...

You'll have to explain more. What do you mean by updateable with filters?

I assume filters mean that you are producing a publication that joins data from two or more tables...

This help? http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/89eb8038-68a6-4201-a784-aa0063f4d8c0

Looks like you are missing a paren in your subquery before the NOT IN

novak 32871 (5/3/2012)

---

I know but there is already SQL 2012 out. It is good exercise but 2000/2003 has it's age and most of clients already moved. But I understand your...

The distributor is usually the issue. It must be equal to the publisher, so from 2008 -> 2005, you need a 2008 distributor.

Thank you.