Thanks guys for all the help. This knowledge base by microsoft helped me transfer the logins.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133

I used the sp_help_revlogin procedure to fix the problem. Thanks alot

Ritch, I guess your intention was to provide a link, right? could you please do that. Thans

Okay guys, I'm back to square one. I did the following:

sp_addlinkedserver 'myserver'

Now when I execute the script written by Rahul Sharma to copy the logins over to the new server,

http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp

I'm...

Thanks Ritch...

Thanks Steve for the links, they are really valuable.

I have a question hope to get it answered. When I'm trying to copy the mdf and ldf files to my DATA...

I stopped the server and started back up again and everything works fine! isn't that weired...

I'm wondering how do you do a search on this site... I mean for previous...