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 |
|
beanz
Starting Member
35 Posts |
 Posted - 2005-10-15 : 16:39:56
|
| Hi everyone.Is it possible to list all the articles in a given publication? If it is could someone please point me in the right direction!?Cheers,Danny |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-10-16 : 21:49:32
|
| You can view via Enterprise Manager or use stored procedure sp_helparticle Nathan Skerl |
 |
|
|
beanz
Starting Member
35 Posts |
Posted - 2005-10-17 : 04:07:38
|
| sp_helparticle is exactly what I was after, thanks very much!Danny |
|
|
|
beanz
Starting Member
35 Posts |
Posted - 2005-10-17 : 05:38:53
|
| Hi again!Further to this I'd like to use the results from sp_helparticle in another script. Is it possible to return only certain columns from the SP?Ideally I'd like to return "article name", "base object", "destination object", "type", "vertical partition", "pre_creation_cmd".If this isn't possible using sp_helparticle is there another way to return the information I need?Cheers,Danny |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-10-17 : 10:54:08
|
| Look into how the system stored proc retrieves the info... use mastergoexec sp_helptext 'sp_helparticle'Nathan Skerl |
|
|
|
beanz
Starting Member
35 Posts |
Posted - 2005-10-17 : 11:01:52
|
| Thanks for that Nathan. I'm pretty sure I should be able to get what I need from that.Thanks very muchDanny |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-10-17 : 11:06:46
|
| No problem... just be careful when relying on system tables directly. It is always better to interact with them through the Information Schema views as Microsoft reserves the right to modify system objects at any time; though, in this case I do not think you have a view to employ. Nathan Skerl |
|
|
|
|
|
|
List Articles in a Replication Publication