...All those moments will be lost in time, like tears in rain....

- soliloquy from Blade Runner

Bits and bytes do get lost, awash in the rain of data flow that is Internet. They slip away from us, never to found again... some of them will be captured here, many more will not... like tears in rain...

Thursday, March 16, 2017

Orphaned sql users

 If you restore database,there are scenarios when our user gets orphaned.

USE myDb
EXEC sp_change_users_login 'Report'

If you do have orphaned users, you can restore them if they exist but they are not linked to actual logins.

EXEC sp_change_users_login 'Auto_Fix', 'user'

No comments:

Post a Comment