>In the 2005 management console, it lists all my stored procedures (400+) with the dbo. in front of the stored procedure name. That makes typing the name and moving to it impossible. Is there a way to set it so that it doesn't show the dbo.
and don't forget to always owner qualify SP calls for better speed. IOW
dbo.storedprocedure
http://support.microsoft.com/kb/263889