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.sqlmonster.comI'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 SQLMonster.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.