How do I change default date format to "dd/mm/yyyy" in SQL Server.Currently it is accepting as mm/dd/yy.I have changed in regional settings but it is not reflecting in server.My problem is I am passing an Insert statement having date field in &#039dd/mm/yyyy&#039 format.for this server is giving as "char to date conversion out of range".The same thing works fine on my local web server .Please help in this.