clearing cache?

[Guest_imported]

Could someone please tell me how to clear out SQL Servers data and pocedure cache?
I have tried the following however it has'nt worked:
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

 

[tlbroadbent]

DBCC FREEPROCCACHE should clear procedure cache if you have system admin rights.

There is no command to clear data cache. You could run a query that returned enough rows to fill cache so all the current data would flush. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost