Changes to system procedures in proxy databases

System procedures always perform their tasks locally. That is, if you issue system procedure in a proxy database, any changes it makes do not appear in the primary database, and vice-versa.

System procedures begin with either the sp_ or xp_ prefix.