Conversion error in SQL Server business objects

Conversion error in SQL Server business objects

While working with business objects in SQL Server I am getting the error "conversion of char data type to datetime data type resulted in an out of range datetime value."

    Requires Free Membership to View

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Either regional settings on the system are incorrect, or the value in the text string is not a valid date/time value.

This was first published in February 2007