Re: Can we encrypt the whole DataBase in Sql Server 2005.



Thanks Jim, for your advice. Atleast I am now sure that SQL Server 2005
does not support DataBase Level Encrytion. I will look for other
options now.


Jim Youmans wrote:

SQL 2005 supports column level encryption. So you could encrypt ever
column, but I would not advise it. Check out Laurentiu Cristofor's
blog for some GREAT info on 2005 encryption
(http://blogs.msdn.com/lcris/default.aspx)

Jim Youmans
DBA
St Louis, Missouri


nitinv wrote:
Hi,
I am new to Sql Server. I wanted to know can I encrypt the whole
DataBase in Sql Server 2005. If yes, can somebody guide me step by step
to this. I searched a lot on net. But of no use, as the only help
available is to encrypt columns in the table.

Thanks and Regards
Nitin Verma.

.



Relevant Pages

  • Re: Code for ADO.NET: The Complete Reference
    ... It involves SQL Server 2000 and ... connect to a Database in SQL will not run and get the error. ... Jim ... website BUT when I go to the Osborne website and enter this ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Orderby on multiple fields in a list
    ... Year Surname TotalCost Volume ... 2003 Jim $14,377.41 61377 ... 2004 Andy $119,609.07 798193 ... Business Intelligence and not writing a query for SQL Server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Qery Analyser - Table Access
    ... SQL Server MVP ... why can't I access the database connected as Jim ?? ... > Data base access Jim 'permit' ... > SELECT permission denied on object 'Companies', database 'SolutionsNet', ...
    (microsoft.public.sqlserver.tools)
  • Re: Exclude Identity Columns to copy rows?
    ... generate the column list if you use Query Analyzer for SQL Server 2000. ... open up the object browser with F8, find the table you want to insert into, ... thing you have to do then is remove the identity column from the list. ... "Jim M" wrote in message ...
    (microsoft.public.sqlserver.programming)

Quantcast