I've got some date/time data in a string, in the format '26/10/2009 09:06:43' (i.e. the date is in UK format). When I try

SELECT CAST('26/10/2009 09:06:43' AS DATETIME)

I get the following error:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

I'd appreciate any help you can give.