This set of scripts can be used to publish any database in publications of 1 to x number of articles. The script will create the script you need to publish your tables. Be sure to initialize the needed variables and execute it in the database you wish to publish.
The two included stored procedures must be run into the MSDB environment on the Distributor server (if your distributor is the same as your publisher then run them on on the publisher.)
For SQL Server (version unknown, assumed 6.5)
Author: Jim Craddock
Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
"as -is", without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose...
Back to Database Journal Home