David Benoit (11/30/2012)
We deploy database changes separately from code changes and allow for a layer of abstraction.
For this we have started using ALTER TABLE approach insead of TMP..INSERT approach plus keep columns nullable which makes the database chanegs independent of application side changes but finger crossed that nobody is useing "select *" in any SP or sql query :w00t:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)