Using DTS objects for scripts to alter SQL Server password
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

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.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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

 64,550 pts.