How do we delete a login ?

Options
- DELETE LOGIN login_name
- DROP LOGIN login_name
- A login cannot be deleted but only disabled
- DISABLE LOGIN login_name


CORRECT ANSWER : DROP LOGIN login_name

Discussion Board
pl remove all advertise

Dont put any login on my site


B.C.Chikkaswamy 08-8-2017 02:08 AM

DROP LOGIN login_name

DROP LOGIN login_name removes a SQL Server login account where, login_name specifies the name of the login to be dropped. A login cannot be dropped while it is logged in. A login that owns any securable, server-level object, or SQL Server Agent job cannot be dropped. You can drop a login to which database users are mapped; however, this will create orphaned users.

Prajakta Pandit 03-10-2017 04:23 AM

sql

helpful

Ashish 05-6-2015 08:45 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement