How can I find out which content of a sp in a database in SQL 2000 quickly? I don't want to manually go to right-click properties and look at it. I want a better efficient way. Is it stored in a system table? Please let me know. Thanks.
Have a look at syscomments. However, if your code is longer than 4000 characters there might be multiple rows in there for one object.
Querying to system tables is not an efficient way, the best is to generate script or run SP_HELPTEXT <ProcName> to get contents out of it.