We recently went thru a security audit here at WDG and as a result, the Netops guys cut many liberal access rights on production machines. One of the services effected was our SQL boxes. It has always been a pain keeping our DEV / STAGING / LIVE SQL boxes in sync or update them for each upgrade / new version etc.
I stumbled across this VERY useful SQL tool from an old friend of mine, Tom Williams (whos now married with off spring - nice work mate :)
SQL Compare - Sales guff says "SQL Compare saves you astonishing amounts of time in development environments and in database administration. SQL Compare will help you push out database changes quickly, simply and with zero errors. SQL Compare will save you time at each and every step, from development to production.". And in reality it does. Been a great tool to view and migrate changes between SQL DBs!