How can I do to copy database on SQL server7.0 that
create at home to do next at office? I Used
Import/Export ,but it did not work.

Hi

Apart from backup/restore you could also use sp_detach/sp_attach. Burn a CD
with the files on and then take it home! Make sure that you remove the read
only attribute for any file you copy from the CD to your HDD!

http://support.microsoft.com/default...n-us;Q314546#2

For orphaned users check out:
http://support.microsoft.com/default...n-us;Q314546#4

Make sure that both systems are at the same service pack/patch levels.

John
"Nuttiwan" <Nuttiwan (AT) thaimail (DOT) com> wrote