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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 generate passwordsalt using query

Author  Topic 

muthukumar.csm
Starting Member

18 Posts

Posted - 2009-01-09 : 03:40:37
anybody know how to generate Passwordsalt for when creating user in aspnet_membership table using sqlquery.bcoz i need it when creating the firstuser.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-09 : 04:22:02
See http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-01-09 : 04:45:52
If you want to generate random password for each user,
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/20/random-password-generator.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

muthukumar.csm
Starting Member

18 Posts

Posted - 2009-01-09 : 05:54:09
Thanks to you.But i need to generate Passwordsalt for particular string ex:password
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-01-09 : 07:39:53
What do you mean by Passwordsalt?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -