Home > IT Answers > SQL Server > Using DTS objects for scripts to alter SQL Server password
SQL Server Ask the Experts
2,585 pts.
 Using DTS objects for scripts to alter SQL Server password
DTS, Scripting, Scripts, SQL Server
Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?

Software/Hardware used:
ASKED: June 9, 2008  3:22 PM
UPDATED: June 9, 2008  10:39 PM
RELATED QUESTIONS
Answer Wiki:
You can change the password for the sa account using the sp_password procedure provided that you have sysadmin rights to the SQL Server. The syntax is: <pre>exec sp_password @new='Your New Password', @loginame='sa'</pre> DTS is not normally used for user management.
Last Wiki Answer Submitted:  June 9, 2008  10:39 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.