SQL Server 2005 has some issues with generating SQL Scripts for SQL Server 2000. Checkout this blog entry over at
The Web Jedi for a detailed description of the problems, followed by a simple solution: You need to make sure you're using SQL Server 2005 SP2, before the SQL Server 2000 script is generated correctly. There's a screen shot at the bottom of the page on his blog that shows how to generate SQL Server 2000 compatible script.