You will want to use the getutcdate() function instead of the getdate() function. This will return the UTC date instead of the local date.
There is no way to tell existing columns to convert to UTC time when saving the data.
SQL 2008 will include the DATETIMEOFFSET data type which will allow you to store the timezone information of the value along with the data type. You can read more <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266498,00.html”>here</a>