June 27, 2007 at 2:43 am
I need to find a method to detect if the database is replicated or not. I seem to be able to find loads of info on replicating databases but none on how to detect replication.
Can anyone help
June 27, 2007 at 3:04 am
You can see if any database named distribution exists if so that dayabase will have details ablout your publisher and subscriber.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 27, 2007 at 5:07 am
look at sysdatabase.category
select * from sysdatabases where category&&1=1 or category&&4=4
this will tell you if it is published via transactional or merge replication - see books online sydatabases for more details
MVDBA
June 27, 2007 at 5:11 am
ahh excellent. Thankyou! that's exactly what I was searching for.
June 27, 2007 at 7:05 am
You can also get it this way:
sp_dboption
dbname, 'published'
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply