Hi, Assuming I have 40 articles, is it advisable to have each article being published to have its own subscription (in this case 40 subscriptions)? The reason for doing this is I would like to perform my snapshot on selected articles only during production hour. Thanks, Jon M
If you want to perform the operation selectively then go by creating a dedicated subscription for each article, otherwise no reason for it. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.