CREATE VOLATILE TABLE error

[GerardMcL]

Hi,

I am running a REPLACE PROCEDURE.
In the procedure I create a number of VOLATILE TABLES. The syntax looks correct to me but I get an error saying

"User is not authorized to use the DDL/DCL/Dynamic SQL statement"

Logged in as Admin too.
Cant for the life of me figure this out, anyone got any clues?

 

[fpluebell]

The Creator of the SP must be the immediate Owner if you want to use any of these features.

In other words if you are logged on as SomeUser then you can create SomeUser.MySP with this code, but not SomeOtherDB.MySP.