Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-09 : 08:21:28
|
| Rich writes "I need to reset 400 user passwords in a database. Can this be done thru SQL Server automatically when the user tries to login. Will he/she be prompted to change their own password." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-06-09 : 10:57:26
|
| You could write a script to change all of the passwords to the same thing, but users will not be prompted to change their password by applications like EM and QA. If they are connecting through a custom application for which you have access to the source code you could write some code to verify they're not using the temporary password and prompt them to change it if they are. HTHJeff Banschbach, MCDBA |
 |
|
|
|
|
|
SQL Server 2000