Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/22

Click to flip

22 Cards in this Set

  • Front
  • Back
What transact SQL statement returns info regarding all Win2K groups or a specified group in the current Database
sp_helpntgroup ['name']
What transact SQL statement returns info regarding all database roles or membership in a specified role in the current database?
sp_helprolemember ['role']
What transact SQL statement returns info for all users or a specified user in the current database including role memberships?
sp_helpuser ['security_account']
What transact SQL statement returns info on server roles and their members?
sp_helpsrvrolemember ['role']
What transact SQL statement returns info for all logins or a specified login including the database and role?
sp_helplogins ['login']
What transact SQL statement adds a new user-defined database role in the current database?
Recommendation - ?
sp_addrole 'role', 'owner'
- leave owner as dbo
What transact SQL statement drops a user-defined database role in the current database?
sp_droprole 'role'
What transact SQL statement drops a security account from a database role in the current database?
sp_droprolemember 'role',
'security_account'
What transact SQL statement adds a security account to a database role?
sp_addrolemember 'role',
'security_account'
What transact SQL statement changes the owner of a user database?
sp_changedbowner 'login'
What transact SQL statement adds a login as a user in the current database?
sp_grantdbaccess 'login', 'name-in-db'
What transact SQL statement removes a login as a user in the current database?
sp_revokedbaccess 'name'
What transact SQL statement drops a login as a member of a server role?
sp_dropsrvrolemember 'login', 'role'
What transact SQL statement adds a login to a server role?
sp_addsrvrolemember 'login', 'role'
What transact SQL statement adds or changes a password?
sp_password 'old_password',
'new_password', 'login'
What transact SQL statement drops a SQL Server login?
sp_droplogin 'login'
What transact SQL statement creates a new SQL Server login?
sp_addlogin 'login', ['password',
'database', 'language', 'sid',
'encryption_option'
What transact SQL statement changes the default language for a login?
sp_defaultlanguage 'login'
What transact SQL statement changes the default database for a login?
sp_defaultdb 'login', 'database'
What transact SQL statement prevents a windows 2000 user or group from connecting?
sp_denylogin 'login'
What transact SQL statement revokes the login entry from SQL Server for Win2K user or group?
sp_revokelogin 'login'
(Doesn't explicitly block access)
What transact SQL statement creates a login for a Win2K user or group?
sp_grantlogin 'login'