Loading Logins

[new_user]

I've a server X with 100 logins. Peridiocally this X server gets new logins created and gets the users password reset. Aside from this, I've a Y server. what I would like to do is, Have all my logins from X server get created on Y server with the same login/password every end of the day.

I've tried BCP. But i dont know, If BCP will work or not. Is there a way to do this?

Please help.

Thanks,

[Franco]

This is the solution provided by Microsoft:

http://support.microsoft.com/default...;EN-US;q246133

[new_user]

Thanks for posting the answer. But the link you posted from microsoft is talking about one time login transfer. I would like to do the transfer's of login from server X to Y every day. Like, incremental login transfer.

Server X has 100 logins and the logins on these server will change password peridiocally. so how i can move that info or any new created logins info.

Apprecaite, If anyone help me here.

Thanks,

[Anu]

Hi,

On server 1 create a temp_login table and insert records from master..syslogins.

(Actually it is a view), pull needed information except
BUILTIN\Administrators
DOMAIN\Administrator
sa, some other logins that you don't need)

sp_configure 'allow updates',1 on server 2

insert into the master syslogins table all these values

sp_configure 'allow updates',0

Run job 1 on server 1 where you drop and populate the tem_login table daily.

Run job on server 2 where set the sp_configure and insert values to the master syslogins table.

I believe this works

Thanks,
Anu