when i run this script on SQL 2008 i get an error

Msg 213, Level 16, State 1, Line 197

Column name or number of supplied values does not match table definition.

its...

i would suggest 2 tools that we use can help maintaining the database structure.

1. RedGate SQLCompare

2. VS 2008 Database Edition

these 2 allows you to compare and keep track database...

Even thought the idea is ok but its not feasible in the production environment. we have hundreds of tables and views and stored procedures and we cannot include everything in...