Post reply

differing open tran results

  • June 27, 2011 at 2:48 pm

    #238501

    this is on sql2005 server and log keeps growing due to an open transaction. The dbcc open tran show nothing but sysprocesses shows it

    DBCC OPENTRAN

    No active open transactions.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    select * from master.dbo.sysprocesses with (nolock) where open_tran<>0

    138000x00000MISCELLANEOUS 2550022011-06-27 15:44:34.9602011-06-27 15:44:34.96001sleeping 0x54C1689A0E1CF344BC944768DF58669400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000NVSOH-WORKPOINT .Net SqlClient Data Provider 8688 AWAITING COMMAND5BDFE814B2E6TCP/IP WebUserTSE 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x01001900D15B260918FEE9720000000000000000000

  • June 27, 2011 at 2:56 pm

    #1344844

    DBCC OPENTRAN is database-specific. Sysprocesses is server-wide. Did you run opentran from the right database?

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply