In my country my server has a dd/mm/yy format, using Win2000 server and SQL Server. Every date INSERT is done in this format.<BR>We uploaded everything into a new SQL Server in USA, where format is mm/dd/yy, so I keep getting INSERT errors.<BR>How do I set a database-specified dateformat, or else, set my own database (or server!) to use american format? <BR>Any help will be really appreciated.