Decrypt Data Help - SQL Server Forums

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)

Decrypt Data Help

Author

Topic

cmspot
Starting Member

44 Posts

Posted - 2007-10-14 : 10:04:53

Hello Everybody again......
I am sure that Ms Kristen Will lift the weight of my question again.

Well How can i Encrypt and of course decrypt the contents of a table of mine?

For Example I want the password field of my users table to be encrypted and i want a way to be able only an administrator to read it!

Thank you very much of advanced

I sell my mother in law.Is anybody interested?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-10-14 : 10:09:05

Code here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76258
Usage here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90840

E 12°55'05.25"
N 56°04'39.16"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-14 : 10:16:29

> Ms Kristen

It's Mr. Kristen. it's a he. occasionaly...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-10-15 : 03:19:00

quote:
Originally posted by spirit1

> Ms Kristen

It's Mr. Kristen. it's a he. occasionaly...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com