Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to alter view Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 5:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 11:46 AM
Points: 147, Visits: 361
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
Post #1503833
Posted Thursday, October 10, 2013 6:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 11:46 AM
Points: 147, Visits: 361
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
Post #1503835
Posted Sunday, October 13, 2013 7:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:01 AM
Points: 14,208, Visits: 28,538
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1504262
Posted Sunday, October 13, 2013 10:16 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 35,846, Visits: 32,517
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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1504275
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse