Hi Zoran,

Thank you so much for your help. I tried to run it in the database that I am in and I am able to take out the subscription and drop my table.

Thanks again,
Sam

>If you have sufficient access rights (sysadmin fixed server role or the db_owner fixed database role) you should be able to execute them from any database context.
>
>
>
>
>>I saw the two store procedures in the master database. However, I am using a different database. How do I go about using it in a different location? Please help. Thanks, Sam
>>
>>>Check BOL.
>>>
>>>>
>>>>Thanks for the instruction. Where do I get the two store procedures that you have mentioned below? Please advise.
>>>>