I have a MSSQL database with a date field that is messed up. Due to complicated issue. Many of the timestamp fields in my database went form the date "1/5/1900 9:24:32 AM" And it should be "1/5/2011 9:24:32 AM"
I am looking for a that will read all the fields in the database check to see if the year field is 1900 and if it is modify to 2011
Can someone give me a method for doing this.