As part of a go-live senario on SQL 2005, I'm trying to find a easy way to copy the userlogin from one database (systemstest DB) to another (Go-live DB).
I have a systemstest-database and a future Go-live database on the same SQL2005 server. As part of test 70 users have been created with acces to the testdatabase. These 70 userlogin's I now need to give the same access to the Go-live database.
It would have to be a nested SQL query listing the userID's from the testDB and the granting the same permissions to the Go-liveDB.
I just don't know how to put this into SQL-statments.
Are there any one here that can help me out :?:
>>None but a fool worries about things they cannot influence...<< - Samuel Johnson