Yes, all memory related counters are zero :

"Time", "Available KBytes", "Connection Memory (KB)", "Granted Workspace Memory (KB)", "Optimizer Memory (KB)", "Target Server Memory (KB)", "Total Server Memory (KB)"

"07/04/2008 13:37:20.605","9043136","0","0","0","0","0"

"07/04/2008 13:37:35.605","9045300","0","0","0","0","0"

"07/04/2008...

Yes, it worked.

Thanks

Exactly.

In fact, its Total & Target Server Memory are far below its Physical Memory, and high in Paging File(Total) % Usage : around 28 %, high PhysicalDisk (Total) % Disk...

We use default value :

min. 0 MB, max : 2147483647 MB

Thanks

Thanks for your reply, but could you give examples of what you said : SHA1 hash of the unencrypted value ? What is that ?

But is my SQL statement a proper way to select an encrypted record :

SELECT AccountID, CandidateID from dbo.Candidate

WHERE CONVERT(VARCHAR, DecryptByKey(eEmail)) = 'bacteric21@yahoo.com.sg'

Although I could select a record successfully, are...

"Dont think you can do this. Each time you encrypt the same value you will get different encrypted values."

Yes, in fact, I found this fact just after I sent this...

Thanks,

but are there any Web sites or documents which tell me how to append the encrypted data chunk together ?

Thanks.

I fixed the problem by myself.

In fact, what I did was what you suggested.

Thanks a lot.

Thanks for your replies.

I will try it.

Thanks.

After reading this article, I know the cause of my problem and fixed it :

http://www.sqlservercentral.com/Forums/Topic252605-23-1.aspx

The reason is my "emppassword" column is not long enough to store the encrypted data.

After reading this article, I know the cause of my problem and fixed it :

http://www.sqlservercentral.com/Forums/Topic252605-23-1.aspx

The reason is my "emppassword" column is not long enough to store the encrypted data.

So does it mean what I guessed is correct :

Shared Data Source is not allowed in Report Subscription ?

Thanks