It hadn’t particularly occurred to me that there would be data changes involved with the 2007 Time Zone changes in the SQL Server databases.  But as I was looking around I did find that within SQL Server Notification Services there is some data that does need to be updated.  There is a Knowledge Base article that details out the changes that need to be made and hopefully all of you out there using SQL NS gets a chance to get this implemented prior to the time zone change.