I will answer my self.

I had to run sp_subcription_cleanup to remove this table.

This is can work with the Transactional replication too.

Abdu

I have done this before in a merge replication SQL2K, to change a column (data type or name),let's say you want to change the column C1

1- Create a new column...

Thanks Andy for the help!

I have changed the login Timeout for the agent, the querytimeout,the keepalivemessageInterval But there's no luck,I got the same error?

the password of the agent is sa.

I...

Hi,

Just one thing that was not mentioned here, is when you Drop the constraints you have to drop them in BOTH publisher and subscriber database in order for...

Thank you All for the Help!

It works now after droping the constraints.

Abdu

Hi Andy,

Thanks for the Help.

Afetr i setup the replication with the same data into another servers.

I had the same problem .I realize that there's one table (T) is locking the...

execute sp_removedbreplication 'dbname'

Abdu

NO the DTC service is not running.

Abdu

That the Corrcet, the Verbose History was checked.now it's back to Normal

Thanks Andy For the Help

Abdul