What parameters you are passing in sp_dropmergesubscription?

take a look in the code of sp_dropmergesubscription and see if you running on any valid sequence. May be SP is running successfully but...

Check this out.

http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput

This article by Kimberly Tripp describes about the VFL management.

Duplicate Post :-

http://www.sqlservercentral.com/Forums/Topic1447198-1549-1.aspx

yes it is a very good idea to start with these books.

But if you want to learn about deprecated features:-

http://msdn.microsoft.com/en-us/library/ms143729.aspx

http://technet.microsoft.com/en-us/library/cc707789(v=sql.105).aspx

Please take a look at :-

http://msdn.microsoft.com/en-us/library/ms175575.aspx

Duplicate Post..

http://www.sqlservercentral.com/Forums/Topic1446290-291-1.aspx#bm1446716

You can view synchronization status in subscriber and also validate subscription to see what is going on. But as DHeath said replication monitor is the best to see things is...

It looks like you have duplicate rows in MSArticles and MSSubscriptions. I would suggest to run the following commands:-

delete distribution..MSarticles where publisher_db = 'YourPublisherDB'

delete distribution..MSsubscriptions where...

Glad it worked for you.

Do you see anything under Local Publication then Publication and click on + of publication..If yes try the below mentioned command..

USE master

EXEC sp_removedbreplication @dbname='DBName'

GO

sp_dropsubscription @subscriber='SubscriptionName'-- If you find anything...

Check under replication "Local Subscription"? Is there any?

try this..

sp_droppublication @publication='publicationName', @ignore_distributor = 1

You can create publication from backup and use sp_addarticle SP for adding articles.

I would suggest that you figure out the offending query and tune it.

Just use group by in last.

SELECT

[values].value,

SUM(CASE WHEN Q1 = [values].value THEN 1 ELSE 0 END) AS Q1,

SUM(CASE WHEN...