SQL Server 2000 / 2005 Encryption

Would someone be able to provide some information on SQL 2005 encryption? I've searched online and through Books Online to determine from a high level perspective how it is works. Here is what I gather:

1. A certificate (through a 3rd party provider such as VeriSign or self-assigned by SQL 2005 itself) is installed on the server.
2. This certificate is then installed on a client machine.
3. Encryption is then enforced over the connection.

This appears to be a "connection only" type of encryption. So.

Can you encrypt the actual data in a database? Or more specifically, for a particular column in a table? If so, how?
Is this encryption enabled server wide, or for performance reasons, can you enable it only on a single database?

How can I enable something similar in SQL 2000?

I would appreciate any additional online resources as I haven't been able to find much that answers my questions.

Thank-you,
Rubens

.

Relevant Pages

  • Re: how to decrypt an encrypted stored proc in 2005
    ... SQL 2005 still obfuscates object encryption in a similar manner to SQL 2000. ... tinyint,@procNameLength int ... SELECT @BasePos = 1 ...
    (microsoft.public.sqlserver.security)
  • Re: how to decrypt an encrypted stored proc in 2005
    ... remove the feature for the same reason. ... Using a stronger encryption algorithm ... So the feature is unchanged in SQL 2005 from SQL 2000. ... SELECT @BasePos = 1 ...
    (microsoft.public.sqlserver.security)
  • Re: Encryption of application configuration block
    ... If your trying to protect an Sql login password then instead create an Sql ... access to Sql Server objects based on the current users' Windows account. ... If your really must encrypt your connection strings here are some links, ... I come to secure the app.config file via encryption. ...
    (microsoft.public.dotnet.general)
  • Re: Connection to SQL Server CE Windows Service via C# - Error 250
    ... This is probably 3rd time I am hereing to a case the encryption related ... In SQL CE v3.1 case, can you try using Crypto API under the same credentials ... specific to your database or if it's really the password itself. ... connect to it via the windows service under the Local Service ...
    (microsoft.public.sqlserver.ce)
  • Re: how to decrypt an encrypted stored proc in 2005
    ... Everyone that cares needs to realize that object "encryption" in SQL 2005 is ... tinyint,@procNameLength int ... SELECT @BasePos = 1 ...
    (microsoft.public.sqlserver.security)