DBA > Job Interview Questions > Microsoft SQL Server Database Administrator Exam

What is the T-SQL command to create a new login

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the T-SQL command to create a new login in MS SQL Server?

You can call the following stored procedure to create a new login: sp_addlogin @loginame='...', @passwd='...', @defdb='...'"

(Continued on next question...)

Other Job Interview Questions