Read list of publications

Is it possible to read the list of publications on a database? What I'd like
to do is give my PocketPC users the ability to choose which publication they
wish to subscribe to on a particular day simply by making a selection from a
listbox or a combo.
On Wed, 17 Nov 2004 16:10:18 -0500, "Earl"
<brikshoe@.newsgroups.nospam> wrote:

>Is it possible to read the list of publications on a database? What I'd like
>to do is give my PocketPC users the ability to choose which publication they
>wish to subscribe to on a particular day simply by making a selection from a
>listbox or a combo.
>
exec sp_helppublication
exec sp_helpsubscription - lists articles
J.
|||Thanks J, I'll give it a go.
"jxstern" <jxstern@.nowhere.com> wrote in message
news:loqnp0t76fc5uas8nij1mm347hm7jgbtsq@.4ax.com...
> On Wed, 17 Nov 2004 16:10:18 -0500, "Earl"
> <brikshoe@.newsgroups.nospam> wrote:
>
> exec sp_helppublication
> exec sp_helpsubscription - lists articles
>
> J.
>
>
|||Both executed successfully in QA. However, neither one returned a result set
(which should be just one item at this time). The publication in question
works properly in both directions, so I'm still scratching my head over how
to view the publication list.
"jxstern" <jxstern@.nowhere.com> wrote in message
news:loqnp0t76fc5uas8nij1mm347hm7jgbtsq@.4ax.com...
> On Wed, 17 Nov 2004 16:10:18 -0500, "Earl"
> <brikshoe@.newsgroups.nospam> wrote:
>
> exec sp_helppublication
> exec sp_helpsubscription - lists articles
>
> J.
>
>
|||Hi Earl,
You will have to run sp_helppublication in the publication database and you
will see the publications. System table Syspublications only exists in the
database that has been replicated, so make sure you are running the
sp_helppublication in the right database.
Another way is using sp_MSenumallpublications, HOWEVER, please KEEP in mind
that it was NOT DOCUMENTED. Microsoft may decide to change it without any
advanced notice. See Bill Hollinshead's comments on this topic:
http://www.google.com/groups?hl=en&l...cpmsftngx a08
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Your kind of up a creek here. The supported way of pulling your merge
publication is through an ActiveX script which uses the Merge ActiveX
control.
You could probably connect to the merge publisher and issue this command
through sp_helpmergepublications using ADOCE. Then present a dialog to the
users displaying these publications and have them select which one they
want.
The IBuySpy CE demo does something like this. You can select your publisher
name, and then this is fed to the ActiveX control.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%23xG5skSzEHA.1412@.tk2msftngp13.phx.gbl...
> Both executed successfully in QA. However, neither one returned a result
> set (which should be just one item at this time). The publication in
> question works properly in both directions, so I'm still scratching my
> head over how to view the publication list.
> "jxstern" <jxstern@.nowhere.com> wrote in message
> news:loqnp0t76fc5uas8nij1mm347hm7jgbtsq@.4ax.com...
>
|||Thanks Michael. I ran sp_helppublication in the publication database but did
not see the publication. Thats what has me stumped. I ran it without any
variables, thus it would appear that the list of articles should appear,
sooooo I must be overlooking something. I'll experiment with your
sp_MSenumallpublications.
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:7UZhKbVzEHA.2544@.cpmsftngxa10.phx.gbl...
> Hi Earl,
> You will have to run sp_helppublication in the publication database and
> you
> will see the publications. System table Syspublications only exists in the
> database that has been replicated, so make sure you are running the
> sp_helppublication in the right database.
> Another way is using sp_MSenumallpublications, HOWEVER, please KEEP in
> mind
> that it was NOT DOCUMENTED. Microsoft may decide to change it without any
> advanced notice. See Bill Hollinshead's comments on this topic:
> http://www.google.com/groups?hl=en&l...cpmsftngx a08
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Thanks Hilary. Well, it was a good thought, not a requirement of the
project, and in terms of CF or SQLCE certainly far down the list of "things
I could not do". Oh, I'm looking forward to reading the book.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23oBAjhXzEHA.3096@.TK2MSFTNGP10.phx.gbl...
> Your kind of up a creek here. The supported way of pulling your merge
> publication is through an ActiveX script which uses the Merge ActiveX
> control.
> You could probably connect to the merge publisher and issue this command
> through sp_helpmergepublications using ADOCE. Then present a dialog to the
> users displaying these publications and have them select which one they
> want.
> The IBuySpy CE demo does something like this. You can select your
> publisher name, and then this is fed to the ActiveX control.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "Earl" <brikshoe@.newsgroups.nospam> wrote in message
> news:%23xG5skSzEHA.1412@.tk2msftngp13.phx.gbl...
>
|||sp_MSenumallpublications shows my publication, but sp_helppublication does
not. I'm running them both in the pubs database -- is there any other reason
why sp_helppublication would not show the publication?
""Michael Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:7UZhKbVzEHA.2544@.cpmsftngxa10.phx.gbl...
> Hi Earl,
> You will have to run sp_helppublication in the publication database and
> you
> will see the publications. System table Syspublications only exists in the
> database that has been replicated, so make sure you are running the
> sp_helppublication in the right database.
> Another way is using sp_MSenumallpublications, HOWEVER, please KEEP in
> mind
> that it was NOT DOCUMENTED. Microsoft may decide to change it without any
> advanced notice. See Bill Hollinshead's comments on this topic:
> http://www.google.com/groups?hl=en&l...cpmsftngx a08
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Earl,
It seems really strange. Usually sp_helppublication depends on system table
syspublications. Please run the query, select * from syspublications to see
whether you have get any result.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!