the repl Distribution Agent (DA) pushes from Distributor (or pulls from sub), taking the initial outload from snapshot files (incl any post-snapshot.sql), and will then process subsequent changes (unless just...

1. create a pub with at least one article

2. generate replication script (drop+create)

3. edit script to have many articles

4. execute script

although the initial script looks pretty...

repl is a big subject so sometimes a simple problem statement hides lotsa details and assumptions!

- glad you've done the obvious already

supposing simple case of

sourceserver (SS)

source db (DS)

schema (KS)

table (TS)

publication...

can change existing articles (if DDL=1) or add new ones but won't automagically appear at each sub

I find it convenient (to avoid the rip&replace) to add new table articles in...

it IS possible to replicate (e.g. transactional) tables with different schemas, but I have also experienced problems (eg. we have tblFund as articles in 3 of our pubs). Using the...

moderately clunky, but this might do

declare @remver sql_variant

select @remver=REMVER from OPENQUERY(a_linked_server,'select REMVER=serverproperty(''productversion'')')

select @remver

although many better ways with SMO, ADO.NET etc

HTH

Dick

also [cheaper?] at DevX [and more other interesting stuff]

http://www.devx.com/premier/Door/17532

Dick

I would like to believe that most of the SQL wisdom is within Books OnLine (BOL) rather than just in the heads of the battle-scarred soldiers like Brian [the Duck]...

I agree with Michael.

If you have all db's on the same instance [cluster in your case] then probably no more/less performance, but you lose the Declarative referential integrity (DRI) that...

as you will know, there are UI changes from SQL2000 (SEM) to SQL2005 (SSMS), but also fundamental ones too under the covers (incl replication).

When contemplating a migration you should use...

Thanks again, Dick. I just checked-- we do have enough space for the distribution database.

I have one more question ( I am asking for too much). So the whole...

that is correct, the Snapshot writes flat-files on the Distributor(?) which the DA's then read

- there are doubtless very few rows written to tables in distribution db

worth checking that you...

yup, 1399 is RTM

you should be on SP2 (9.0.3159), unless you want to stick your neck out for "Cumulative Update 6"

http://support.microsoft.com/kb/946608/

Dick

Your initial config has been

P1 => D->Swhere P1 and D are the same box

and new config

P2->D->S

so I suggest that you first script out the existing publication (drop and create parts)

-...

there are several replication agents

LogReader Agentfrom LDF -> distribution db

Snapshot Agentgenerate the flat-files (e.g. *.bcp)

Distribution Agentdeploy initial snapshots, then subsequent changes ex distribution db

where you are actually commenting on speed...