Re: table encryptions
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 12/22/03
- Previous message: MHJ: "Re: Problem with role permissions - supplemental info"
- In reply to: Ehioze: "table encryptions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 22 Dec 2003 12:50:02 +0100
You can do the encryption from the client side. If you are using .NET, use
.NET classes from the System.Security.Cryptography namespace. If you are
using COM language, use CAPICOM. It is a COM interface to Win Crypto API and
can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=860ee43a-a843-462f-abb5-ff88ea5896f6&DisplayLang=en.
If you really want to do it from the server, check extended procedures
inclused in Xp_Crypt at http://www.activecrypt.com/index.htm. You can find
even some T-SQL UDFs at http://www.planet-source-code.com.
-- Dejan Sarka, SQL Server MVP Please reply only to the newsgroups. "Ehioze" <ehioze@usa.net> wrote in message news:00e101c3c7f1$861b55d0$a101280a@phx.gbl... > hi is there anyway to encrypt the data stored in a MS SQL > Server db? > > and what strenght of enryption is available
- Previous message: MHJ: "Re: Problem with role permissions - supplemental info"
- In reply to: Ehioze: "table encryptions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|