From: esquel@sommarskog.se   
      
   m (miroslavsi@gmail.com) writes:   
   > After running dbcc opentran we got:   
   >   
   > Replicated Transaction Information:   
   >   
   > Oldest distributed LSN : (0:0:0)   
   >   
   > Oldest non-distributed LSN : (11585:3549:1)   
   >   
   > Is there anything concerning?   
      
   It seems indeed that you have an open transaction in the database.   
   I'm a little confused though, as the output does not look to what   
   I'm used to. Here is what I get on SQL 2008 (but it has looked this   
   way as long as I can recall):   
      
   Transaction information for database 'tempdb'.   
      
   Oldest active transaction:   
       SPID (server process ID): 51   
       UID (user ID) : -1   
       Name          : user_transaction   
       LSN           : (58:107:9)   
       Start time    : Sep 24 2009 11:16:02:943PM   
       SID           :   
   0x0105000000000005150000000a7860013c350d7e339487b6e8030000   
   DBCC execution completed. If DBCC printed error messages, contact your   
   system administrator.   
      
   If you are not able to identify the process with the open transactio,   
   you can issue these commands:   
      
      ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE   
      ALTER DATABASE db SET MULTI_USER   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)