On the same server, this runs fine against one database, but gives the msg below on the other. What is a possible reason for this? Shouldn't it run on both because the procs are in the master database?
sp_msforeachtable 'execute sp_spaceused @objname = ''?'' '
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_msforeachtable'.