I have a table in a database that I cannot modify. I get this message:
Cannot alter the table 'CustNotes' because it is being published for replication.
It is in sql server 2005. However the database compatibility is sql 2000 (80).
The replication was apparently set up years ago and is no longer valid. There are no publications or subscriptions on the server. I have researched this and found most sites recommend using sp_removedbreplication.
My question is ... will the sp_removedbreplication procedure delete my table? ie. can i run sp_removedbreplication without doing any harm? I don't want to lose any of my tables or data as this is the production db.