Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MuadDBA
628 Posts |
 Posted - 2006-06-27 : 16:48:23
|
| I am having a heck of a time finding this simple piece of information...I want to find out which tables in my DB are replicated vs which that are not. I can't seem to find a stored procedure or system view that will tell me this in a way I could easily put into a report or somethign else.can anyone tell me how this is done? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-27 : 17:05:21
|
| Check out the MSarticles table in the distribution database.Tara Kizeraka tduggan |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-28 : 03:05:30
|
| -- Following sql works for merge replicationSELECT Name FROM sysmergearticles -- This should work for all replication scenarios, not sure..SELECT name FROM sysobjects WHERE replinfo=128------------------------I think, therefore I am - Rene Descartes |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-28 : 10:51:36
|
| sp_helparticle issued at the publication database--------------------keeping it simple... |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-28 : 11:07:23
|
| From BOLsp_helparticle is used in snapshot replication and transactional replication.------------------------I think, therefore I am - Rene Descartes |
|
|
|
MuadDBA
628 Posts |
Posted - 2006-06-28 : 13:29:49
|
| Thanks guys! I don't know why I didn't think of a simple join between sysobjects and msarticles before. Chalk it up to lack of sleep. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-28 : 22:05:27
|
my eyesight must be failing me, but I can't find in the original post reference to merge replication only  --------------------keeping it simple... |
|
|
|
|
|
|
How to find replicated/nonreplicated tables?