InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:27:00 GMT20http://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxwe've big script you execute that in primary server that creates two stored procedures in master database 1.sp_hexadecimal 2.sp_revloginif you execute first one it give one more script for us you execute that one (result script)in secondary then you can transfer dbs.in the same way if you execute sp_revlogin you can transfer logins also.Wed, 24 Aug 2011 06:01:55 GMTvijju.gaddam488http://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxSince I found this thread on this topic, it should be noted that MS has two KB's regarding moving login accounts between SQL servers.One KB is for moving logins between SQL7 to SQL2k or SQL2k to SQL2khttp://support.microsoft.com/kb/246133/The other is for moving logins between SQL 2k5/8 to 2k5/8http://support.microsoft.com/kb/918992/The reason for the differences is because they changed some of there sysobject schema.Cheers.BillFri, 27 Aug 2010 11:07:11 GMTBill Prehlhttp://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxWe have done the same that sugesh suggested.Wed, 14 Nov 2007 02:50:14 GMTMinazhttp://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxDatabases can be moved using the detach and attach method. For logins there is a script in MICROSOFT site that will script your logins with password. you can use that.Tue, 13 Nov 2007 23:15:38 GMTSugesh Kumarhttp://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxHi There,from the source server bcp out..syslogins and copy to the target server using bcp in command.Hope it will resolve your login issue.CheersMenakaTue, 13 Nov 2007 09:27:00 GMTMenaka-441717http://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxHi, Check also the following http://blogs.techrepublic.com.com/howdoi/?p=140Regards,AhmedTue, 13 Nov 2007 08:57:16 GMTSQL_ABDhttp://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxRefer to KB 246133 (http://support.microsoft.com/kb/246133/)Tue, 13 Nov 2007 07:57:07 GMTTommy Bollhoferhttp://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxLogins are stored in the master database, thus you can move your database but the logins wont be moved over. the DB usernames will be though. Using these you can relink the usernames and create logins. Use inbuilt stored procedure - I can't remember the name of it. Books online should give you these.Tue, 13 Nov 2007 07:33:46 GMTmartin-210793http://www.sqlservercentral.com/Forums/Topic421527-146-1.aspxhi, how to move databases from old server 2005 to new server 2005 and also logins.if we moved databases and logins from old server.will it contain database ,logins or not?Tue, 13 Nov 2007 06:07:17 GMTsrimkumarp