>My development system uses SQL 2008.
>A client uses SQL 2000.
>
>I routinely add indexes to tables during development and then I write a script to add that index to the client's 2K system.
>
>I think I've missed a few over the years.
>
>Is there a way that I can generate a script on the 2008 system that will allow me to update the indexex on the 2K system?
>
>I've seen a few things on the web that might do it, but nothing that seems certain.
>
>Any idea?
You can try using RedGate SQLCompare to generate all structure differences.
If it's not broken, fix it until it is.
My Blog