Table Copy

  • Thread starter Thread starter Chris Savedge
  • Start date Start date
C

Chris Savedge

I'm trying to copy a table from one database to another using the DST
wizard. Everything works find until the last step.......at that point I get
an error that says "Error at destination for row number 1. Errors
encountered so far in this task: 1. Line 1: Incorrect syntax near 'Collate'.
" Although I get this error the new table is created but does not contain
data. Can anyone help?

Thanks,
Chris
 
chris

i think that it would help to post more of the TSQL that you see--

do you have a difference in collation between these two databases??
 
Back
Top