When using Central Management Server (CMS), under Central Management Server Actions, SQL Server Configuration Manager (SSCM) is an option.
When launched, the GUI reflects the information of the CMS. Apart from what the GUI shows, I'm hopeful that changes made will affect all CMS managed instance...
I have the following situation:
I have a SQL 2008 R2 Enterprise edition where I have enabled TDE encryption in one of the databases. One of the stored procedures from the encrypted database is using a table variable (@t1), table that gets populated with almost 600K records. Then there is a select...