See
http://msdn2.microsoft.com/en-us/library/ms189625.aspx>Hi all,
>
>I have moved foward to design our app in SQLServer2005. How do I provide the database backwards in SQLServer 2K for clients who have not move?
>
>Backup and restore our database into the client's side who use SQLServer 2000 will not work. We try to script the database in 2005 and change the option script to 2000. This has also fails. What other option I can use?
>
>Is there any solution, freeware, shareware or 3rd party solution to this? Maintaining 2 versions will be exhaustive on our end...
>
>Regards.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com