I intend to export an entire SQL Server DB from one Server to another. I am not sure abt the best way to do the same, but I tried diong it using a DTS package. However the package failed to complete with the following error msg
"The login 'anderson' does not exist"
Can anyone help me out in identifying the prob & also ways to have it solved.
Thanx in anticipation,