the status values are additive. So 17 means the article is active and uses parameters.

there is a 2 gig limit on the size of compressed snapshots. Microsoft has not fixed this problem yet or created a workaround.

issue an sp_repldone and then do the backup/truncate

try the -b switch for rows per batch.

bcp is one way to do it, you could also use bulk insert, or a select into in chunks of 100,000 rows a while loop. I think you will find...

It is possible to do both. You must add the SQL 2k box as a subscriber in Managment Studio to be able to do this.

This sounds like a bug. Can you tell me your sql server version (@@Version) and post your publication script, and table schema (with indexes) here?

--

Hilary Cotter

Looking for a SQL...

this error message says it can't find the publication test.

try the following if testdb if your publication database name

sp_replicationdboption 'testdb','publish','true'

go

use testdb

go

sp_addpublication 'test', @status='active'

go

--

Hilary Cotter

Looking for a SQL...

sp_MSload_replication_status

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

stop all activity on the publisher - kick all your users off. Drop the subscriber and then do a no sync push. You won't need to regenerate the snapshot and...

You should be fine. Managing identities is really only a concern when you are doing bi-directional replication.

You are best to let merge replication work its magic or regenerate and redistribute your snapshot.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing...

Can the publisher ping the subcriber by netbios name? Go to your subscriber and issue the following.

xp_cmdshell 'echo %computername%'

select @@servername

These should be identical.

Do the same on the publisher. Again they...

You can do it with replication. When you are building your publication, and get to the select articles dialog, add the tables, then click on the browse button to the...

No its not possible. Each publisher can only use a single distribution database. A distributor can be a distributor for multiple publisher and this distributor can have a seperate distribution...