Alter table fails!

[nowayout]

Hi all,

I am trying to change the column with varchar instead char and add additional colum in to table but it says that it cannot be modify because the table is in replication while thereis no replication running on that table and i have deleted all the reaplication running so what is the problem?

Error:

'test_table'table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.test_table' because it is being used for replication.

 

[mrdenny]

Even those the distribution has been removed the article may still exist. You will need to drop the article before altering the table.

To be sure that it's all disabled remove the replication from the server. If it can be removed then everything is disabled. If not, then something is still configured.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[nowayout]

i did remove all the ting but still getting the same error after that too. how can i find that in server. how do i look up on distribution database?? or what!!!

help please Thanks

 

[mrdenny]

You can check the MSpublications and MSArticles tables in the distribution database to see if it still has the article or publication.

Denny

--Anything is possible. All it takes is a little research. (Me)