Copying Rows in Syslogin table

[sanjeevjain]

I need to synchronize the login bet two servers.
For that I need to remove the lfew records and add few records on that.
How could I do that.

thanks

 

[markmar1]

I have to do something similar between a production and reporting server that is refreshed nightly.

A quick and simple way that I am doind is bcping the logins out of production, and load into temp table on reporting. Then using SQL, I join using id and name, and determine what should stay and what should be put in. Like I said, wuick and simple, but you can make as robust as you desire....

My $.02 , I guess I am a student of the KISS theory. (Keep It Simple Stupid)....

-m