tshad (10/10/2013)
I was able to resolve the issue by killing all queries open to the database and shutting down SSMS, when I came back - it worked fine. Before just bringing the SSMS down didn't solve the issue.It was only one view that had the problem. So I don't know why it was locking up.
Thanks,
Tom
If that's true, then you may have a much larger problem... something was keeping the view open in a long winded transaction. You should try this again, find out what is causing the blocking, and fix it.
--Jeff Moden
Change is inevitable... Change for the better is not.