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 Cherry64,550 pts.