Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
SQL Server DBA
« Previous
Next »
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
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲