Here is the code:

...

This would easier to troubleshoot if we could see a code snippet. It sounds like you are utilizing the using correctly, as well as Close and Dispose, but are you using Flush as well?

If you are writing a file and then trying to access it again, you may try a second using block and see what happens, but likely the issue will happen again.

Good luck!

The best advice I can give is download the SSMS tools found here,
www.ssmstoolspack.com

Once installed, you should be able to right click on a specific table and then see options for SSMS tools. Hover over the SSMS tools and there will be an option to Generate Insert Statements. If both of your tables already have the data you need in DB1, and the table structures have already been created in the new database DB2, then this...

Hello Arulmanoj,

When we decided to use our DB for storing emails and attachments, we simply created a few tables for each purpose. One table exists for metadata such as email status, date received, customerID, etc. We then used the ID from this table to associate to the other necessary tables such as EmailMessage, EmailAddresses, EmailTemplate, and EmailFile. You may be thinking that this level of normalization is overkill but believe...