problem in tab [dbo].[Tab_RefTactics]

[M@hmoud]

may tab [dbo].[Tab_RefTactics] no have dwObjID how add it in tab



i need fix it cant use db cleen Tab_RefTactics auto ID will different id and if i use will lost more data i add npc and unique and more i need fix it

[OKeks]

Use a "clean" db backup and restore it from there.

[M@hmoud]

Originally Posted by OKeks

Use a "clean" db backup and restore it from there.

i need fix it cant use db cleen if i use will lost more data i add npc and unique and more i need fix it

[OKeks]

You have to enter data into the column too, so I guess it will be easier to restore the table from a clean database. If you are afraid about your own database, install another instance of sql server and load it to the 2nd instance...

[M@hmoud]

Originally Posted by OKeks

You have to enter data into the column too, so I guess it will be easier to restore the table from a clean database. If you are afraid about your own database, install another instance of sql server and load it to the 2nd instance...

bro Tab_RefTactics auto ID will different id and will lost all data

[*Deadly]

its already not working i suppose, cause missing a column will lead gs to crash/don't load, so best option is deleting the table, adding it again or restore it from an old backup (if you made any).

[Revens Online]

If you've a problem in the whole table. I recommended you to drop the current one and restore it from another clean DB

USE SRO_VT_SHARD
DROP TABLE Tab_RefTactics

SELECT * INTO SRO_VT_SHARD..Tab_RefTactics from CLEAN_VT_SHARD..Tab_RefTactics

[M@hmoud]

thx all i fix it from design

Originally Posted by *Deadly

its already not working i suppose, cause missing a column will lead gs to crash/don't load, so best option is deleting the table, adding it again or restore it from an old backup (if you made any).

thx

Originally Posted by Revens Online

If you've a problem in the whole table. I recommended you to drop the current one and restore it from another clean DB

USE SRO_VT_SHARD
DROP TABLE Tab_RefTactics

SELECT * INTO SRO_VT_SHARD..Tab_RefTactics from CLEAN_VT_SHARD..Tab_RefTactics

thx

[irockalone]

Originally Posted by M@hmoud

may tab [dbo].[Tab_RefTactics] no have dwObjID how add it in tab



i need fix it cant use db cleen Tab_RefTactics auto ID will different id and if i use will lost more data i add npc and unique and more i need fix it

Right click on the table ->Design->Rename that collumn to whatever you want.