Post reply

dbcc freeproccache for Single stored procedure

  • October 26, 2017 at 6:24 am

    #357985

    Hi Team,

    please provide the query to clear the cache of single stored procedure.

    THanks
    Bhanu

  • October 26, 2017 at 6:56 am

    #1965291

    What have you tried so far?

    You will need to check the cached plans for the particular procedure and then feed the plan_handle into cached query plans filter it based on the right dbid and objected then get the correct plan_handle and pass it into  DBCC FREEPROCCACHE

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply