Query a SQL Server for all stored procedures

SELECT * FROM sys.procedures;

Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server, Error: 208)

This was a GREAT article. This happened to me and this article had the perfect fix regarding running the u_tables.sql script:

http://blogs.msdn.com/b/suhde/archive/2009/04/05/invalid-object-name-master-dbo-spt-values-microsoft-sql-server-error-208.aspx