When run, this procedure outputs the following set of scripts that need to be applied in the current server for synchronising the logins (example):
Create Login [MY_COMPANY_UK\DW_and_Extracts] From Windows; Create Login [MY_COMPANY_UK\AuPairDWETL_TS] From Windows; Exec sp_addsrvrolemember @rolename = 'sysadmin', @loginame = 'NT SERVICE\MSSQLSERVER'; GRANT VIEW ANY DEFINITION To [MY_COMPANY_UK\RGDLMonitoring]; GRANT CONNECT SQL To [MY_COMPANY_UK\DW_and_Extracts]; GRANT CONNECT SQL To [MY_COMPANY_UK\AuPairDWETL_TS]; GRANT CONNECT On ENDPOINT::[SSBEndpoint] To [MY_COMPANY_USA\sqlservice];
I would like to log all these commands to a table before I apply them to my current server, but I understand these are sensitive information, and I would like to be able to encrypt it and be able to decrypt.
What could I achieve this?
I have already seen this:
How could I achieve this, with minimal effort, and not affecting anything else on my systems?