sql dts database duplicate fails
hey all, i have operative problem while common google searches aiding :(
i have prolongation database sql 2000. i wish duplicate over tip training database modernise it. i wish something scheduled occur once week keep training database up-to-date.
i have dts office combined doing this. within dts office i have unparalleled "copy sql server objects" task. assign set adult to:
- create copied objects
- drop finish objects first
- copy data
- replace existent data
- copy indexes, triggers, primary unfamiliar keys
- copy user tables, views, functions stored procedures.
when i run dts package (in pre-production contrast course) gets 99% finished throws following error:
step blunder source: microsoft sql-dmo (odbc sqlstate: 42s02)
step blunder description:[microsoft][odbc sql server driver][sql server]invalid vigilant name 'dbo.vwestassetstationaddress'.
step blunder code: 800400d0
step blunder assistance file:sqldmo80.hlp
step blunder assistance context id:1131
my searches net didn't yield many help. there reports errors removing hit, nonetheless zero seem review circumstances. idea i found the sysdepends list spin corrupted, origination dts office run the scripts wrong order. howeever, i ran following book repremand list still throws same error:
use master
go
alter database [database name]
set single_user
go
use [database name]
go
dbcc checktable('sysdepends',repair_rebuild )
go
use master
go
alter database [database name]
set multi_user
go
i have also seen carrying opposite vigilant owners means error. nonetheless i have reliable objects owned dbo user case.
any suggestions?
Comments
Post a Comment