Question Locked
SQL script
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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