June 25, 2003 at 7:36 am
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.
June 25, 2003 at 7:50 am
Use DTS from SQL Server 2000 Enterprise Manager to move the logins.
June 25, 2003 at 8:25 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply