Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: Purging Data Cache

    How do I go abouts purging the data cache for a particular database? Is there a stored procedure that can be executed????

  2. #2
    Join Date
    Jun 2003
    Try the :

    DBCC DROPCLEANBUFFERS -- for clear out the buffer cache
    DBCC FREEPROCCACHE -- to clear out the procedure cache.

    Worse, just shutdown & restart the server - I have to post a waiver for this :-)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts