The Transact-SQL global variable @@ssl_ciphersuite enables users to see which cipher suite was chosen by the SSL handshake and to verify that an SSL or a non-SSL connection was established.
For example, an isql connection using SSL protocol displays the cipher suite chosen for it.
1> select @@ssl_ciphersuite 2> go
Output:
------------------------------ TLS_RSA_WITH_AES_128_CBC_SHA (1 row affected)
