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.
Subscribe to Blog via Email
#Meme15 31DaysSSIS Archive Blog Series Catalog View Certification Checklist Community Compatibility View Conference DBA DBADiagnostics DMO Index Analysis Indexing Links List MCM Monthly Checklist Off Topic PASS PASS 2011 PASSMN Performance Tuning Plan Cache Presentation Reblog Security Social Networking SQL Saturday SQL Server SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQLServerSyndication SSIS SSRS sys.dm_exec_cached_plans sys.dm_exec_query_plan T-SQL Tip Wait Stat White Paper XQuery