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)