Password Generating Stored Proceedure

Hi
Does anyone know of any sample stored proceedure code for a random password
generator where I can set the character lenght to 6.
Any help would be much appreciated
Thanks
BenMay be something like
SELECT LEFT(CONVERT(VARCHAR(40), NewID()),6)
?
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"Ben" <Ben@.NoSpam.com> wrote in message
news:uz%23H8hDEFHA.3648@.TK2MSFTNGP10.phx.gbl...
> Hi
> Does anyone know of any sample stored proceedure code for a random
> password generator where I can set the character lenght to 6.
> Any help would be much appreciated
> Thanks
> Ben
>|||Ben wrote:
> Does anyone know of any sample stored proceedure code for a random passwor
d
> generator where I can set the character lenght to 6.
Check out http://vyaskn.tripod.com/code/password.txt
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/|||There is an old DEC Unix routine that produced pronouncable nonsense
words of 6 to 8 letters. You can probably find it in C.
Then Compuserve used to issue two-word phrases of the form
<adjective><noun> ("vivid*bagpipes") that were easy to remember, but
really hard to hack.
My favorite is a "bingo card" of numbers that you issue to users. The
computer challenges them with a pair of numbers; the user locates them
on his card, then replies with the numbers on the other two corners of
a rectangle marked by the first pair.
You then issue a new bingo card each month for security. Even a 5x5
grid has 600 possible challenges.|||"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1108229446.247063.307450@.g14g2000cwa.googlegroups.com...
> You then issue a new bingo card each month for security. Even a 5x5
> grid has 600 possible challenges.
A bit off topic: Due to symmetry, this Bingo card only has 200 unique
challenges that form rectangles. If you allow the challenge numbers to
come from the same file (row or column) then you have 290 unique
challenges but the response to those extra 90 will be equal to the
challenge.
Regards,
Jim