• After detaching and attaching the database when i run query nothing returns. So it is solved.

    But while running dbcc opentran i am getting output like following.

    Transaction information for database 'Reg_test'.

    Replicated Transaction Information:

    Oldest distributed LSN : (0:0:0)

    Oldest non-distributed LSN : (103448:85:1)

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

    Also if i take the ldf backup and then try to shrink then ldf is not shrinking.I think it is due to the open transaction related to replication.

    So how it can be solved?What does above message means?It's urgent plz help.