SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

keithc1
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.

Keithc MCSE MCSA

tkizer
Almighty SQL Goddess

USA
37123 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.

Tara
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
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  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000