SELECT * FROM sys.procedures ORDER BY [name]
EXEC sp_tables @TABLE_TYPE="'TABLE'" SELECT name, user_name(uid), * FROM sysobjects WHERE type='U'