Saving a view with a table in a linked database

I created a view with a join between a table in the master-database & a table
in a linked database. When I run this view, there is no problem at all. When
I try to save this view. The system is hanging. When I stop the process and
look in the current activities there is a locking process caused by the fact
that I'm creating that view.
Does anybody know what can be the cause of this problem and how to solve it?
Thanks in advance.
Message posted via http://www.droptable.com
I'm not sure what you mean by running a view and then trying
to save it. If you are trying to create or alter a view
using a GUI tool, Try executing a CREATE VIEW statement
instead.
-Sue
On Wed, 30 May 2007 13:18:41 GMT, "amac via droptable.com"
<u19445@.uwe> wrote:

>I created a view with a join between a table in the master-database & a table
>in a linked database. When I run this view, there is no problem at all. When
>I try to save this view. The system is hanging. When I stop the process and
>look in the current activities there is a locking process caused by the fact
>that I'm creating that view.
>Does anybody know what can be the cause of this problem and how to solve it?
>Thanks in advance.