In situations where SQL Server database servers are being migrated to new instances and the source instance is running Enteprise Edition, the question often arises: do we need to use Enterprise edition? Standard Edition is cheaper! While this isn't a question which can be answered by functionality alone, (i.e.
If you need to find out if a SQL Server instance has ForceEncryption turned on at a server level the only reasonable way to do this is read it through the registry. You must look for: