Type of table generated is system
-
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.
-
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.
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