Friday, June 22, 2007

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

 

Technorati tags: ,
Friday, June 22, 2007 2:14:17 PM UTC  #    Comments [0]  | 
Comments are closed.

Theme design by Jelle Druyts

Pick a theme: