Working on a german server without knowing german is no easy task. I got this error and had to translate it.
Fehler beim Konvertieren einer Zeichenfolge in ein Datum und/oder eine Uhrzeit.
which would be
Conversion failed when converting date and/or time from character string.
The procedure was an import procedure and was expecting dates in the format of 28 MAY 2010. Unfortunately the development server was in german format, so I was getting the above error on the following line
select CONVERT(DATETIME,'28 MAY 2010',106)
Changing it to the german equivalent did the trick
select CONVERT(DATETIME,'28 MAI 2010',106)
But the client wanted the dates to remain in english and that was when i descovered the following syntax
SET LANGUAGE British.
Using this syntax before the procedure not only was setting the dates to british date format but also prompting the error messages in English :)