· At first ensure that the “nested triggers” option is enabled on the new SQL Server: o Go to “Enterprise Manager”, right click on the new SQL Server and choose “Properties”. o In the “Server settings” tab, the option: “Allow triggers to be fired which
