InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:20:15 GMT20http://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspxThanks all for the inputs.Found out the reason.We have created a different service account for various applications.And there is one service account that was used across three applications in three different servers.And in one of the server the language setting was different:w00t:This was the issue, we have added the "language" in our connection string, to override the differences.Thanks allSat, 23 Feb 2013 06:54:24 GMTcmrhemahttp://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspx[quote][b]cmrhema (2/22/2013)[/b][hr]15/02/2013 04:25:5721/02/2013 02:25:57these are non working[/quote]These are invalid dates for US English settings.Fri, 22 Feb 2013 06:50:16 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspxPlease check the below points too:1. what is you DB server time zone & web server time zone2. Are you inserting datetime variable or a varchar variable data3. As you are saying that you got error while inserting data, I think you are using varchar string as input. So, please check the server time zone (ddmmyyy) or (mmddyyy).I hope this can help.Fri, 22 Feb 2013 02:50:08 GMTAnuj Rathihttp://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspxcan you plz send the script the you are using for this?Fri, 22 Feb 2013 02:05:56 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspx15/02/2013 04:25:5721/02/2013 02:25:57these are non workingFri, 22 Feb 2013 00:44:07 GMTcmrhemahttp://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspxCan you show us some of the data that is failing?Thu, 21 Feb 2013 20:59:44 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1422855-391-1.aspxHi,I have a stored proc which inserts date time. It inserts successfully. But 2 PM afternoon, it gives me date time converion error. The next day it works fine. But daily after 2 PM, it gives error converting varchar to date time error:crazy::angry:The weird thing is its showing this error only in one of the server, which is live server. Whereas it works fine else where in other servers.The server level setting is US English, the logins used are US English.Any idea where to look pls?Thu, 21 Feb 2013 20:40:32 GMTcmrhema