Random Generate Passwords

#1

I have a table: UserID, Username, UserPswd, UserProfile.
At night I dump all new users from another sql database into this database and
I need to generate a random password with alphanumberic values, that are
encrypted. The other database has userid/ username/ userprofile, all I need
to do is gen password. I'm not really sure how to proceed with this. Any
ideas on how to create a random gen pswd? I have a script that uses
pwdencrypt to encrypt password its the generating password that i'm stuck on.
Any suggestions or ideas are appreciated.

thanks
rob

#2

select newid()
--
TIA,
ChrisR

"Rob" wrote:

Quote:

I have a table: UserID, Username, UserPswd, UserProfile.
At night I dump all new users from another sql database into this database and
I need to generate a random password with alphanumberic values, that are
encrypted. The other database has userid/ username/ userprofile, all I need
to do is gen password. I'm not really sure how to proceed with this. Any
ideas on how to create a random gen pswd? I have a script that uses
pwdencrypt to encrypt password its the generating password that i'm stuck on.
Any suggestions or ideas are appreciated.

thanks
rob

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Random Generate Passwords

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Random Generate Passwords - 12-05-2005 , 02:34 PM

RE: Random Generate Passwords - 12-05-2005 , 02:50 PM