trying to DTS a SQL2005 database to remote host and it doesnt work

/emoticons/confused.gif

Hello, I am trying to DTS a SQL2005 database to remote host and it doesnt work.

I am getting :

Invalid STDGMEDIUM structure error - incorrect syntax error near ')'

I dont know what order the DTS copies the db across, but there was an error in one stored proc that I fixed and it ran again up until bumping into this one.

unfortunately I have no idea what this means as my stored procedures are executing fine. This is a database that was upgraded from sql2000 to sql2005 recently.

Can anyone advise on what I should be looking for and where.

Many thanks

Post Edited By Moderator (mjp) : 8/6/2007 7:58:32 PM GMT

 

Hello Bruce


I am ashamed.....I have only just seen your reply. How rude of me, it was a conflict as you pointed out.


apologies for very late response.


A