Web Development

If I paste this in SQL management studio, new query and click execute, it will reset password for user E.
That is OK.

Use XDB
Go
UPDATE Users SET Locked='0', Deleted='0',
Password=0xE38AD214943DAAD1D64C102FAEC29DE
where UserName='E';


But I would like to use a script, if possible

When I run a backup, the script starts with the following

SqlCmd -E -S (local)\INSTANCE -Q..........etc

so I assume that the reset script should start with something similar

How do I do?


Thanx in advance