abendigeri (10/25/2013)
@Welsh,Thanks,
I agree, but thats the environment:-)
There are no open transactions...But when i run DBCC opentran its says, one open transaction is there and the SPID is 66s !
I have never seen such SPID...Drive is full now..
If your disk is full you are not going anywhere.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/