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.


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

Edited Version 2

Question
How do you resolve the"'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.

 This error happens when you are trying to insert into the Date Column in your database that has a "not null" specified. Do not insert the default date value that happens to be 1/1/0001 12
00
00 AM into the date column otherwise, this error happens. Make sure that the date value has the correct date before you insert or update the database.






For peering opportunity Autonomouse System Number: AS401345 Custom Software Development at ErnesTech Email Address[email protected]