I fully agree - I was going to add support for changing data types in stored procedures and UDFs too, but since the database I wrote this for used neither I couldn't justify the time at work!! However, I already have scripts for re-assembling stored procedures so I might well add that support sometime soon when work is a little less chaotic. Mind you, considering that it would involve a lot of string manipulation I'd err on the side of utilising the CLR as it is more efficient at that sort of work. It's something I might have a look at sometime soon, but in the meantime there's quite a few scripts flying about to get hold of stored procedures and functions from a database so it could be an interesting project for someone! 😀