Remove problematic table from list of articles

generate create table script of table

re-create table on subscriber.. export data from publisher..

Add table in article list... start synchronizing...

If your requirement would have been to refresh data on test server everynight then I would have suggested Snapshot replication. But as I understand you also want to make sure...

Run select on following objects in distribution database to find status.

select * from MSlogreader_history

select * from MSsnapshot_history

select * from MSdistribution_history

select * from MSmerge_history

select * from MSqreader_history

I am not sure what...

how did you add column? I am sure you have not used sp_repladdcolumn procedure to do this.

Although it is not recommended but still if you want to change value in system table. You may do it by starting sql server using -f switch.

like:

sqlservr -f

DUPLICATE POST.................

It is failing because USERA does not have permission to access Oracle table. you need to type in userid and password in security tab of linked server. To do this:

Select...

are you trying to create a job from different computer? If yes then I am sure you have client tools on that system with Service Pack 1. upgrade client tool...

use port number while specifying sql server name

1. Click Start, click Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.

2. In the Connect to Server dialog box, specify the name of the appropriate...

is it computed column? Thats the reason behind failure.

set arithabort on before executing update statement

are you planning to use same SQL Server name?

In addition to what Martin said, If you are using CE 3.0 then use ALTER TABLE to SET identity.

I think you will not be able to stop without stopping sql service. you may try killing process id using tskill command thru DOS Command prompt

I am sure, you are using wrong file names.

I will suggest you run following script on server where you performed backup:

select 'disk = ''' + physical_device_name + ''',' from backupmediafamily...