anthony.green (1/30/2013)
Did you investigate what the SPIDs where doing which blocked you?
THe were some internal processes spid < 50
anthony.green (1/30/2013)
Did you try setting the DB into single_user mode?
YEs i tried that too but again that got blocked
but i was not sure why everything got blocked by internal processes.
Should i have been waited for sometime ? (for commmand which i executed to change the db to single user mode) ?
can a alter database statement take around 15 minutes to execute ? (though i stopped it after 15 minutes)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)