Rebuild dependancy Information

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?(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?|||"Trev@.Work" <no.email@.please> wrote in message
news:4027c1b2$0$28848$afc38c87@.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|||Simon Hayes wrote:

> "Trev@.Work" <no.email@.please> wrote in message
> news:4027c1b2$0$28848$afc38c87@.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.

The view exists, definately.

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.

From EM, export data... Copy objects and data between SQL Server databases.

> Also, if you always copy the entire database, you might want to consider
> backup/restore instead of DTS.

That's what I have to resort to usually. I would like to achieve the
same result with one step if possible.|||"Trev@.Work" <no.email@.please> wrote in message
news:4028d626$0$29822$afc38c87@.news.easynet.co.uk. ..
> Simon Hayes wrote:
> > "Trev@.Work" <no.email@.please> wrote in message
> > news:4027c1b2$0$28848$afc38c87@.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.
> The view exists, definately.
> 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.
> From EM, export data... Copy objects and data between SQL Server
databases.
> > Also, if you always copy the entire database, you might want to consider
> > backup/restore instead of DTS.
> That's what I have to resort to usually. I would like to achieve the
> same result with one step if possible.

Have you applied the latest servicepack? There are a number of KB articles
which may describe this:

http://support.microsoft.com/defaul...kb;en-us;291780
http://support.microsoft.com/defaul...kb;en-us;281664
http://support.microsoft.com/defaul...kb;en-us;300272

Simon