>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

So, basically, this:

UPDATE Member SET AddDate='2009/02/17 03:44:25.157' WHERE Numero=1

...has to be changed to:

UPDATE Member SET AddDate='20090217 03:44:25.157' WHERE Numero=1

Because, the date format was already in YYYYMMDD but it had the slashes in it. Is this what was causing this?