>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.

Our system runs in two different versions of sqlserver: 2k and 2005, but runs without a problem because we are only using commands compatible to both. However, when it comes to maintenance, we have two different approaches. If the procedures you are using are correct, no need for third party softwares I think.