>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.