There is a proc on the MSDN that I use and it creates a list of statements that you copy and paste back into QA.  I have thought of modifying it...

I end up scripting just the CREATE component of all views, pocs, functions and then replacint CREATE with ALTER and runing the script in QA to incorporate all column references...

Great posting and dialouge.  If you need to join a comma list to an Id (int) field, you just have to convert the ID field to varchar.  There should be...

I use EM to script all views, SPs and UDFs with only the "CREATE" option selected and then run a REPLACE ALL "CREATE " with "ALTER ".

As long as no...

I agree completely.  It saves amazing amounts of time and the new version's speed is definitely worht the upgrade.  A line by line and field by field option for excluding...

The article Jonathan linked to was perfect. The temp table solution is easy to use and works great.

thanks

Is this issue solved? I have had some overflow errors trying to use convert to convert a 6 digit number (say 100123) to a 5 digit number using "convert(numeric(5,2),intNumber)....