Viewing 13 posts - 1 through 13 (of 13 total)
apat (3/12/2009)
chicagonj,did you try killing this spids and dropping the objects? did it work?
Sorry for the late response. YES, that did work. One of those locks had everything...
March 12, 2009 at 3:30 pm
Ok...looking under Management, Current Activity, Locks/Process ID
Out of the hundreds of entries, there are entries labeled as 'Blocked By XX' When i click on those, I'm getting 3 entries....
March 12, 2009 at 12:04 pm
Wow...that's looks why beyond my minimal SQL expertise. What would that do for me?
March 12, 2009 at 11:44 am
The Alter View has been running for 35 minutes so far....
March 12, 2009 at 10:55 am
ALZDBA (3/12/2009)
Keep in mind you cannot drop objects that are actually in use !
How can I confirm this?
March 12, 2009 at 9:31 am
apat (3/12/2009)
You have to drop view first...
March 12, 2009 at 9:30 am
When I right click on the view, select delete, then click on Drop All, the screen just freezes and will just sit there. I have to kill it in...
March 12, 2009 at 9:20 am
Having the same problem with the view.
:angry:
There has got to be a way.....
March 12, 2009 at 8:59 am
Question: I have a view that is linked to the two files I cannot drop. But I cannot drop that view either. Would I need to drop...
March 12, 2009 at 8:06 am
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Where else could I check?
March 12, 2009 at 7:47 am
I tried these and nothing is happening. It's almost like there is some sort of corruption.
Are there any other options for deleting these?
March 11, 2009 at 2:53 pm
Also, what is the syntax for the truncate command?
March 11, 2009 at 2:37 pm
At this point, I'd do either. We can't ever run a select count (*) statement against these tables.
How would I issue the drop statement? Through query...
March 11, 2009 at 2:36 pm
Viewing 13 posts - 1 through 13 (of 13 total)