Home Forums SQL Server 2008 SQL Server 2008 - General Why does TRUNCATE TABLE hang? RE: Why does TRUNCATE TABLE hang?

  • October 25, 2012 at 1:40 am

    #1552537

    peterdru401 (10/24/2012)

    check which query is lock the object u r trying to truncate by following.

    Select blocking_session, sid, serial#, wait_class,seconds_in_wait From v$session where blocking_session is not NULL order by seconds_in_wait

    Is v$session some custom view that you have? It's not a standard SQL Server object.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass