Is it safe to use the follow stored procedures in the order below t
effect a bulk enrollment of users
1) NSMain.dbo.NSInsertSubscribe
2) NSMain.dbo.NSInsertSubscriberDevic
3) NSMain.dbo.NSInsert<SubClassName>SubscriptionSchedul
4) NSMain.dbo.NSInsert<SubClassName>Subscriptio

Is it safe to use the following stored procedures in the order belo
to effect a bulk delete of users
1) NSMain.dbo.NSDeleteAllSubscription
2) NSMain.dbo.NSDeleteSubscriberDevic
3) NSMain.dbo.NSDeleteSubscribe

Please let me know

Thanks

As mentioned in replys to your post over in the forums, the short
answer is: no, those sprocs come with the standard "don't mess with
the underlying structure" warnings from Microsoft.

The Subscription Management Objects are the recommended way to go to
create subscribers, subscriber devices, and subscriptions.

If you're interested, I've created a little C# app that I use to
create test subscribers, subscriber devices, and subscriptions for the
SQLNS apps that I create. I've made it freely available on the
downloads page of my web site.
http://www.webbtechsolutions.com/downloads.aspx.

HTH...

--
Joe Webb
SQL Server MVP


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On Fri, 08 Jul 2005 01:00:16 -0500,
[quoted text, click to view]