Hi Wayne -
The only property that you can really maintain for a subscriber is the
enabled property. BOL has an example of how to do that.
The following code retrieves the subscriptions for a single subscriber
without having to first retrieve the subscriber. Note, that this does
*not* populate the Subscriber object so a subsequent evaluation of the
Enabled property will be inaccurate (it'll show the default value of
true regardless of the actual state of the subscriber).
private SubscriptionEnumeration GetSubscriptions(string sId)
//Create an NSInstance and NSApplication object
NSInstance instance = getNSInstance();
NSApplication app = getNSApplication(instance);
//create a subscriber object
Subscriber subscriber = new Subscriber(instance);
subscriber.SubscriberId = sId;
//get the SubscriptionClassName
string subClass = "mySubscriptionName";
//get the subscriptions
return subscriber.GetSubscriptions(app, subClass);
HTH... Let me know if I've misinterpreted your post.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Tue, 9 Aug 2005 09:02:57 -0400, "Wayne" <[email protected]>
>I'm trying to updated subscriptions for a single subscriber, so far all is
>working well. However, I was wondering is there a way to pull back just the
>sing subscriber? Currently I am doing the following:
>As I understand from the help the new SubscriberEnumeration(nsInstance)
>creates a collection that contains all the subscribers in the database. This
>seems to be a bit inefficient, I'd like to just retrieve the subscriber
>based on the subscriberId.