I am trying to Copy Database Objects from my Local Server to another Server using 'Copy Sql Server Objects Tasks' in DTS. This was working fine until today when I received an error saying that I wasn't a user for some other database on the destination server. When I try to set the task up again it won't let me select a destination DB because everytime I click on the dropdown box it gives me another message about not being a user for this other DB.
I Checked my Default database and it is correct. Has anyone seen this before or have any idea what is going on??
Thanks.
fryere