Changes to System Procedures in Proxy Databases

System procedures always perform their tasks locally. That is if you issue any 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.