SQL Server Encryption in MSDE 2000

Hot Topic

SMO role permissions for each user
Performance with processing large dimension
varchar columns shown as nvarchar via ODBC
Error-14010-remote server not defined as subscription server
Becoming an mvp
Designer units
Executing SSIS Package containing Update Stmts as a Job
Launching the Reports From Browser
Where is SSIS?
XQuery Question

SQL Server

Attribute Relationships in Project Real
Problem: SSIS, ODBC and Progress Database
Multiple Devices per subscription and SQL-NS API communication
June CTP: Fantastic! Now...
SA account Locked out - Fixed
ViewState in SQL 2000
Stored Procedure to executing an SSIS Package
Member count limit
does "with (nolock)" absolutely guarantee no locks are taken?
SQL Profiler and Analysis Services Connection Error

SQL Server Encryption in MSDE 2000

I developed an app which stored data in SQL 2005, and encrypted some data using EncryptByPassPhrase( PassPhrase, TheData ), DecryptByPassPhrase( PassPhrase, TheData).

One of the implementations of this will have to store the data in SQL 2000, which doesn't support this functionality. Is there a simple data encryption functionality somewhere that I can implement within a stored proc so I can have my app be independent of the back-end data base server , i.e. so I can have two different stored procedures depending on the back end db, and not to have the front end handle the encryption

Thanks

Phil

Answer this question

SQL Server Encryption in MSDE 2000

  • WaterMary

    Thanks, just what I was looking for

  • yango

    My library support all encryption methods and work fine on sql 2000 and 2005.

    Please visit http://www.sqlcrypto.com

  • willis58103

    Marcello, please don't post multiple times just to advertise your library - those posts/threads will be removed.

    It's ok to reply to a thread and point to your site, if it is relevant to the discussed topic and if your library does indeed help, as it is the case for this thread.

    Thank you
    Laurentiu



  • SqlUser01

    You have two choices if you want a solution that works on both SQL Server 2000 and SQL Server 2005:

    (1) implement your own set of encryption procedures

    (2) look at a third party product available for both SQL Server 2000 and SQL Server 2005

    Thanks
    Laurentiu



  • SQL Server Encryption in MSDE 2000
Answer this question