Encrypt payroll fields

I need to store payroll information (pay rates) in my data warehouse.
I've search on field level encryption and most the stuff i find is for
passwords, I.E. not reversable. I need to protect the payrate field
from dba's and sa's, but I need to allow the authorized users to see
the contents.
Any ideas? Does 2005 handle this?
I don't have a web app, per se, that access's this information. however
I am using Cognos' Report Net.
thanks in advance
RobThe most common solution is to use some kind of encryption library in
your client application or middle-tier, and encrypt/decrpyt the data as
people enter it or retrieve it. In SQL2005, you could use the .NET
crypto libraries within a .NET stored proc, but you can use them
already in a .NET client application regardless of the database.

So it probably depends on what your development environment and
language are. These links might give you some ideas:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
http://www.aspfaq.com/show.asp?id=2536

Simon|||SQL2005 actually has encryption built-in using either shared key or
certificates (which it can generate). Alternatively, for SQL2000 look
at xp_crypt from http://www.activecrypt.com/.

Empty Page problem with table

I have one table on a page and nothing else (I've deleted other stuff),
when I
render report and switch to the print view all the even number pages appear
empty but valid page number and header. How do I fix this problem?
Thank you in advance.Is the table length exceeds the page length (which is there on report
properties). then you will have this problems. Try fit your table in the
page. e.g A4 size, your table should fit inside that meansurements otherwise
it goes to multiple pages along with empty pages.
Amarnath
"JC" wrote:
> I have one table on a page and nothing else (I've deleted other stuff),
> when I
> render report and switch to the print view all the even number pages appear
> empty but valid page number and header. How do I fix this problem?
>
> Thank you in advance.

empty a table

hi everyone,
i was just wondering, is there anyway to empty a table...like, in mysql u can go EMPTY TABLE
and it resets the identity stuff, so your id's start at zero again...?
Thanks, JustinYou can use one of the following statements:

DELETE FROM YourTable

TRUNCATE TABLE YourTable|||DELETE will not reset the Identity value.
TRUNCATE will.|||...like, in mysql u can go EMPTY TABLE no you can't

but thankfully, TRUNCATE TABLE works in mysql too

:)|||no you can't

but thankfully, TRUNCATE TABLE works in mysql too

:)

hi, well, havent used mysql in a little while..

maybe it was known as empty table in 3.x and 4.x versions of mysql...if not, then im not sure where i got it from...or maybe that just what phpmyadmin called it.

but thats for the replies,

Cheers, Justin