Options
Invalid Object Name Error Message
Brian Donahue
Posts: 6,590 Bronze 1
Hi,
Thanks for writing. It sounds like the view was scripted out-of-order as
far as the dependencies go. If you've got version 3.0 of SQL Compare, I'd
suggest getting the new 3.1 version, as it's got a fix for that. If you've
already got 3.1, then you may try exececuting an sp_refreshview against that
view in Query Analyzer. This should update sysdepends (hopefully!) is it's
not synchronized properly.
Yours,
Brian Donahue
Red Gate Technical Support
"PBMH" <webmail@people-friendly.com> wrote in message
news:lgvBLLC7DHA.1208@server53...
> I am getting an error message "Invalid Object Name vw_Foo" where vw_foo is
> in my test data but not present in my production data. It causes the
> synchronisation to roll back and I ended up creating that view manually.
>
> Any ideas why this might have happened?
>
> PBMH
>
>
Thanks for writing. It sounds like the view was scripted out-of-order as
far as the dependencies go. If you've got version 3.0 of SQL Compare, I'd
suggest getting the new 3.1 version, as it's got a fix for that. If you've
already got 3.1, then you may try exececuting an sp_refreshview against that
view in Query Analyzer. This should update sysdepends (hopefully!) is it's
not synchronized properly.
Yours,
Brian Donahue
Red Gate Technical Support
"PBMH" <webmail@people-friendly.com> wrote in message
news:lgvBLLC7DHA.1208@server53...
> I am getting an error message "Invalid Object Name vw_Foo" where vw_foo is
> in my test data but not present in my production data. It causes the
> synchronisation to roll back and I ended up creating that view manually.
>
> Any ideas why this might have happened?
>
> PBMH
>
>
This discussion has been closed.
