Type of table generated is system

[Sushant Duggal]

Hi Friends, I am facing a big problem. whenever i create a table in my SQL Server 2000 database, it is created of the type "System". I am not able to delete that table again. Can anyone tell me the reason for this and how can i get the table type back to "User"

Sushant Duggal.

[Colin Angus Mackay]

Sushant Duggal wrote:

whenever i create a table in my SQL Server 2000 database, it is created of the type "System".

I've never seen that happen before. I wonder if "sys" is a reserved prefix for table names. Of course, you might not be naming your table with "sys...". You didn't actually give much information that could be useful. For example: How are you logged in? How did you create the "system" table? What permissions does your logged in user have?

---

Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog