Kevin,

I don't know why you didn't need to before, but stored procedures are only "visible" for the current database (the one desingated with SET DATABASE TO). The exception to this rule involves the tables and views in a database, the events (like valid or default value) of tables can access the stored procedures in their respective database without using the SET DATABASE TO.

Stored procs are not usually used for code that is called from other code, instead they are used for the UDFs that are called from the table and view settings within the database. You can use a procedure file for the procs needed elsewhere.