Results 1 to 4 of 4

Thread: randomic pwd

  1. #1
    Join Date
    Feb 2003
    Posts
    4

    Lightbulb Unanswered: randomic pwd

    Hi guys!

    Has somebody got a script to create randomic pwd to my users. It isn´t the user from the SQLServer, is inside a table in a database.

    This table has 2 fields, user and pwd, and the user field already has a value. How can a populate the pwd field with a randomic string with 4 characters?

    Thx!

  2. #2
    Join Date
    Apr 2003
    Posts
    18

    Re: randomic pwd

    Hi ,

    Try this out -
    select substring(convert(varchar(7000), newid()), 1, 4)
    Cheers,
    Gola / pankaj

    Originally posted by fabbianchi
    Hi guys!

    Has somebody got a script to create randomic pwd to my users. It isn´t the user from the SQLServer, is inside a table in a database.

    This table has 2 fields, user and pwd, and the user field already has a value. How can a populate the pwd field with a randomic string with 4 characters?

    Thx!

  3. #3
    Join Date
    Jan 2003
    Location
    Leamington Spa, UK
    Posts
    17

    Re: randomic pwd

    Take a look at this link:

    http://vyaskn.tripod.com/code/password.txt

    Cheers,

    macka.

  4. #4
    Join Date
    Apr 2003
    Posts
    18

    Re: randomic pwd

    hi macka,
    Realy good.

    Cheers,

    Originally posted by macka
    Take a look at this link:

    http://vyaskn.tripod.com/code/password.txt

    Cheers,

    macka.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •