Recently we have faced one issue with converting the datetime to varchar.
When we are trying to execute the query it is throwing the error like conversion failed. out of range etc...
The database was migrated from SQL Server 2008 to 2014.
In 2008 it was executing fine without any issues. But it is not working in SQL Server 2014.
We tried to modify the query but not worked. We tried all the possible ways.
In last we have compared the properties of the application login in 2008 and 2014. In 2008 default language for that login is British English. In 2014, when migrated we have did not changed it to British English. Once we changed that to British English problem solved and every thing working as expected. :)
So now on wards we need to check the Login default language also while migrating.
When we are trying to execute the query it is throwing the error like conversion failed. out of range etc...
The database was migrated from SQL Server 2008 to 2014.
In 2008 it was executing fine without any issues. But it is not working in SQL Server 2014.
We tried to modify the query but not worked. We tried all the possible ways.
In last we have compared the properties of the application login in 2008 and 2014. In 2008 default language for that login is British English. In 2014, when migrated we have did not changed it to British English. Once we changed that to British English problem solved and every thing working as expected. :)
So now on wards we need to check the Login default language also while migrating.
No comments:
Post a Comment