Friday, October 08, 2010

Find Replicated Database

--SQL 2005/2008
sp_helpreplicationdboption


--SQL 2000
select name, databasepropertyex (name,'IsMergePublished') from
master..sysdatabases
select name, databasepropertyex (name,'IsPublished') from
master..sysdatabases

No comments: