"Trev@Work" <no.email@please> wrote in message
news:40***********************@news.easynet.co.uk. ..
(Reposted question)
Is it possible to rebuild dependancy information for objects in a
database?
I can hardly ever DTS a database across to another server because
something will fail with the message "invalid object name
<name_of_a_view>". This happend to me just now on a database with just
12 tables and 4 views. What hope for my other databases with 100s of
views?
Can you be more specific about what is happening when the error occurs? At
first glance, it doesn't seem like a dependency issue, but rather that the
view doesn't exist. Are you using the DTS Copy Database task? I'm not 100%
sure, but I believe it detaches, copies and attaches the database, so
missing objects should be unlikely.
Also, if you always copy the entire database, you might want to consider
backup/restore instead of DTS.
Simon