Views are exported as tables in the destination database
Posted on 2005-04-28
I have noticed, and other users have noticed, that occasionally a view will not be a view in the destination database, but rather is a table. I believe part of the reason is a broken ownership chain in the source view; however, the users insist there are other times it happens.
Can someone please give me a comprehensive list (as much as possible) of the conditions that cause this behavior.