Home Forums SQL Server 2005 SQL Server 2005 General Discussion Spid of -3 holding permanent lock on database and tempdb does not have any tables after restart RE: Spid of -3 holding permanent lock on database and tempdb does not have any tables after restart

  • The deferred transaction eventually resolved itself, also. Thanks ChrisM.