Recently I tryed to change the data base structure from char to vchar. However the sql server gave me the 5074 dependent error. I know why this message appear because some of the table is dependent on the other. That why SQL server won't allow me to change the data type. Anyone know who to un-lock the table / server, so that I can change the value with out an error? my e-mail is