I have tried with sp_removedreplication and it did not work in my environment.

Roy,

I tried from SSMS 2008 and SQL Enterrise Manager 2000.

Both attempts are failed.

Any suggested solutions?

I'm very appreciated.

TJ

Hello Kumaran,

I almost have same replication issues when I tried to disable Publishing and Distribution through Wizard in SQL Server 2000.

My replication environment are:

-- Publisher (MS SQL Server 2000 SP3)

--...

Tom, Thanks for the info.

Did you refer to the SQL authentication login did not have privilege on Publisher’s table.

The SQL login all ready assigned “System Admin” and “db owner” on Publisher...

Hello Vinay,

Yes. I tried with sp_MSins_dbot_TableName, sp_MSdel_dbot_TableName and sp_MSupd_dbot_TableName and applied those in Subscribers.

I was setup the replication using SQL authentication.

execute sp_helppullsubscription @publisher = ‘Publisher server’,

@publisher_db = ‘Database name’;

Go

Publisher...

I checked on my SQL Server 2000 Publisher database and the parameters are:

Artid = 5

del_cmd = CALL sp_MSdel_dbot_TableName

ins_cmd = CALL sp_MSins_dbot_ElecConnData

upd_cmd = MCALL sp_MSupd_dbot_ElecConnData

name = t_TableName

I generated those above procedures...

I checked the sp by executing:

use Publisher database;

go

exec select * from sysarticles where

(

ins_cmd = ''sp_MSins_dbot_TurbDataGeneric' or upd_cmd = 'sp_MSins_dbot_TurbDataGeneric' or del_cmd = 'sp_MSins_dbot_TurbDataGeneric'

)

It returned a empty record.

Also, I checked on...

Thanks for your clarifications. It answers and clear up my questions.

I execute the following db script on publisher:

EXEC sp_replicationdboption @dbname = 'TestDB', @optname = N'Sync with backup', @value = N'true';

Errors on:

Msg 20622 - Replication database option 'sync with backup'...

I wanted to replicate a 100 GB database over WAN.

The database instance is setup with simple recovery model and it run on SQL Server 2000.

I research some articles on web...

Hi Jen,

Many thanks for your advise and light up on these. I will try it out and update you shortly.

I all ready configured my remote distributor with SQL credential on my production environment.

Now, I am testing the database replication on my local and my virtual server environment.

Questions:

...

Hi Jen,

I have similar issues on Backup and Recovery of Snapshot and Transactional Replication.

The SQL Servers are located in non-trusted environment

-SQL Server 2000 as publishers

...

Correction. SQL Server 2008 Developer Edition.