July 19, 2010 at 1:13 am
Good Day All,
I have a problem with replication on my database where I had replication running but then the database crashed and I had to completely un/install SQL Server, create a new database and restore a backup to that database. Now I do not see the subscription in SQL Server but whenever I want to drop a Table (used for temp purpose) it tells me the table is used for replication. Can someone please help me?
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
July 19, 2010 at 10:04 am
Try running sp_removedbreplication on your publisher. I think that will remove everything and then you can continue.
-Roy
September 15, 2010 at 3:43 am
Roy Ernest (7/19/2010)
Try running sp_removedbreplication on your publisher. I think that will remove everything and then you can continue.
Roy,
Just want to say thank you it worked. Sorry for taking so long to come back but it has been busy and this replication thing not top priority.
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply