February 3, 2011 at 9:39 am
Hi
I've attached a SQL 2000 database to SQL 2008 (attached from backup files)
Compatibility mode is changed to: SQL Server 2008
Original database had replication on it and columns in tables are still marked with:
is_published = 1
How can this be removed?
Tried : adding the database as a publication database and removed it again
Tried : sp_replicationdboption
The above does not remove the replication references.
Any ideas are welcome.
Thanks in advance
February 3, 2011 at 10:09 am
Nats007 (2/3/2011)
HiI've attached a SQL 2000 database to SQL 2008 (attached from backup files)
Compatibility mode is changed to: SQL Server 2008
Original database had replication on it and columns in tables are still marked with:
is_published = 1
How can this be removed?
Tried : adding the database as a publication database and removed it again
Tried : sp_replicationdboption
The above does not remove the replication references.
Any ideas are welcome.
Thanks in advance
Try using snapshot replication to make a copy of the database, then kill off the snapshot replication, drop the original database, and replace the original with the copy. A bit clumsy, maybe, but should work, I think.
Tom
February 3, 2011 at 12:32 pm
Could not do your suggestion but you gave me an idea. thank you!
Ran:
select * from sys.objects where is_published = 1
to get all the tables that was previously set for replication.
Created a publication (without a snaphot or running any agents) containing all of the objects
that was marked for replication
Then dropped the publication again
This basically did the trick - is_published = 0 again
Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply