Invalid Object Name Error Message

Brian DonahueBrian Donahue Posts: 6,590 New member
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" <[email protected]> wrote in message
news:[email protected]
> 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.