Home Forums SQL Server 7,2000 Administration Procedure returns to syscacheobjects without recompile - mystery RE: Procedure returns to syscacheobjects without recompile - mystery

  • Thanks wolfkillj that was a good suggestion which would have helped track the problem down. As it is the penny dropped about 40 minutes ago when we found a job that was running every minute and was calling DBCC FREEPROCCACHE.

    Amazing, mystery solved and now the proc cache is growing normally again.