:::: MENU ::::

Change password with -Z parameter through SQLSMD

  • Nov 12 / 2008
  • 0
DBA Interview questions, dbDigger, Logins and Users, SQL Server tools

Change password with -Z parameter through SQLSMD

Question: You are trying to run some scripts using SQLCMD but keep getting errors that your password has expired. SSMS is not installed on this machine. What should you do?

Answer: Use the -Z parameter to change your password.

Explanation: While many of us might feel like going home, that’s not a great solution. Either calling a DBA or finding another workstation will work, but that’s inefficient. With the -Z parameter, you can change your own password with SQLCMD.

Ref: SQLCMD – http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx

Note: The Question is taken from SQLServercentral.com.

Consult us to explore the Databases. Contact us