Thanks (Grant Fritchey,Jayanth_Kurup)

Its clear that it cant be done using any query or using SSMS rite !

Thanks for that information, Would i asked you just a small help in this...

Dear Koen Verbeeck

Can you say me this

we are already have 2005 on server will sql server 2008 get install on it or i need to uninstall 2005 before installing 2008.

Thanks patel

Looking forward for more information

dear opc.three

> What are you trying to protect against by encrypting your data?

I am trying to protect this data from the developers as well as from the end users

> Who...

Dear Adi

Thanks very much for the script and for idea about the numaric values...

But here the problem is table is already created and is in Live so cant really change...

Dear Adi

Yes i need to encrypt whole as a table bec i am maintaning all secure data into one table and i want to encrypt whole as a table,and this...

Really very much thanks.:-)

Thanks very much Lowell

This is what i am looking for.:-P

Just one final question can i have different collate type or should always go with Latin1_General1_BIN