sql server replication: MODIFY DB REPLICATION MERGE -- sql server replication

MODIFY DB REPLICATION MERGE

castilla
8/16/2006 8:53:39 AM

sql server replication: Usually I use Enterprise Manager to remove the Merge Replication info before
trying to drop a database.

Now I used sp_dropmergepublication - sp_dropmergesubscription
-sp_dropmergepullsubscription - sp_dropmergesubscription - sp_dropsubscriber
- sp_replicationdboption - sp_dropdistributor - sp_removedbreplication
and successfully dropped the merge
publications associated with a database

When I try to do a MODIFY DATABASE
though, I receive :

table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot add
columns to table 'CAT_BANCO' because it is being published for merge
replication.

I need to do to
remove any remaining replication info so the drop database will work.

Re: MODIFY DB REPLICATION MERGE

castilla
8/16/2006 10:15:02 AM

Paul thanks but
THE PROBLEM CONTINUES

[quoted text, click to view]

Re: MODIFY DB REPLICATION MERGE

Paul Ibison
8/16/2006 5:07:04 PM

If the database is no longer used as a publisher or subscriber, then please
try running sp_removedbreplication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: MODIFY DB REPLICATION MERGE

Paul Ibison
8/16/2006 7:43:30 PM

You shouldn't have this problem now, but if you are certain that this table
is not being replicated, you could use sp_MSunmarkreplinfo which takes a
tablename as a parameter.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: MODIFY DB REPLICATION MERGE

castilla
8/17/2006 12:51:02 PM

Paul thanks but
THE PROBLEM CONTINUES

[quoted text, click to view]

Re: MODIFY DB REPLICATION MERGE

castilla
8/17/2006 3:31:01 PM

name
id xtype uid
info status base_schema_ver replinfo parent_obj crdate
ftcatid schema_ver stats_schema_ver type
userstat sysstat indexdel refdate
version deltrig instrig updtrig seltrig category
cache
CAT_BANCO
1741965282 U 1
6 1611081987 50338 128 0 2004-12-06
15:00:22.920 0 50336 2
U 1 115 0 2004-12-06 15:00:22.920
0 407424971 375424857 391424914 0 2568
0

Copied and stuck in a txt

Thanks!!!

[quoted text, click to view]

Re: MODIFY DB REPLICATION MERGE

Paul Ibison
8/17/2006 9:39:57 PM

Were there any errors when you ran sp_MSunmarkreplinfo?
Also, please select the row for 'CAT_BANCO' from sysobjects and post it up
(csv).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: MODIFY DB REPLICATION MERGE

Paul Ibison
8/18/2006 12:00:00 AM

If you can confirm that you've run sp_removedbreplication so there's no
publication of this database, the value of replinfo is zero for this table,
and yet you can't edit it and when trying to do so you receive an error
indicating that it is part of a publication, then this is very strange and
I'm out of ideas! If anyone else can help then great, otherwise consider
opening a PSS call.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.