Do you want to write a blog-spot? Contact Maria to activate you account for blog-writing.
Guest Blogger Guidelines & Suggestions »
Year 1900 date bug
NOTE: these scripts are just an example of how you might change the 1900-01-01 into NULL and I never tested them for real so there might be some error so please use them with caution.
It was recently discovered that the empty string is interpreted as the base date 1900-01-01 on SQL Server. This will be fixed in the coming release of SP5. If you have problems with this date in your archive, here is two example script...