Viewing 6 posts - 1 through 6 (of 6 total)
There are a lot of reasons...
The biggest one is: beeing forgotten.
Or for example, when one database comes from a completely different server but the login is beeing used by more...
August 27, 2021 at 9:33 am
#3924417
i added the update one for users that have a different Id than the login on the server.
INSERT INTO ##tbl_db_principals_statements (stmt, result_order) SELECT ...
July 28, 2021 at 2:45 pm
#3914702
what if the users own things?
May 27, 2021 at 11:32 am
#3888693
I just added the "EXEC sp_change_users_login 'Update_One', 'login', 'user'" to the creating of the users in the script. If the user is already mapped it does not raise an error....
May 26, 2021 at 6:34 pm
#3888354
i ve modified it so that
-i get the results in a table before i restore my DB (modified a little the skript of S.Gusen)
-restore the DB
-then i change all owners...
July 7, 2020 at 8:55 am
#3767952
Skript is amazing... Using it all the time...
Does anyone know if the same exists for removing Users? I want to remove the users that left are in the Backupfile
April 20, 2020 at 9:18 am
#3744224