My criteria is to transfer all database level permissions from login 'A' to login 'B' in the same server.

B should be exactly mirror as A

can you please describe it briefly.. im not getting properly

k thanks i will try out

i tried that option . i need different text file should be generated each time when i run job, is there any solution for this, Please let me know.

along with i want result to be in excel sheet

thanks for info, but i dont have knowledge of power shell, how i can start working on above?

im not able to solve by profiler, is there any other try to find out the above issue???

Please let me know how i can get the previous info if i enable my profiler now?

But Default database is assigned to MASTER db itself.

Im not able to see any of the scripts given above

Msg 2760, Level 16, State 1, Procedure sp_helplogins_2, Line 460

The specified schema name "sys" either does not exist or you do not have permission to use it.

Im getting above error...

This script is throwing a lot of error

any alternative to establish mirroring if computer belongs to different workgroups..???

hi,

can we establish database mirroring if the servers belong to workgroup or be in domain is mandatory??

Thanks it worked fine