I agree your suggestion is a better approach. I was just curious if anyone else had experienced the "buffer" issue (uses SQL Server memory proportional to the number of records...

I don't know. The SQL is simply a select <field1>, <field2>, etc ... from <table in SQL>. I tried running the SQL from query analyzer outside dts and it runs...

Worked great!

Thank you

Randy

I tried reinitializing the subscription this morning but the new table was not replicated.

What does this do?

1.) right click on table

2.) all tasks

3.) create new publication

Great article. It appears that identity & PK are not replicated by default. If I understood correctly the author created the identity & PK manually on the subscriber and then...

I see options for "No", "Yes" and "Yes (Not For Replication)". The "Yes" is used.

Randy