title: Create a datetime column in SQL Server 2008 with default value as current timestamp UTC
body: <p>I am creating a table in SQL Server 2008 like this:</p>
  
  <pre><code>create table Dummy
  (
     id int,
     status int,
     node_id varchar(512),
     createdDTTM datetime NOT NULL default CURRENT_TIMESTAMP
  );
  </code></pre>
  
  <p>However I want to specify a UTC timezone as default. I know in postgreSQL we have something like <code>createdDTTM TIMESTAMP NOT NULL DEFAULT (now() at time zone 'utc')</code></p>
  
  <p>Can we do similar thing here?</p>