Automatic User&Login Creation

To create a sql procedure or function to create and update user names / Login names in a sql server database automatically. The User names, Login Names and Passwords are stored in a custom table in another sql server database. ## Deliverables A custom table exists within the database containing four columns - MyUsername, MyPassword, Myrole and MyGroup. A Procedure needs to be triggered when ever any one of the column is modified or an additional records are Added to the table. The Procedure will create/update/modify the changed detail in another sql server/database Mapping MyUsername = SQL SERVER LOGIN NAME MyPassword = SQL SERVER LOGIN PASSWORD MyRole = SQL SERVER Role MyGroup = SQL SERVER Role Need to develop - test and ensure the above is handed with the complete code and instructions on how to implement the same on different environments. Version - SQL server 2005 / Sql Server 2000. (Should be compatible on both 2005 and 2000)