Very often in Australian clients because they have a special time and date

  1. Open SQL Server Management Studio -> Tools -> Options... 


  2. Designers -> Un-tick Prevent saving changes that require table re-creation -> OK

  3. Go to pcDATA_EFP -> Tables -> right click on one of the FACT tables -> Design 

  4. Use the combo box on the line ChangeDatetime -> Change from datetime to nvarchar(50) 

  5. Close the tab -> click on Yes to save the change

  6. Repeat the same action on all FACT tables in pcDATA_EFP database.

  7. Done