January 27, 2005 at 8:57 am
I have inherited a SQL2000 database that is NOT set up for Replication
I need to delete a couple of erroneous tables from the database, but when I try to do this I get the error
Error 3724 Cannot drop the table scheme.bc000026m because it is being used for replication
However, if I try to Drop the table through SQL Query, I get the response
Cannot drop the table 'bc000026m', because it does not exist in the system catalog
Anybody any ideas please
January 27, 2005 at 9:13 am
Have you tried running an sp_removedbreplication just to make sure that the db is replication clean?
January 27, 2005 at 9:18 am
Yep; made no difference!
January 27, 2005 at 9:18 am
Yep; made no difference!
January 27, 2005 at 9:27 am
How about EXEC sp_msunmarkreplinfo 'bc000026m'
or
EXEC sp_configure 'allow',1
go
reconfigure with override
go
use your_database_name
go
update sysobjects set replinfo = 0 where name = 'bc000026m'
go
EXEC sp_configure 'allow',0
go
reconfigure with override
go
January 27, 2005 at 9:34 am
Had already tried sp_msunmarkreplinfo
Your suggested coding made no difference either unfortunately:-
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.
(0 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
January 27, 2005 at 9:35 am
Sorry, ran against incorrect Database; sorted, thanks!
February 11, 2005 at 11:21 am
I have 3 SQL servers that are replicated there is an entry, on each table that is being replicated.
Column Name Datatype Length Allow Nulls
rowguid uniqueidentifier 16 0
All rows that are replicated have the ROWGUID under the column name.
These are the only tables that are actually replicated if I remove this from each of those tables the table will no longer replicate.
Look at your replicated tables against one that is not and see if you have a unique or common column with all the tables in your database that are replicated
Just something to look at
I hope it helps
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply