Is it possible to create a stored procedure that exists in one database, but
runs in the context of the database from which I call it?

For example, I want my proc (A.dbo.MyProc) to create table Foo in my new
database X, but I don't know that the database is called X when I create
A.dbo.MyProc

Any help would be appreciated.  Thank you!

How to concatenate strings from a column into a single row (with NULL value)?
xp_cmdshell - works with string in one format but not in another -
Query help
Single to Multiple columns
Assistance with SQL Script