I have a module in which agent can send email to user.
in this mudule i am getting data from procedure[sql server2014] and send email from smtp through c# after send email insert into sql server with their agent id.
problem1: If multiple agents are sending emails to multiple users at the same time, then the email of one agent is getting inserted into the other due to which we are not able to track who sent the email.
Problem2: When we are getting data through nvarchar from procedure sometime it is giving wrong result.while procedure is working.
After rebuild table it is working fine.