I'm not sure why this fixing the issue and it makes no sense to me whatsoever but i set the default database back to master.
I added a USE MyDB before the stored procedure and it works now.
Use MyDB Go Exec MyProc