Friday 24 July 2020

Tuesday 21 July 2020

In SQL Server add database user to server after version upgrade and restoring database

1) Change user owned schemas to dbo
2) Delete database user
3) Delete server user
4) Recreate server user with user mapping to database
5) Reassign schemas owned by user