January 14, 2009 at 2:29 pm
Can you please provide me the sql script for copying the security logins from sql server 2000 to sql server 2005 servers.
Thanks!
January 14, 2009 at 2:44 pm
Check this out:
http://www.sqlservercentral.com/Forums/Topic636438-357-1.aspx
-- You can't be late until you show up.
January 14, 2009 at 2:50 pm
tosscrosby (1/14/2009)
Check this out:http://www.sqlservercentral.com/Forums/Topic636438-357-1.aspx
Can I follow the same article if I want to copy the logins from sql 2000 to sql 2008 server. Thanks!!
January 15, 2009 at 8:59 am
tosscrosby (1/14/2009)
Check this out:http://www.sqlservercentral.com/Forums/Topic636438-357-1.aspx
Thanks for your reply, I am going thru the script, actually I want to transfer the logins from sql 2000 to sql 2008, can I use the same scripts for doing that? Thanks!
January 15, 2009 at 9:35 am
Mh,
The script will work for copying logins to SQL 2008 because logins are essentially unchanged between 2005 and 2008.
Greg
January 15, 2009 at 10:05 am
Greg Charles (1/15/2009)
Mh,The script will work for copying logins to SQL 2008 because logins are essentially unchanged between 2005 and 2008.
Thanks!! It worked. 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply