May 14, 2004 at 12:56 pm
Hello,
I am in the process of moving our main SQL Server 2000 user database (called Central_Data) from one machine to another. The SQL Server instance I am moving from is called 'SQL_Server', and the new instance (and new box) I am moving to is called 'SDO_SQL'.
I have already created the new Central_Data database on SDO_SQL and have filled it with content from the existing full database backup. I have also restored the backup of MSDB from SQL_Server to SDO_SQL.
So I have all of my Jobs and DTS packages on SDO_SQL, but I don't have my Logins. How can I 'copy' my logins over from SQL_Server to SDO_SQL? Is there a way to do this through DTS?
Thanks for your help!
CSDunn
May 14, 2004 at 1:44 pm
Check this article, and copy,create and execute the sp.
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql
May 14, 2004 at 2:06 pm
Thank you for your help!
CSDunn
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply