How do I go abouts purging the data cache for a particular database? Is there a stored procedure that can be executed??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 :-)
SVTsql
No comments:
Post a Comment