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)

Need to update old area codes

I have files with area codes that are several years old. Everything I've seen about updating area codes deals with area codes that are current and are about to split in the near future. How would I go about bringing old area codes up to date?It's based on the area code and the exchange...go to usps site...|||Er, Brett, are you sure you want to point sync to the Postal Service? Why would they give a rat's ass about area codes?

Could you provide a URL?

I would love to have a consistant source of Area codes, not to mention international codes. right now I have to search around scrubbing various web sites for up to date lists.|||bpdWork, Which web sites are you using to get your lists? At the moment I'm not even sure what kind of data I need to do the job.|||Originally posted by sync
bpdWork, Which web sites are you using to get your lists? At the moment I'm not even sure what kind of data I need to do the job.
http://www.nanpa.com/nanp1/AllCodes.zip|||Thank you jbroyles. It seems that in order to use the NANPA data, the area codes that need updating must have dates associated with them. Is that correct? My data does not have dates.

Peter|||Originally posted by sync
Thank you jbroyles. It seems that in order to use the NANPA data, the area codes that need updating must have dates associated with them. Is that correct? My data does not have dates.

Peter

It seems you would be correct.|||bump|||[doooh]
postal service
[/dooh]

I used to have a linke...it might have been ATT...

try this

http://www.vzmultimedia.com/customersupport/areacodes/recent_changes.html

or this

http://www.consumer.att.com/global/english/usa_codes.html

There used to be a conversion list using exchanges....