bigracefan
Programmer
I used Enterprise Manager to change a datatype from smallDateTime to nVarchar(100). The dates that where in that table are still there and I can change the dates with no problems. When I try to put a string in it, it gives me a conversion error. Telling me that it can't change the string to smalldatetime. I've even rebooted the server, with no change. I then changed the name of the field, and now I can't even change dates. It's telling me that a table or view is accessing the table. What can I do in this case? I don't see the view, if there is one. We have over 200 in that database. Thanks