restore sql 2000 database to sql 2005 error
Posted on 2006-11-21
I am trying to restore a sql 2000 bak file to a sql 2005 server database using t-sql. my restore statement is:
restore database DATABASENAME from mybackup with replace
The restore completes but with the following error in the messages:
Msg 156, Level 15, State 1, Procedure SYSKEYS, Line 1
Incorrect syntax near the keyword 'FUNCTION'.
The error message comes after the upgrade step from version 539 to 551. The rest of the upgrade steps go off without a problem. Any suggestions?