I need to add a table that exist on the publisher db to the subscriber DB. However it does not have a primaryID and I do not want the data to be replicated just the table structure.( It is a Scratch table that is needed for reporting purposes). My Thought was to just run the table creation script against the Subscriber DB, after replication is setup each time.
sp_addScriptExec @publication='your-publication' , @scriptFile = '\snaphot-storage-location\your-table-script.sql' , @skipError = 1
answered Nov 17, 2009 at 12:28 AM