Your response is greatly appreciated...thank you

I think you are right at some level because I am passing all the information to the Publisher but nothing is happening but not sure how you check that to make sure its working. If I do put in wrong data or anything it does error out saying it cant find the subscription or whatever IF I purposely put in incorrect information. So that tells me its making the correct connections on the internals of MSSQL..(unless I am mistaken, which is very possible)

the code looks like this

DECLARE @publication AS sysname;

DECLARE @subscriber AS sysname;

DECLARE @subscriptionDB AS sysname;

DECLARE @subscription_type AS sysname;

SET @publication = N'Sandoval_Publication';

SET @subscriber = $(Client Name);

SET @subscription_type = 'ALL'

SET @subscriptionDB = N'Sanrep';

USE [Sandoval]

EXEC sp_dropmergesubscription

@publication = @publication,

@subscriber = @subscriber,

@subscription_type = @subscription_type

@subscriber_db = @subscriptionDB;

GO