SQL Server Performance Forum – Threads Archive
delete system tableOne of my users created a table named ‘dtproperties’ of type system and now I can’t delete it, when I try as ‘dbo’ it says: ‘you tried to delete one or more system objects….not deleted’ p.s. I’m aware ‘dtproperties’ is already a system table but it’s like this user just duplicated it.
Read from below link under "A System Table Mystery " : –
http://www.windowsitpro.com/Articles/Print.cfm?ArticleID=7839 Deepak Kumar –An eye for an eye and everyone shall be blind
There may be two tables: one called xyz.dtproperties (xyz = user’s login) and one called dbo.dtproperties.
dtproperties holds informations about diagrams. If it is dropped, you can’t open the existing diagram anymore. If you create a new diagram, the table will also be (re)created. As the article mentions, it’s easy to fool EM here. However, running a
DROP TABLE dtproperties in QA works without problems. —
SQL Server MVP
Why do you want to do so?
I don’t see any issues in leaving the table as it doesn’t occupy any space. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.