Viewing SQL Server is time consuming, but does the query itself end quickly?

Question

I am trying to modify an existing view in my SQL Server database. When I run the query on its own, it ends in about 4 seconds. When I run the alter statement with the same request, it starts and never ends (I waited 15 minutes before stopping it).

I have no indexes in the view I'm trying to change. Any ideas what could lead to something like this? Is there something I have to do differently to speed things up?

Answer 1

, . - , - , , ALTER.

sp_who2 active ALTER .

Answer 2

, . kill (spid) , ssms , .