Password datatype for SQL Server?

• macer

  Mr or Mrs. 500

  Points: 537

  More actions

  November 15, 2001 at 9:44 pm

  #157748

  Hi,

  Does SQL Server supports any encryption/security measures for user password in tables? such as Input mask with '*' in db, something similiar in MS Access. Thanks!

• patilds

  SSChasing Mays

  Points: 615

  More actions

  November 16, 2001 at 3:03 am

  #420140

  SQL server doesnt support encryption for storing password in user tables.

  Pl. have a look at following articles for reference

  http://www.sqlservercentral.com/columnists/rsharma/comencrytptpw.asp

  http://www.sqlservercentral.com/columnists/lsmith/usingjavatoencryptpasswords.asp

  http://www.sqlservercentral.com/columnists/bknight/encryptfunction.asp