Hi Luke,

Thanks a lot for your response.

But the MSDN status that The password takes effect immediately, without restarting SQL Server.. in http://msdn.microsoft.com/en-us/library/ms365941(SQL.90).aspx. There is my confusion.

Hi Bala,

I didn't think you can use any of the Native SQL server 2005 encryption to achieve this task. You should go for some 3rd party tools which handle...