• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Does SQL 2005 Encryption work on a DB in 2000 (80 compatibility) mode?

We want to encrypt a column that houses credit card numbers. The database must stay in 2000 mode until we fix all the other issues with our software. Is it possible to use the 2005 encryption  on a DB that is running in 2000 mode?
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Yes, you can.
I just checked on my SQL server 2005 installation as I was not sure.
ognirg1977Author Commented:
OK, we are rather new to Encryption sadly...Thanks for the info. I need to feel warm inside.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now