Convert database from sql 2005 to sql 2000

Hi,

Can anybody tell me that how to convert database from sql server 2005 to sql server 2000. I tried with generated script and in that i selected the option for sql server 2000 but still while trying to run that script it is throwing an error. the error is:

Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.

plz help.

Thanks,

Poonam

Hi,

which service Pack are you using, there had been issues in the RTM built which were fixed in SP1. (Unfortunately I can′t remember any details about that). Could you please post the non-working snippet here ? If you are not sure where the error occurs (as the parser will begin the new numbering after each GO statement), try to execute the script step-by-Step to narrow down the problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de