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.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums