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?