You can look for rows where there may be invalid dates by using the IsDate function in TSQL.

Select * from MyTable where IsDate(MyColumn) = 0

Note, however, that there are exceptions where IsDate returns true (1) even though you might not think of it as a valid date. For example:

Select IsDate('2010')

returns '1'.