• 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