unable to alter,drop,rename or select from a view

• Linda-272642

  Ten Centuries

  Points: 1100

  More actions

  November 12, 2008 at 12:01 pm

  #215165

  We recently upgraded one of our sql servers to 2005. the view is on a sql server 2000 box which queries the 2005 box

  the script for the view is

  select *

  FROM server.database.dbo.table

  I recreated the view with a different name and it worked just fine.

  So I tried to rename it and it just keeps running and running

  Same for alter and drop.

  I think its corrupted but I need a view to have the same name because we have many procs referencing that view.

  Any suggestions?:w00t:

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734564

  More actions

  November 12, 2008 at 12:44 pm

  #897728

  Someone likely has a schema lock on it somewhere. Check sp_lock