SQL Server Performance Forum – Threads Archive

delete system table

One 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. —
Frank Kalis
SQL Server MVP
http://www.insidesql.de

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>