Error Message: Can not update column as it s used in replication ? What could be the probable cause?
A. column not found in the replication DB
B. Column does not have insert permission
C. Replication Agent is not working
D. If this table is no longer involved in replication, there is a stored procedure to update the object s metadata and it is called sp_MSunmarkreplinfo (it takes a tablename as a parameter). Running sp_removedbreplication can be used to remove all traces of replication in the subscriber database, but obviously must only be done if this database is no longer needed as a publisher or subscriber.
Answer:D
Error Message: Can not update column as it s used in replication ? What could be the probable cause?
A. column not found in the replication DB B. Column does not have insert permission C. Replication Agent is not working D. If this table is no longer involved in replication, there is a stored procedure to update the object s metadata and it is called sp_MSunmarkreplinfo (it takes a tablename as a parameter). Running sp_removedbreplication can be used to remove all traces of replication in the subscriber database, but obviously must only be done if this database is no longer needed as a publisher or subscriber.