problem in tab [dbo].[Tab_RefTactics]

10/26/2020 17:41 M@hmoud#1
may tab [dbo].[Tab_RefTactics] no have dwObjID how add it in tab

[Only registered and activated users can see links. Click Here To Register...]

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
10/26/2020 21:33 OKeks#2
Use a "clean" db backup and restore it from there.
10/26/2020 21:50 M@hmoud#3
Quote:
Originally Posted by OKeks View Post
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
10/26/2020 22:32 OKeks#4
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...
10/26/2020 22:36 M@hmoud#5
Quote:
Originally Posted by OKeks View Post
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
10/27/2020 04:31 *Deadly#6
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).
10/27/2020 12:19 Revens Online#7
[Only registered and activated users can see links. Click Here To Register...]

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

Code:
USE SRO_VT_SHARD
DROP TABLE Tab_RefTactics
Code:
SELECT * INTO SRO_VT_SHARD..Tab_RefTactics from CLEAN_VT_SHARD..Tab_RefTactics
10/27/2020 21:06 M@hmoud#8
thx all i fix it from design

Quote:
Originally Posted by *Deadly View Post
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

Quote:
Originally Posted by Revens Online View Post
[Only registered and activated users can see links. Click Here To Register...]

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

Code:
USE SRO_VT_SHARD
DROP TABLE Tab_RefTactics
Code:
SELECT * INTO SRO_VT_SHARD..Tab_RefTactics from CLEAN_VT_SHARD..Tab_RefTactics
thx
10/28/2020 09:30 irockalone#9
Quote:
Originally Posted by M@hmoud View Post
may tab [dbo].[Tab_RefTactics] no have dwObjID how add it in tab

[Only registered and activated users can see links. Click Here To Register...]

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.