The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to. which is possible by wrapping all this in a transaction. We need to get key pattern first and the plaintext of object. Since XOR of two. "To ensure transactional consistency, applications need to be quiesced and. SQL Server 2005: Get full information about transaction locks. Sometimes we wish to know what locks are being…