>>SSMS doesn't have any specific format, but if you want to make sure you always pass valid dates, use ISO date format, e.g.
>>' YYYYMMDD'
>>
>>Check CAST & CONVERT topic in BOL
>>
>>and also
>>
The ultimate guide to the datetime datatypes>
>On the client side, we had to change all script to dd/mm/yyyy.
>
>So, we cannot use the same script. If we cannot find what is the local setting for this, I would have to adjust the generic procedure.
Can you post some code you're using to insert data?
If you're passing dates as dates (as parameters) the code should work without problems.
If you're embedding date strings into the code, then you're open to troubles.
If it's not broken, fix it until it is.
My Blog