Question
What Stored procedures are run when attaching a Nintex Config Database?
Answer
When the Nintex config Database is attached via the Central Administration>Nintex Administration, there are embedded scripts, which are executed to upgrade the database to the version of Nintex currently installed.
The name of the stored procedure is "UpdateConfigWebAppIdForUpgrade" which relies on additional information passed to it when the DB is attached via Central Administration.
If the Database is attached in an alternative way, i.e changing the connection string for it, in the Sharepoint object.
The stored procedure nor the embedded scripts would run, and it's therefore recommended to only attach the Nintex Config DB via Central Admin.
