Abhijit,
The problem with using sys.procedures is it ONLY lists out the user created Stored Procedures; this article was in regards to finding ALL procedures (including the MS provided SPs and other programmable objects).
Thank you,
James Rea
~ Without obstacles, you cannot progress ~
http://sqln.blogspot.com/