Column Encryption in Sql Server 2000

Are there any UDf's or Xtended stored procs available in sql server 2k that can encrypt a column that has the CC #'s or do I need to purchase a 3rd party tool ?

thanks,
DinakarHi ndinakar:

Nothing in SQL 2000.

Just as a side note, MS recently announced native encryption for SQL Server 2005.|||There is an undocumented function in SQL 2000, which allow to encrypt data, but it is one way hash, there is no way to decrypt it, so will not be suitable to store CC #, its better suited to store the passwords for compaison purpose.|||so how do people do it ? using 3rd party encryptioners ? anyone already doing it willing to share some of your xperience pls ?

TIA.

Collations ... blah!

What collation setting(s) do I need to set with RebuildM to get the
SQL_Latin1_General_CP1_CI_AS collation?
3rd time going and I can't seem to set/select the right configuration.
Thanks,
MorganFound it...
Dictionary Order, case insensitive for use with 1252 Char Set.
Thanks,
Morgan
"Morgan" <mfears@.spamcop.net> wrote in message
news:ueb0z8jxDHA.2328@.TK2MSFTNGP10.phx.gbl...
> What collation setting(s) do I need to set with RebuildM to get the
> SQL_Latin1_General_CP1_CI_AS collation?
> 3rd time going and I can't seem to set/select the right configuration.
>
> Thanks,
> Morgan
>