The Transact-SQL® global variable @@ssl_ciphersuite has been added to allow users to know which cipher suite was chosen by the SSL handshake and 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)
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
