Does anyone know how to safely delete a table from the system tables? I deleted a row for a table from the sysObjects table but failed to delete it from the subsequent tables. How can i find out all of the system tables I should remove the data from?
long story, but to sum it up, the database was hanging and i should have killed the processes, but in order to get rid of the table deleted it from the sysobjects because i couldn't get it to delete by dropping or truncating...it just froze...it ended up deleting, but the entire db froze, so i had to rebuild anyway..thank you!
once you clean up your systemtables you will need to make sure that you run dbcc checkdb against the database as well as sp_spaceused (with the rebuild option what ever that is)
Just deleteing the entrys won't clean up errors in the allocation tables.
I am probably forgetting something, but expect errors
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.