Using DTS objects for scripts to alter SQL Server password
SQL Server, DTS, Scripts, Scripting
Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server? Question
SQL Server, DTS, Scripts, Scripting
Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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:
exec sp_password @new='Your New Password', @loginame='sa'
DTS is not normally used for user management.
Browse more Questions and Answers on SQL Server, Development and Microsoft Windows.
Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Mrdenny | Jun 9 2008 10:39PM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
