Can the Redgate database that is install be some where else

NeilSmart

Hi,

Can the database that is installed when you add a server be on a different server to the server you want to monitor?

Thanks

Neil

way0utwest

You are welcome

way0utwest

For DLM Dashboard, there is a DDL trigger that captures changes made in your databases and stores them in this Redgate database. This needs to be on the same instance, as the trigger would otherwise need to do a cross instance insert, essentially a distributed transaction.

May I ask why this is an issue for you?

NeilSmart

Hi,

No issue just wanted to know as may use this for production.

thanks for the quick response