The main problem is that do a quick query you find something that you have to load the whole of Management studio...  It is feature rich - but very annoying to do...

It depends on how the column will be used in the future.

The alter table script - adding a null column will not affect storage on disk as it added to the...

I have tried a few different ones.. and have found Redgate to be the best in quickness , ease of use...

Haev a quick investigation - one of the tables has a datatype of image and is trying to sum the image size which is then greater than an int.

This...

When trying to run the DB script on a Database - I get an error

"Server: Msg 8115, Level 16, State 2, Line 19

Arithmetic overflow error converting expression to data...

I used to use OSQL but was very slow and cumbersome...

I now use a modified version of this one:

http://msdn.microsoft.com/msdnmag/issues/04/09/CustomDatabaseInstaller/default.aspx

I would recommend using this method to deploy and it can...