Question

Which of the following statements is true?

A. We can reset passwords by using SSMS only
B. We can reset passwords by using the ALTER LOGIN statement only
C. We can reset passwords by using SSMS or ALTER LOGIN statement

Answer 1

Passwords in SQL Server can be reset using both SQL Server Management Studio (SSMS) and the ALTER LOGIN statement, making both methods viable options.

Step-by-step explanation:

The true statement among those provided is: We can reset passwords by using SSMS or ALTER LOGIN statement. SQL Server Management Studio (SSMS) offers a graphical interface for managing SQL Server, which includes reseting passwords through its security and login options. Alternatively, the ALTER LOGIN statement can be used within a query window to reset a password in SQL Server. It is possible to change the passwords using either method, depending on the user's preference or the context of the task at hand.

The ALTER LOGIN statement is a SQL Server command that can also be used to change passwords. It allows you to modify the login properties, including the password, for a specific user account.