Thank this author by sharing:
By Tharindu Dhaneenja,
If you need to delete one user and add the entire related table that user to another user you can easily use this method.
User names have changed. Read the details.
A few changes to the CSS today.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.