Can we encrypt the whole DataBase in Sql Server 2005.

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.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.|||In a situation with a need for extreme security, EFS could be used (unless
using a clustered server.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Jim Youmans" <jdyoumans@.gmail.com> wrote in message
news:1154354782.895003.215230@.i42g2000cwa.googlegroups.com...
> 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:
>|||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:
[vbcol=seagreen]
> 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:|||Arnie, I appreciate your advice, but if I use EFS, will my Sql Server
be able to read the files in the folder, which has been encrypted.
I guess that it loads the Database files, but shows the Database as
suspected.
May be you could throw some more light on it.|||I have used EFS for database storage and backup file locations. The key is
that the SQL Server Service Account MUST own the EFS folder(s).
When setting this up, I log in as the service account, create the EFS
folder(s), COPY any existing databases to the location (Keep copies until I
am sure that the process went smoothly. Then attach the database.
Usually all goes well.
But if clustering is used, when the cluster fails over, there is problem
with key transfer. So I do not recommend EFS with Clustering.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Nitin Verma" <nitin.verma.in@.gmail.com> wrote in message
news:1154410210.573642.61620@.i42g2000cwa.googlegroups.com...
> Arnie, I appreciate your advice, but if I use EFS, will my Sql Server
> be able to read the files in the folder, which has been encrypted.
> I guess that it loads the Database files, but shows the Database as
> suspected.
> May be you could throw some more light on it.
>|||Thanks Arnie,
I hope it works.
Arnie Rowland wrote:
[vbcol=seagreen]
> I have used EFS for database storage and backup file locations. The key is
> that the SQL Server Service Account MUST own the EFS folder(s).
> When setting this up, I log in as the service account, create the EFS
> folder(s), COPY any existing databases to the location (Keep copies until
I
> am sure that the process went smoothly. Then attach the database.
> Usually all goes well.
> But if clustering is used, when the cluster fails over, there is problem
> with key transfer. So I do not recommend EFS with Clustering.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Nitin Verma" <nitin.verma.in@.gmail.com> wrote in message
> news:1154410210.573642.61620@.i42g2000cwa.googlegroups.com...

can u guide me writing a simple query

I am trying to do following thing:

i got a table which contains some words...all i need to do is whenever i see a word starting with 'R', i need to remove the starting 'R' and update it in the same table...

could anyone help me out here....thanks a lot in advance.......

I'm assuming by the title that you want to do it in the sql query. Here is one way to do it:

Select
Case WhenWordlike 'r%' Then right(Word, len(Word)-1) end
From Table1

|||

Can you provide some sample data and what you are trying to update it to so we can get a better idea?

sql