• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

script for reinitialize MSSQL cache

Hello,

We constat a problem with stored proc executed by donet application, sometimes the result returns is o rows  but if we execute the same stored proc by SSMS, the result returns 33 rows. The only solution we have found it's to restart MSSQL but it isn't a solutions
Where can I found script for reinitialize MSSQL cache?

Thanks

bibi
0
bibi92
Asked:
bibi92
1 Solution
 
RDWaibelCommented:
Yep...

dbcc freeproccache
go
dbcc dropcleanbuffers
go
0
 
bibi92Author Commented:
thanks a lot bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now