Jeffrey Williams (8/5/2008)

---

You would do this:

Execute sp_MS_marksystemobject sp_mytest;

And that should setup the procedure so it runs in the context of the database where it is executed.