You can fix your problem with SP like that.

Just point your SP to the right database placing this code at the beginning of code in your SP:

USE YourDB_name

GO

Don't forget to replace the YourDB_name with a real one.:)