October 10, 2013 at 5:54 pm
I have a view that I cannot make changes to.
I just open the view in a query window make a change and then say run and it never comes back.
I can make other views and make changes to other views - but for some reason I can't do it for this view.
Anything that would cause it not to work.
I can't just open it and run it without making changes.
I can select using the view fine. Comes back right away.
Thanks,
Tom
October 10, 2013 at 6:05 pm
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
October 13, 2013 at 7:22 am
If you hit the issue again, I'd look for blocked processes. It's likely that you had one that was preventing your from completing what you were doing. You could have identified it pretty quickly. To look for those use sys.dm_exec_requests.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 13, 2013 at 10:16 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply