Is there any substitute for 'sp_removesrvreplication' ? There are some generic errors which usually comes when we run sp_removesrvreplication however we do not want any erros and it should be clean.

Following are the generic errors

Could not find stored procedure 'DBNAME.sys.sp_MSdrop_mergesystables @whattodrop=3'

There are a variety of things you can try.

sp_removedbreplication.

sp_dboption 'databasename','publish',false

sp_dboption 'databasename','merge publish',false

Now to drop the publisher and subscriber try the following:

sp_dropsubscriber @subscriber=SubscriberName

If that does not work try

sp_dropsubscriber @subscriber=SubscriberName, @Ignore_Distributor=1

Then try

sp_dropdistpublisher 'PublisherServerName'