Page Comparison

• Open Studio
• Expand the Jobs node, right click on Unassigned tasks and select New Task.
• Create a Workflow Stored Procedure Task and give it a Name e.g. Update SDW User password
• Select the Spatial Data WarehouseConnection, Click on the Astun radio button and select the Functionat_wkf_executecmd.
• Enter the following in the Edit parameter 'cmdtoexecute' box, replacing user and password with the name and password for the user whose password you wish to change. 

ALTER USER "user" WITH PASSWORD 'password';

Image Modified

• Click the Run button Image Modified to run the task. You should see the dialog SPTask 'Update SDW User password' completed successfully. Click OK.
• Click Save to save your new task details.