Hi, I am trying to alter a column on an not replicated table, but I'm getting the following error message: Cannot alter column because it is 'REPLICATED'. The table I want to alter was replicated until I dropped replication to alter it. I found the following on MS KB: http://support.microsoft.com/?scid=kb%3Ben-us%3B811899&x=15&y=13 Unfortunately this KB article is for SQL Server 2000, but I'm using SQL Server 2005. I had a look into syscolumns anyway, seeing that the column I want to alter has colstat >= 4096. Any ideas how to mark this table/column as not replicated? Regards, Jan
I Hope this link helps http://www.replicationanswers.com/AddColumn.asp Procedure referred is exec sp_repldropcolumn @source_object = 'tEmployees' , @column = 'Forename' But would suggest to research the implications before doing it. Cheers Sat
Hi Sat, thanks for your reply. Unfortunately this only works with SQL 2000 as subscribers but I'm using SQL 2005. I found the following workaround: 1. Create a new table based on the table I needed to change with all changes 2. copy all data from old to new 3. Rename old table 4. Rename new table Regards, Jan