an active procedure may not rollback its own CREATE statement

  Explanation:  A  stored  procedure  attempted  to  ROLLBACK  the
  transaction  in  which  the  procedure was created.  This is not
  permitted.

  User  Action:   Before  executing  the  procedure   COMMIT   the
  transaction  in  which  the  procedure was created.  Or, execute
  ROLLBACK in the context of a committed object.