title: SQL Server 2008: Bulk Datatype Change
body: <p>I have an SQL Server 2008 database with many tables.  I've been using the now lame <code>datetime</code> datatype and want to use the new and better <code>datetime2</code>.  In most places where I have a datetime field, the corresponding column name is <code>Timestamp</code>.  Is there anywhere to do a bulk change from <code>datatime</code> to <code>datetime2</code>?</p>