Freeing Procache will cause query performance to go down in the beginning, Isn't it..

Thanks Muhammad..it worked!!

Adi..we have a group who monitors some of the servers located at different locations and they use an application which needs to view this table.

Thanks a lot for the reply..

FYI: its actually sql 2005 express edition

go to the db where these sp's are, click storedproc -> right click->view dependencies..