If you are using OSQL or ISQL from DOS querys are really hard to use, because the result is to big for the screen. With this procedure, you can especify from wich column to wich column show the list of tables. For Example: proc_tables master, 3, 10 will show you only a short list of tables order by name.
Soon more scripts like this but for Stored Procedures, backup_devices, columns, triggers, views, etc... I Use then on MSDE