Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Drop users from database

    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

Viewing post 1 (of 1 total)