Two things.

One, with SQL Server 2005 and on tracking when objects are modified, I would be more inclined now to use ALTER instead of DROP/CREATE.

Two, I agree with deploying a database via scripts. There may be changes as the database is going to production.