I'm using SQL Server 2005. I'm trying to change the data type of a column from varchar(10) to smallDateTime in design mode. When I go to save the change...I get the following error message:

"- Unable to modify table.
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."

This table has 302 records in it. The column in question contains date values in the format of mm/dd/yyyy.

If I need to convert this over to a new table with the only thing being different is the column being defined now as a smallDateTime, I have NO idea how to write the SQL Code.

Please help!

Thanks,