Post SQL Server 2005 SP2 Fix

Microsoft recently released an critical updated for post SQL Server SP2 Fix related to issues noticed after applying SP2 with existing SQL Server 2005 maintenance plans and Integration Services packages that contain cleanup tasks run those tasks at shorter intervals. Refer to : Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at…


Another DST Update

Just a quick update to the DST impact on SQL Server Compact Edition before rushing in for routine work. As mentioned in my earlier blog – GetDate() calls are the to watch for here also. In addition time reported in transaction log could also be incorrect. For that matter any application relaying directly on client…