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."

Solution: 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.


Edit this Article
Sql Server Error Technology published
Was this page helpful?
Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
If you log in, you will be notified when someone leaves a comment.

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

Your Session is Ending
Login to Continue

© 2021 - ErnesTech - Privacy