Encryption of Data in SQL Server 2000

I know it is possible to encrypt data going to and from SQL Server, but is
there any way to encrypt the data within a DB, either on a whole DB basis, o
r
specific tables or specific fields within tables?
Kind regards
Ross PetersenThere is no native on-disk encryption in SQL 2000. That feature was added
to SQL 2005 and works pretty good.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:5DE2DCC2-E813-40A4-87EC-AFE43B0BA0C1@.microsoft.com...
>I know it is possible to encrypt data going to and from SQL Server, but is
> there any way to encrypt the data within a DB, either on a whole DB basis,
> or
> specific tables or specific fields within tables?
> Kind regards
> Ross Petersen|||Thanks Geoff
--
Kind regards
Ross Petersen
"Geoff N. Hiten" wrote:

> There is no native on-disk encryption in SQL 2000. That feature was added
> to SQL 2005 and works pretty good.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Ross" <Ross@.discussions.microsoft.com> wrote in message
> news:5DE2DCC2-E813-40A4-87EC-AFE43B0BA0C1@.microsoft.com...
>
>|||S2K not support native encryption mechanism.
But support serveral hash functions and extended procedures.
You cans access below url how to extended peocesure(hash function).
http://www.codeproject.com/database/xp_md5.asp
Also,You can review encryption in SQL Server 2005.
"Ross"?? ??? ??:

> I know it is possible to encrypt data going to and from SQL Server, but is
> there any way to encrypt the data within a DB, either on a whole DB basis,
or
> specific tables or specific fields within tables?
> Kind regards
> Ross Petersen|||Thanks hongju
very helpful
Kind regards
Ross Petersen
"hongju" wrote:
[vbcol=seagreen]
> S2K not support native encryption mechanism.
> But support serveral hash functions and extended procedures.
> You cans access below url how to extended peocesure(hash function).
> http://www.codeproject.com/database/xp_md5.asp
> Also,You can review encryption in SQL Server 2005.
>
> "Ross"?? ??? ??:
>