microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Using just stored procedures to create and delete users

Subject: Using just stored procedures to create and delete users
From: sidgam
Date: Fri, 08 Jul 2005 01:00:16 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Is it safe to use the follow stored procedures in the order below to
effect a bulk enrollment of users:
1) NSMain.dbo.NSInsertSubscriber
2) NSMain.dbo.NSInsertSubscriberDevice
3) NSMain.dbo.NSInsert<SubClassName>SubscriptionSchedule
4) NSMain.dbo.NSInsert<SubClassName>Subscription

Is it safe to use the following stored procedures in the order below
to effect a bulk delete of users:
1) NSMain.dbo.NSDeleteAllSubscriptions
2) NSMain.dbo.NSDeleteSubscriberDevice
3) NSMain.dbo.NSDeleteSubscriber

Please let me know.

Thanks.


<Prev in Thread] Current Thread [Next in Thread>