Follow yesterday's post to get a list of SQL publications on a given server. The following for a given SQL Merge publication will list all of the articles within a publication.
This is really useful for a quick sanity check to ensure all those tables that you want to publish out to your mobile device are indeed setup.
Here's the SQL
select sysmergearticles.name from dbo.sysmergearticles, sysmergepublications where sysmergearticles.pubid=sysmergepublications.pubid and sysmergepublications.name='YOUR PUBLICATION NAME'order by 1
Theme design by Jelle Druyts
Pick a theme: BlogXP calmBlue
My Virtual Earth Balloon Races www.racingballoon.com Richard JonesPowered By The Fridge Server