need urgent help ! - remove immediate updating subscription

Hi ,
I have set up my subscription to be immediate updating which has led the
application program not able to bulk copy for table that has been subscripted
for immediate updating so how can i remove it ?
appreciate ur advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200603/1
Hi,
How can i remove the subscriptions from Replication --> Subscription ?
i have removed all the subscriptions & publication from both end of the SQL
Server but still cannot seems to get rid of that subscription in Replication
--> Subscription
appreciate ur advise
tks & rdgs
maxzsim wrote:
>Hi ,
> I have set up my subscription to be immediate updating which has led the
>application program not able to bulk copy for table that has been subscripted
>for immediate updating so how can i remove it ?
>appreciate ur advise
>tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200603/1
|||You can use sp_dropsubscription (push) , sp_droppullsubscription and
sp_dropsubscription (pull).
If you're using BULK INSERT there is the option to fire triggers on the
insert which will enable the immediate updatinfg subscribers to work.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi ,
I have used sp_helpsubscription on both server which shows no subscription
so can i still delete ?
with the sp_dropsubsription ?
tks & rdgs
Paul Ibison wrote:
>You can use sp_dropsubscription (push) , sp_droppullsubscription and
>sp_dropsubscription (pull).
>If you're using BULK INSERT there is the option to fire triggers on the
>insert which will enable the immediate updatinfg subscribers to work.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200603/1
|||You can have a look at sp_MSenumsubscriptions to see what is happening when
you click on the subscriptions folder. The key tables in each subscribing
databases are sysmergesubscriptions and MSreplication_subscriptions. If this
database is no longer a subscriber, then run sp_removedbreplication, which
removes the redundant system tables. If you want these tables to remain,
then simply locate the redundant record in the above system table and delete
it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi,
The Bulk Copy is actually done by the ERP Application when doing a restore
od the biz data
It was complaining that a particular tbl is immediate updating subscription
so cannot bulk copy
any solution to prevent this ?
appreciate ur advise
tks & rdgs
Paul Ibison wrote:
>You can use sp_dropsubscription (push) , sp_droppullsubscription and
>sp_dropsubscription (pull).
>If you're using BULK INSERT there is the option to fire triggers on the
>insert which will enable the immediate updatinfg subscribers to work.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200603/1
|||You could use a DTS data transform instead and force it to not do the fast
load - that way the triggers will fire.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)