Re: How do you encrypt a password column?

Hi all,
How do you encrypt a password column in SQL Server 2000 table?
I would like to store something like *** in the column.
Thanks much!do you submit the same question every couple of weeks to drive me insane?|||I'd check here (http://www.dbforums.com/showthread.php?t=1099654), or here (http://www.dbforums.com/showthread.php?t=1095162) for a couple of answers.

-PatP|||I beleive it's an agent that wakes up once a week...|||Try this:

create function EncryptPassword(@.PasswordString varchar(20))
returns char(10)
as
begin
declare @.NewPassword varchar(20)
set @.NewPassword = isnull(nullif(@.PasswordString, @.PasswordString), '**********')
return @.NewPassword
end|||Here is an even stronger algorithm. It uses a single-pass one-way encryption hash that is very secure. It is impossible to decrypt. As far as I know, this method has never been cracked:

drop function EncryptPassword
go
create function EncryptPassword(@.PasswordString varchar(20))
returns char(10)
as
begin
declare @.ASCIICounter as integer
set @.PasswordString = upper(@.PasswordString)
set @.ASCIICounter = ascii('A')

while @.ASCIICounter <= ascii('Z')
begin
set @.PasswordString = replace(@.PasswordString, char(@.ASCIICounter), '*')
set @.ASCIICounter = @.ASCIICounter + 1
end

return @.PasswordString
end|||Hi,

To those who replied with help I appreciated always.
To those who replied with criticisms don't reply at all. Who are you to judge other people. Either help or don't.
Thanks!|||Now look here. I posted some help when you asked this question 2 times ago. . In fact several fine solutions were suggested to your problem each time you posted this.

I like helping people, but it gets a little fustrating answering the same question from the same person all of the time.

If you do not understand the answers, say so. We will explain further but don't keep posting the same question. It's annoying.|||You may have seen the post more than once someone may not.
The possible solutions may not be the one One is seeking for.
Its probably annoying or frustrating what you think is the problem. No one should be publicly humiliated.|||YOU (alicejwz) need to quit posting the same d@.mn question over and over again.

Very knowledgeable, very intelligent, very patient, and very generous people have already given you the ONLY ANSWER YOU WILL GET.

SEVERAL TIMES!

And frankly, it is INSULTING that you just keep posting the same question hoping somebody new will give you a better answer.

You think the people on this forum aren't smart enough to know the answer to such a simple question? Then go find some other forum to pester.

Bleh!|||Hi,

To those who replied with help I appreciated always.
To those who replied with criticisms don't reply at all. Who are you to judge other people. Either help or don't.
Thanks!

Ummm...do you know the difference?

And lighten up Francis|||YOU (alicejwz) need to quit posting the same d@.mn question over and over again.

Very knowledgeable, very intelligent, very patient, and very generous people have already given you the ONLY ANSWER YOU WILL GET.

SEVERAL TIMES!

And frankly, it is INSULTING that you just keep posting the same question hoping somebody new will give you a better answer.

You think the people on this forum aren't smart enough to know the answer to such a simple question? Then go find some other forum to pester.

Bleh!

Yo dude...who replied with help?

EDIT: And where's Karolyn Been?

I think that's her login|||You may have seen the post more than once someone may not.
The possible solutions may not be the one One is seeking for.
Its probably annoying or frustrating what you think is the problem. No one should be publicly humiliated.If you just want to bring the thread back to the top of the list, then "bump" it. Add a new posting at the end and simply comment that you are still looking for another answer, or even just the word "bump" by itself. That way the folks who've already responded will easily recognize both that they've already answered the question, and that you weren't satisfied with the answers you've gotten so far.

The people who reply to questions are a scarce resource... Well over 90% of the people that visit will never post, and another 9% will only post questions. The remainder is all that we've got to provide answers, so anything that irritates them is a danger to the forum itself. I'm not trying to tell you to bow and scrape to the posters, but please consider that they volunteer to help with problems... If you want that resource available quickly, easily, and for free, you need to husband it carefully!

Nobody is trying to humiliate you (yet), you'll know much more clearly when that happens! The repeated posting of the same question is like repeatedly asking the same question at a party... It is often ignored the first time it is repeated, sets people to whispering after that, and gets a rather stern lecture if it goes on too long. Right now you're well into the whispering stage with this question.

-PatP|||The possible solutions may not be the one One is seeking for.

I posted something like that on the Pagan forum! (It seemed to be the right place for it.)

:)|||I posted something like that on the Pagan forum! (It seemed to be the right place for it.)

:)

Do you mean the Oracle forum?|||If you just want to bring the thread back to the top of the list, then "bump" it. Add a new posting at the end and simply comment that you are still looking for another answer, or even just the word "bump" by itself. That way the folks who've already responded will easily recognize both that they've already answered the question, and that you weren't satisfied with the answers you've gotten so far.be very careful when doing this

if you capriciously just "bump" for no stated reason, your bumping post might be deleted by a moderator

in other words, your thread will be left alone, but the last "bump" will be removed|||be very careful when doing this

if you capriciously just "bump" for no stated reason, your bumping post might be deleted by a moderator

in other words, your thread will be left alone, but the last "bump" will be removed

Why is this?

You got a rule book?|||'cause Sheriff Rudy says so, that's why.

Though up there I guess they call them "Mounties".