Creating a view with a table to a linked database

• Ann-176222

  SSC Enthusiast

  Points: 184

  More actions

  May 30, 2007 at 7:57 am

  #172525

  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.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 31, 2007 at 8:07 am

  #710003

  Please do not cross post, most people will look at the active items regardless of where you post. See comments in

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=369898