I need to add one user to different 30 databases on the same instance.Is there any way to do it in less time then to add it manually one by one.
there is some command "force all users"...ect,can you please let me know the exact command if you are aware.
thank you rgds,
Using SSMS you can quickly check all the tick-boxes for the databases that the login requires. This is on the "Login Properties" page, "User Mapping" section.
Does this give you what you need or do you need to set more specifics about the users?
answered Aug 30 '11 at 05:01 AM
Kev Riley ♦♦
Something like this may also work for you (try it out, it will print the commands that would be run):
If this fits, you can uncomment the
answered Aug 30 '11 at 05:17 AM