Open transaction related to IFTSAutoNested

• farax_x

  Hall of Fame

  Points: 3579

  More actions

  December 25, 2016 at 6:34 am

  #324686

  Hi all,

  I always see this result while getting DBCC OPENTRAN:

  Oldest active transaction:

  SPID (server process ID): 25s

  UID (user ID) : -1

  Name : IFTSAutoNested

  LSN : (3338107:2497:1)

  Start time : Dec 25 2016 4:36:04:723PM

  SID : 0x01

  whats that ? and how can I solve it ?

  I have full text index on a table and its population is manual

• Abdallah.mehdoini

  SSC Veteran

  Points: 221

  More actions

  December 25, 2016 at 1:06 pm

  #1919613

  select name, log_reuse_wait_desc from sys.databases

  kill SPID

• December 28, 2016 at 10:39 pm

  This was removed by the editor as SPAM