I've been away from SQL Server since 2002, and as a means of getting back into it, have been updating some sql generation code I wrote back on SS 6.5/7/2000 called SSCodeGen to work on SS 2008/2005. Its pretty basic stuff, and I realize SS Management Studio can now generate scripts, but if anyone would give it a try, and let me know what they think, suggest improvements (new standards of sql coding I am not yet aware of for example), I would be grateful. Its got a (very) basic VB front end to it, it doesn't need installing, just downloading to your pc. It's virus free (according to avast, and microsoft security essentials), and the pc had a deep scan before I created the .exe. Its at www.RaisinTech.com/SSCodeGen.exe. The old version for SS 7/200 can be found at http://users.quista.net/thealey/index.htm, and this old website will give you some idea of the what to expect. The new version only does the SQL scripting for the moment.