• 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/