El_Mou (5/10/2013)
yes i set the language i did it but still having the same message errorits supposed work fine ( of course with setting the language in conversion datetime as you show me ) because they are imported from the production environement like they works there
the 4 SP's who doesnt work yesterday had just a problem with language in conversion datatime type no more .
im supposed to change nothing on the script , my objective is to test the new features SS2012 and make a comparative study between BI tools MS SQL server 2012 and IBM Cognos 10.1
and the Microsoft Dynamics is on the is in the process of replacing another ERP so they would see if the SSQL 2012 can be more productive then others BI tools ( COGNOS ) associated with Microsoft Dynamics ( Already validated )
If you don't want to change anything, you will need to find which particular value causing you a problem. So, you will need add some sort of validation of values before they used in INSERT.