Viewing post 1 (of 1 total)
SELECT s.name
FROM sys.schemas s
WHERE s.principal_id = USER_ID(‘TestUser’)
ALTER AUTHORIZATION ON SCHEMA::SchemaName TO dbo
GO
DROP USER TestUser
December 22, 2015 at 11:19 pm
#1847641