Sql Server Error: Unable to modify table.   The conversion of a date data type to a datetime data type resulted in an out-of-range value. The statement has been terminated

Question: How do you resolve "'YourTableName' table
- Unable to modify table.  
The conversion of a date data type to a datetime data type resulted in an out-of-range value.
The statement has been terminated."


Please Login to see the rest of the answer

Answer: Warning! this solution should not be performed on a production Server, assuming this error happens on your local Development Machine. 
1. Recreate or create a new column that has the Data type Conversion Problems.


Write an Article
If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.


© 2022 - ErnesTech - Privacy