What are the challenges you face when working across database platforms? Take the survey

Invalid Object Name Error Message

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited February 6, 2004 10:58AM in SQL Compare Previous Versions

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.


Brian Donahue
Red Gate Technical Support

"PBMH" <webmail@people-friendly.com> wrote in message
> 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?
This discussion has been closed.