How to Create a system Type Table/ change User table to System Table.

Is there any Posibility to change a User Table to System Table.

How to create one system table.

I am in Big mess that One of the Table I am using is in System Type.

I cant Index the same. Is there any Mistake we can change a user table to system table.....

You can do it, but I am not sure it is that great of an idea to do. You have to allow system updates on your server, and update some system tables to allow this (SQL 2000). What problem are you facing?|||

I am not trying to create a system table.

Unfortunately my user table is in System type.

Having Enough data in that.

so I want to bring back to the User Table type.

|||are you using sql 2000?|||

ya I am using sql 2000. Is there any possibility of this happening?

How to Revert Back?

|||

Yes, you can revert the object back from being a system table. You have to manually edit the sysobjects table, and remove the system object bit from the status column.

Here is a thread in which I show how to update the sysobjects table.

http://www.tek-tips.com/viewthread.cfm?qid=1267568&page=1

This should not be done by someone who isn't comfertable making changes to the system tables manually. If this isn't done correctly you could loose the table or database. Be sure to backup the database before making this change so that you can restore if it doesn't go well.

It is recommended that you never mark user created procedures as system procedures as this fix doesn't work in SQL Server 2005 and up.

|||

Thanks For ur Information.....

can u tell me any possibility of this happen a guess? because I cant Figure it out......

|||Someone had to manually set the table to be a system table, either by editing the sysobjects table directly, or by using the procedure which Microsoft provides which makes this change.