Aug 24, 2005 #1 vlitim Programmer Sep 2, 2000 393 GB Is there anyway in SQL Server to encrypt data stored in tables so that even a administrator cannot actually see the data stored?? Cheers Tim
Is there anyway in SQL Server to encrypt data stored in tables so that even a administrator cannot actually see the data stored?? Cheers Tim
Aug 24, 2005 #2 mrdenny Programmer May 27, 2002 11,595 Yes but in SQL 2000 is requires 3rd party dll's to be installed on the SQL Server. Are you looking for one way encryption or two way encryption? In SQL 2005 encryption is built in to SQL. Denny MCSA (2003) / MCDBA (SQL 2000) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com (Not quite so old any more.) Upvote 0 Downvote
Yes but in SQL 2000 is requires 3rd party dll's to be installed on the SQL Server. Are you looking for one way encryption or two way encryption? In SQL 2005 encryption is built in to SQL. Denny MCSA (2003) / MCDBA (SQL 2000) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com (Not quite so old any more.)