Undocumented SP help

#1

Hello

I hope someone can help me. I need to know what the status codes mean
for the results of the sp_MSenum_subscriptions SP from the
distribution database. It seem that this is an undocumented SP and I
can't find much info about it.

Thanks,

Cat

#2

On 21 Feb, 10:38, funks... (AT) gmail (DOT) com wrote:

Quote:

Hello

I hope someone can help me. I need to know what the status codes mean
for the results of the sp_MSenum_subscriptions SP from the
distribution database. It seem that this is an undocumented SP and I
can't find much info about it.

Thanks,

Cat

Should have mentioned that I'm using SQL 2000.

#3

On 21 Feb, 10:42, funks... (AT) gmail (DOT) com wrote:

Quote:

On 21 Feb, 10:38, funks... (AT) gmail (DOT) com wrote:

Hello

I hope someone can help me. I need to know what the status codes mean
for the results of the sp_MSenum_subscriptions SP from the
distribution database. It seem that this is an undocumented SP and I
can't find much info about it.

Thanks,

Cat

Should have mentioned that I'm using SQL 2000.

Solved it - had to trawl through the code of the MSDistributions table
but the runstatus column is the one to look out for.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Undocumented SP help

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Undocumented SP help - 02-21-2008 , 04:38 AM

Re: Undocumented SP help - 02-21-2008 , 04:42 AM

Re: Undocumented SP help - 02-21-2008 , 01:19 PM