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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Moving replicated table to different Filegroup
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

88 Posts

Posted - 07/06/2004 :  11:06:33  Show Profile  Reply with Quote
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 - 07/06/2004 :  16:00:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

Flowing Fount of Yak Knowledge

4110 Posts

Posted - 07/23/2004 :  06:26:02  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000