glad it worked for you. thank you for reviewing the script

hope this is what you are looking for

https://gallery.technet.microsoft.com/SIZE-OF-ALL-DATABASES-IN-0337f6d5

hi,

i have written script , can you check .

gallery.technet.microsoft.com/Extract-Database-dfa53d5a

Thank you

try this ,

it will extract the complete database permission

the script is just too big to copy paste. make sure you are in the database.

it will only create a temp table...

the below document will show you exactly how to add witness server without breaking mirroring.

hope this helps

https://gallery.technet.microsoft.com/ADDING-WITNESS-TO-SERVER-7bb9e392

Thank you

https://gallery.technet.microsoft.com/Extract-Database-dfa53d5a

that might help you

this will script out everything

http://dbasqlhelp.blogspot.in/2015/11/extract-all-database-permissions-before.html

remove the last insert which will fix orphan users