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 |
|
jaami01
Starting Member
1 Post |
 Posted - 2005-08-23 : 04:53:13
|
| hi,i want to get the list of publications programaticaly added for sql server. any stored procedure or query? or any idea about it?jasim |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-08-23 : 10:49:26
|
| I'm lost. "list of publications"... "programaticaly added"... "for sql server"...Is it just me? |
 |
|
|
skillile
Posting Yak Master
208 Posts |
Posted - 2005-08-23 : 13:48:19
|
| Are you using replication????slow down to move faster... |
|
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-08-23 : 14:02:03
|
Hi,For each database: Select * From SysPublications Replace "*" with the columns you require.Also see undocumented procedure "sp_foreachDB" - to query each DB on in your instance.Good luck. |
|
|
|
|
|
|
how can i get the list of publications?