Hi All,
i hv to encrypt whole database with asymmetric key.
Now i m hv got a link where i cn encrypt string

CREATE CERTIFICATE ElmerEncryptionCertificate
    WITH
       SUBJECT = 'Elmer Certificate',
       EXPIRY_DATE = '01/01/2008 '



CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'pady'


EncryptByCert ( Cert_ID('ElmerEncryptionCertificate'), 'FINOENROLLMENT.MDF' )


CREATE ASYMMETRIC KEY Asym_Looney_Tunes
WITH ALGORITHM = RSA_512

DECLARE @encryptedstuff NVARCHAR(1000)
SELECT @encryptedstuff = EncryptByAsymKey(AsymKey_ID('Asym_Looney_Tunes'),' ')
SELECT @encryptedstuff
SELECT CAST(DecryptByAsymKey(AsymKey_ID('Asym_Looney_Tune s'), @encryptedstuff) AS NVARCHAR)

Bt nw i m nt able to encrypt whole Databse.
cn u help me plzz.....