Thank Atif,I am using SQL2000 and somehow it is working fine now with script and through EM as well.

Atif if you dont mind do you know any article or place where i can find step-by-step setup of data encryption in SQL Server 2005 (Asymetric key/Symetric key) please?