Encryption and storing credit cards

We need to store credit cards for a limited amount of time because we charge for orders as they ship and occasionally the authorization expires before the item can ship.

I know I can use AES_256 to encrypt our credit cards but I am not sure if all I need to do is follow the directions in the "How-to" for encrypting data.

I created the master key, backed it up off the server the certificate and the symmetric key and I can encrypt and decrypt data.

Is this all I need to do or am I missing something?

Sounds like you have it under control. The 'How to' is nicely put together.

The next step is to test, test, test.

|||I have been testing and keep thinking in the back of my head "This is much too easy. I must be doing something wrong."

I got the encryption working on the second try.|||Microsoft got it right. It really shouldn't be difficult.

Enabling Diagram Support in SQL 2005

I get the message I must Alter Authorization. I have not been able to get
this to work. If you have successfully done this, please let me know what
you did.
Note: These are databases which have been restored from SQL 2000 backups,
if that is of any consequence.
Thanks
Migrating to SQL 2005
Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/new...r2005&slcid=us
--Brian
(Please reply to the newsgroups only.)
"Allan" <Allan@.discussions.microsoft.com> wrote in message
news:1E015795-FB82-41E7-8A39-C8B347860D35@.microsoft.com...
>I get the message I must Alter Authorization. I have not been able to get
> this to work. If you have successfully done this, please let me know what
> you did.
> Note: These are databases which have been restored from SQL 2000 backups,
> if that is of any consequence.
> Thanks
> --
> Migrating to SQL 2005

Enabling Diagram Support in SQL 2005

I get the message I must Alter Authorization. I have not been able to get
this to work. If you have successfully done this, please let me know what
you did.
Note: These are databases which have been restored from SQL 2000 backups,
if that is of any consequence.
Thanks
--
Migrating to SQL 2005Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/ne...lcid=us

--Brian
(Please reply to the newsgroups only.)
"Allan" <Allan@.discussions.microsoft.com> wrote in message
news:1E015795-FB82-41E7-8A39-C8B347860D35@.microsoft.com...
>I get the message I must Alter Authorization. I have not been able to get
> this to work. If you have successfully done this, please let me know what
> you did.
> Note: These are databases which have been restored from SQL 2000 backups,
> if that is of any consequence.
> Thanks
> --
> Migrating to SQL 2005

Enabling Diagram Support in SQL 2005

I get the message I must Alter Authorization. I have not been able to get
this to work. If you have successfully done this, please let me know what
you did.
Note: These are databases which have been restored from SQL 2000 backups,
if that is of any consequence.
Thanks
--
Migrating to SQL 2005Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
--
--Brian
(Please reply to the newsgroups only.)
"Allan" <Allan@.discussions.microsoft.com> wrote in message
news:1E015795-FB82-41E7-8A39-C8B347860D35@.microsoft.com...
>I get the message I must Alter Authorization. I have not been able to get
> this to work. If you have successfully done this, please let me know what
> you did.
> Note: These are databases which have been restored from SQL 2000 backups,
> if that is of any consequence.
> Thanks
> --
> Migrating to SQL 2005