there's only 2 solutions for that problem
to create a NEW Database name and restore the old db u had,
and copy these tabales > refshopgoods - refpackageitems - refScrapitems -
to the database you have problem in'
query to do that
Quote:
USE SRO_VT_SHARD
GO
TRUNCATE TABLE [dbo].[_RefObjItem]
GO
insert into SRO_VT_SHARD.dbo._RefObjItem select * from SRO_VT_SHARD1.dbo._RefObjItem
|
ChangeRefObjItems to your tabale , change SRO_VT_SHARD To ur name and the from , is means the database u will take the lines from , insert means the database you put into'