March 9, 2005 at 12:27 am
Hi all,
how can i export users and import them in another sql server?
thanks in advance.
March 9, 2005 at 12:43 am
Do you mean database users or sql server logins?
March 9, 2005 at 1:57 am
Hi,
You can do it. copy the syslogin table to any one table. Use cursors to call sp_addlogin. For converting passwords if it is SQL server login there is a stored proc called sp_hexadecimal(search in web someone has it),use that
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
March 10, 2005 at 9:10 am
Here's the link that you'll need:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply