But

I tried the following complex sql query in SQL Server 2000. I got a syntax error.

SELECT DISTINCT CustomerNo

FROM ...

guarddata,

Thank you for your answer.

Actually, the case is:

We are an IT industry analysis and consulting service provider. We got some categories of reorts for our customer to subscribe. Every week...

The snapshot errors are:

snapshot 1

"snapshot task is suspicious. No response for 10 minutes"

snapshot 2

"Can't buck copy table [dbo].[syncobj_0x3945373643313242]"

p.s. since I am using a Chinese ver. SQL server, so the original...

1. Do you mean that if my appplication did not use UPDATETEXT/WRITETEXT, all changes on text fileds can be replicated?

2. If I set "max text repl size" to a large...