Hi -
Any one have idea where the SQL server save information about the Table schema other than the Syscolumns. I noticed that when we dropped any column from the Table in syscolumn kept the information of presents column but the Transaction log kept the information of previous columns... it seems that SQL server kept the information about the earlier schema of Table somewhere but unable to find out.
Can anyone suggest me something for this.

Thanks,
Baddy

---

Thanks,
Baddy