Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Moving replicated table to different Filegroup

Author  Topic 

Yak Posting Veteran

88 Posts

Posted - 2004-07-06 : 11:06:33
This kind of spans off my below Filegroup post but thought it deserved it's own thread.

I trying to move a table that is being used in replication into a new filegroup but I keep getting the following error. Any ideas? Thanks

Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.tablename' because it is being used for replication.


Almighty SQL Goddess

38200 Posts

Posted - 2004-07-06 : 16:00:11
You will need to drop replication. Make your change. Then recreate replication. Before you drop it though, script it out to make it easier to recreate. Just right click on the publications and go to generate sql script.

Go to Top of Page

Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-07-23 : 06:26:02
you don't need to drop the replication. just issue an sp_droparticle. after you made the changes, issue an sp_addarticle. :)
Go to Top of Page

- Advertisement -