SELECT s.name
FROM sys.schemas s
WHEREs.principal_id = USER_ID('user_name')
ALTER AUTHORIZATION ON SCHEMA::[found_object_above] TO [dbo]
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'user_name')
DROP USER [user_name]
Never in the field of human conflict was so much owed by so many to so few. All our hearts go out to the developers, whose brilliant actions we see with our own eyes day after day…