MSDE

• sackerdj

  SSC Eights!

  Points: 815

  More actions

  June 25, 2003 at 7:36 am

  #59150

  I have a DB which I need to migrate from MSDE to SQL Server 2000. An application access data on the source DB via a SQL Server login. I did a detach DB, but this did not move the login information. Is there a way I can include the login information from the source engine so when I attach the DB to the SQL Server, the login information stays intact.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  June 25, 2003 at 7:50 am

  #463017

  Use DTS from SQL Server 2000 Enterprise Manager to move the logins.

• tyang

  SSCrazy

  Points: 2231

  More actions

  June 25, 2003 at 8:25 am

  #463024

  Create the login stored procedure and produce it on the source server, generate the result script on the target server. Check this link.

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