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!



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.

UPDATE Users SET Locked='0', Deleted='0',
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