So many times I do not remember the name of table or stored procedure I have created, and it becomes time consuming to search object by firing query on sysobjects or search using Enterprise Manager.
It is a simple Stored Prodeure where the Parameter is the Hint of the Object name and Object Type.
It will fetch all the Objects and its description from sysobjects.
Both parameters are optional, so search can be made on the required criteria.
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.