Hi i am using this proc at subscriber as
sp_mergesubscription_cleanup 'xx.xxx.xxx.xxx (public IP)','pubDBNAME','PUBNAME' but this is not working
when i use to delete like this sp_mergesubscription_cleanup 'sysname','pubDBNAME','PUBNAME' this is working
how to make proc work with public ip
asked Jun 15, 2011 at 09:50 PM in Default
As per my knowledge you cannot pass the IP Address to publisher parameter in sp_mergesubscription_cleanup, you can use the server name only.
answered Jun 15, 2011 at 10:21 PM