I have this command which I execute on several servers to insert a record:
INSERT INTO [FieldType] ([[AddUser],[AddDate],[ModUser],[ModDate],[Title])
VALUES (1,'19/02/2010 02:05:06',1,'19/02/2010 02:05:06','Integer')
However, on one particular server, this doesn't work. I get this message:
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
Something is different on the client server in the configuration and I am trying to know what it is. Any help would be appreciated?