Thanks for your enthusiasm to see this problem solved. I have consulted a colleague who will assist in the next twenty minutes time. I will give you the feedback once...

This is the error I am getting in STATA:

. odbc query "ADJusT"

The ODBC driver reported the following diagnostics

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.

SQLSTATE=28000

r(682);

Thanks David. I have identified the field which was bringing this error and I have resolved.

Possibly I might be a novice. However, how should I take the backup? I want my server to backup the data to the other remote server automatically say on daily...

Many thaks Jason for your help. I have managed to delete the duplicates in my tables

Many thanks for your response. Let me do it and see if it works

Many thanks

Many thanks, I have done that and its working