Redirect to :

https://www.databasejournal.com/features/mssql/article.php/10894_2203601_2/Identifying-Stored-Procedure-Recompilation-Problems-in-SQL-Server-2000.htm

Continue to visit