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 |
|
papster_kat
Starting Member
1 Post |
 Posted - 2007-02-20 : 05:09:26
|
| Hi Everyone, This is my first post so wanted to say hello to everyone. Just wondered if anyone could advise me on the following question ?I am running a web based software that runs on a sql database, one of the tables contains user log in information of which i would like to populate the 'password' field with a random text string of 6 charcters in order to create user passwords at random. There maybe a simple way of doing this but i am new to the sql environment so any help would be great. Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-20 : 05:12:51
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78859Peter LarssonHelsingborg, Sweden |
 |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-02-20 : 23:00:39
|
| Dang! Those all look pretty complicated!Papster, what are the limits of complexity for your desired password generator? All character, all number, a guaranteed mix, all upper, all lower, a guaranteed mix, or ???--Jeff Moden |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-20 : 23:35:36
|
not bulletproof, but a simple and cheap way to do it would be to take the first N chars of newid()
www.elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-21 : 01:01:30
|
| If the complexity is enough with only 16 possible characters for each position, yes.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
Populating Field with Random String