November 23, 2002 at 9:42 pm
I am trying to export my data to another machine via DTS. I already created the objects but keep getting this error on the transfer:
In file STEVENW.ULTIPRO_USG.PRV in statement on line 1474
Transfer Status: Creating Permissions on destination database
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or column names. Use a single space if necessary.
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ''.
November 25, 2002 at 3:37 am
Look in the STEVENW.ULTIPRO_USG.PRV script. You will probably find it in the C:\Program Files\Microsoft SQL Server\80\Tools directory. I guess you will find an error on line 1447. You can repair it and run the script in the query analyzer.
I guess if tyou use DTS to transfer the data afterward it will work.
As an alternative you can use the wizard to create a script with the database structures and just DTS only to transfer the data.
Joachim.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply