Re: SQL password
- From: "Mark J. McGinty" <mmcginty@xxxxxxxxxxxxxxx>
- Date: Fri, 19 Jan 2007 13:59:33 -0800
"adrian" <adrian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C26BE58-C8D1-4871-8633-19D6286D7C26@xxxxxxxxxxxxxxxx
Under SQL database server authentication, is the username and password are
stored in clear text in the system tables?
No they are encrypted, take a look for yourself:
SELECT name, password FROM master..sysxlogins
-Mark
Adrian
.
- Follow-Ups:
- Re: SQL password
- From: Laurentiu Cristofor [MSFT]
- Re: SQL password
- References:
- SQL password
- From: adrian
- SQL password
- Prev by Date: SQL password
- Next by Date: Re: SQL password
- Previous by thread: SQL password
- Next by thread: Re: SQL password
- Index(es):