Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
keithc1
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.Keithc MCSE MCSA |
|
tkizer
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.Tara |
|
|
jen
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. :) |
|
|
|
|
|