Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-09-11 : 13:09:08
|
| Hi allRecently we have restored a database from the client site which had replication on tables.Now when i am trying to alter the table in the local server which don't have any replication implemented, i am getting the following error..ALTER TABLE INVOICE ALTER COLUMN INVOICE_SOLD_TO_PUB_X_REF NVARCHAR(40) NULLCannot alter the table 'INVOICE' because it is being published for replication.pls help me how to resolve this issue... |
|
|
Tindjin
Starting Member
6 Posts |
Posted - 2006-09-14 : 17:39:51
|
| Look up "sp_removedbreplication" in BOL. |
 |
|
|
anilkdanta
Starting Member
25 Posts |
Posted - 2006-09-15 : 06:11:03
|
| Venkath,BOL has small information documented. It says - When you restore Replication Database to a different server, all replication metadata is removed after restore. But in your case it looks like the metadata still exists.sp_removedbreplication - removes all the replication Objects. But you wanted to alter the tables.Read some documentation about back up and restoring of replication databases. And try to find out if you have missed anything while backing up or restoring. |
|
|
|
|
|
|
Pls...can not alter the table being replicated