drop job login

Note that you cannot drop a login while it’s signed in. And if a login owns a securable, server-level object, or SQL Server Agent job, you also cannot drop that login. If a login account is mapped to database users and you drop a login, these database users will become orphaned users. SQL Server DROP LOGIN statement example. We’ll use the ... login pip smp