Reinitialize all publications I have a database with almost 20 publications, and every once or twice a week a random number of publications needs to be reinitialized.  I have to go and do it manually then every thing works as expected.

I'm using the following command to initialize publication:

exec sp_reinitsubscription @publication = 'PubName', @subscriber = 'all'


The problem is that I have create it for each publication one by one, 
so my question is, is there a way to execute it on all publications?
sp_reinitsubscription states that the default for the @publication parameters is "all," so you can execute without that parameter to reinitialize all of the publications.

exec sp_reinitsubscription @subscriber = 'all'