| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-05-20 : 17:46:38
|
| I remember SQL 7 having a password attribute for character fields in the design view. Where may I find this in SQL 2000?All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-20 : 17:52:13
|
| Could you describe what you mean? I don't recall anything like that, but then again I work mostly in Query Analyzer.Tara |
 |
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-05-20 : 18:03:58
|
| I am refering to design view when creating a table. I know in SQL7 you could ask for the field to be a password field similar to how you may have identity fields.All help appreciated. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-05-20 : 18:07:07
|
| Like I said in the other post, I'm pretty sure that's an access only thing.What are you trying to accomplish???Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-05-20 : 18:18:24
|
| Maybe you are right, could be access but I don't have a SQL7 to check it, but I will go install SQL7 and look again.All help appreciated. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-05-21 : 19:46:30
|
| There is the input mask in Access called Password.And in Visual Basic there is a PasswordChar attribute for text boxes.But I haven't seen (and can't find in BOL) any reference to the same in SQL Server. I think it was in Access because that handled both the database and the front-end for you.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-05-25 : 09:16:38
|
| So what is the equivalent of the password function in SQL. Is there a password or MD5 funtion in T-SQL?All help appreciated. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-25 : 09:56:00
|
| There's sp_password if you are using SQL server rather than Windows logins...But there is nothing like the access password field, all you can do is use encryption on this field... |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-05-25 : 10:27:04
|
| What encryption do you recommend?All help appreciated. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-05-26 : 18:01:16
|
| There are built-in functions to do this called pwdencrypt() and pwdcompare(). But do a search here in the forums to read some of the concerns people have raised about using these. You will also find some discussions on the general subject of encryption with pros, cons, and apps to review.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
Password Attribute