Web Development

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

SQL script

By ll05197 ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums