July 28, 2009 at 5:22 am
Hi,
I have disabled replication on a SQL installation, but I have a feeling there are still come reminants from replication left on the database.
Is there a command which can be executed on the database to check if an object is marked for replication, I currently dont have the distribution database.
Thanks.
July 28, 2009 at 7:41 am
I have disabled replication on a SQL installation, but I have a feeling there are still come reminants from replication left on the database.
Did you disable replication or removed replication completely.
Is there a command which can be executed on the database to check if an object is marked for replication, I currently dont have the distribution database.
Which version of sql server you are using and what is the servicepack and type of replication you are using.
If you are using snapshot or transactional replication you can get the list of articles which are in replication. This has to be executed at the publisher in publisher db. works with 2000 with sp3 or above.
use publisherdb
sp_helparticle @publication='publicationname'
[font="Verdana"]Thanks
Chandra Mohan[/font]
July 28, 2009 at 8:09 am
I run into this every now and then when I restore a database (that was a subscriber or publisher at the time of backup) to a new instance. I find that the best way to remove replication information from a database is:
USE [DatabaseName]
EXEC sp_removedbreplication
GO
July 28, 2009 at 8:54 am
Chandu (7/28/2009)
I have disabled replication on a SQL installation, but I have a feeling there are still come reminants from replication left on the database.
Did you disable replication or removed replication completely.
Is there a command which can be executed on the database to check if an object is marked for replication, I currently dont have the distribution database.
Which version of sql server you are using and what is the servicepack and type of replication you are using.
If you are using snapshot or transactional replication you can get the list of articles which are in replication. This has to be executed at the publisher in publisher db. works with 2000 with sp3 or above.
use publisherdb
sp_helparticle @publication='publicationname'
SQL version is SQL 2000 and SP4.
Replication removed, but I still have a feeling that there are some elements elft of it.
July 28, 2009 at 9:13 am
here possibly could be stored procedures or system elements left, but if you have removed replication, that doesn't matter. It won't impact your server instance.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 28, 2009 at 9:52 am
Steve Jones - Editor (7/28/2009)
here possibly could be stored procedures or system elements left, but if you have removed replication, that doesn't matter. It won't impact your server instance.
Thanks.
Do you have a script the tells if an object is marked for replication ?
July 28, 2009 at 10:05 am
From BOL http://msdn.microsoft.com/en-us/library/ms151797.aspx
--Which objects in the database are published?
select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published
from sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1
union
select name as published_object, schema_id, 0, 0, is_schema_published
from sys.procedures where is_schema_published = 1
union
select name as published_object, schema_id, 0, 0, is_schema_published
from sys.views where is_schema_published = 1
sys.objects also talks about if something is published.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 28, 2009 at 1:20 pm
Steve Jones - Editor (7/28/2009)
From BOL http://msdn.microsoft.com/en-us/library/ms151797.aspx
--Which objects in the database are published?
select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published
from sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1
union
select name as published_object, schema_id, 0, 0, is_schema_published
from sys.procedures where is_schema_published = 1
union
select name as published_object, schema_id, 0, 0, is_schema_published
from sys.views where is_schema_published = 1
sys.objects also talks about if something is published.
Thanks for the reply, but the database is a SQL 2000 and it does not have the sys schema
July 31, 2009 at 6:21 pm
Try:
select * from sysobjects
where replinfo0
MJ
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply