SQLServerCentral / Discuss Content Posted by Michael Coles / Article Discussions / Article Discussions by Author / SQL 2000 DBA Toolkit Part 1 / Latest Posts

RE: SQL 2000 DBA Toolkit Part 1

Mark Salvador — Wed, 03 Feb 2010 14:07:16 GMT

I am also having the same problem. I used the web site to encrypt/decryt credit card details but when i checked it with other machine, for example in Query Analyzer, it shows NULL result.Is it possible to remove this "per local machine" and to make it accessible to everyone? Can I also request for the source code for AES algorithm? Desperately need solution on this.Thanks,Mark

RE: SQL 2000 DBA Toolkit Part 1

garyyeung — Thu, 05 Nov 2009 01:18:15 GMT

Hi Mike,I'm studying the tool kit and got a question of using password for the key. I have used different password for creating master and local keys but I found that whenever the password used for encrypt the data and decrypt the data is the same, the password for keys are meaningless. Like the example below, all the key materials and passwords are different for the master key and local key. But still, I can get the right encryption and decryption by that key as below.[quote]exec create_master_key 'PWMaster', 'pw1', 'pw2'exec create_local_key 'PWMaster', 'PWLocal', 'pw3'DECLARE @encry AS VARBINARY(128)DECLARE @decry AS VARCHAR(128)select @encry = dbo.fn_encrypt_aes(CAST('Data to be encrypt' AS VARBINARY), 'PWLocal', 'pw4', 128)select @decry = dbo.fn_decrypt_aes(@encry, 'PWLocal', 'pw4', 128)Print @encryPrint @decry[/quote]Have I made any stupid mess up of the concept? Can you please remind me? Thanks so much.Gary.

RE: SQL 2000 DBA Toolkit Part 1

garyyeung — Thu, 05 Nov 2009 00:55:00 GMT

Hi Mike,It's a cool Tool kit and I'm now studying the kit and going to propose it to be used in a project enhancement.To propose, I need to have a prove of licensing and prove of safe of the dlls. I found that there is a statement of licensing posted by you. So, if I modified the install.sql, uninstall.sql and do not include every functions (dlls) to the kit, will the terms break? and is there any offical terms of usage so that I can show to my boss?For safety, how can I prove to my boss on the safety of dlls?Million thanks,Gary.

RE: SQL 2000 DBA Toolkit Part 1

ricva — Sat, 19 Sep 2009 17:01:31 GMT

Check out transparent data encryption now available in 2008. If this does not meet your needs please read Micheal's article and all the threads. One issue with the toolkit is with replication, or restoring to another server.

RE: SQL 2000 DBA Toolkit Part 1

boyette — Fri, 18 Sep 2009 13:05:47 GMT

I'm upgrading to SQL 2008 and I want to use something similar to this toolkit on the new SQL 2008 server. Is there something compatible?Jason

RE: SQL 2000 DBA Toolkit Part 1

alejandrapclopez — Thu, 30 Apr 2009 13:00:57 GMT

Hi all,I have a problem, I encrypted data using AES encryption algorithm with function fn_encrypt_aes, but the results were diferents in differents servers.how could be the results to be the same in both servers?Thanks for your help.Alejandra

RE: SQL 2000 DBA Toolkit Part 1

ricva — Mon, 17 Nov 2008 15:23:35 GMT

Michael, I appreciate the DBA Toolkit, and it has been very helpful. I continue to have trouble with the encryption and desperately need help. I need to be able to to set up another server for failover. I have compiled the code for CertMgr (posted earlier) (that uses the machine key). I used this to Export the scrypto params. Then on the failover server I do an import of the same scrypto.params file. I also have a SQL script with the data from the Local_key and Master_Key tables. so the data in these tables on both servers are the same.My test is to use the decrypt_AES function to see the value in the encrypted column. On the failover server I am getting NULL back.I also have problems getting data back from ASP.NET using a ADO.NET SQLClient call to a stored procedure. The values in the column is null. Calling the same stored procedure through ASP - ODBC works. Is the source code for the sprocs available?Thank-you

RE: SQL 2000 DBA Toolkit Part 1

ricva — Fri, 14 Nov 2008 15:56:58 GMT

The link to the code does not work. I am hoping to source code in order to see if I can get around the export/import issue I am having.Thanks

RE: SQL 2000 DBA Toolkit Part 1

ricva — Thu, 13 Nov 2008 07:48:37 GMT

:w00t:I am getting this error when importing the params file: System.Security.Cryptography.CryptographicException: Access is denied. at System.Security.Cryptography.CryptographicException.ThrowCryptogaphicException(Int32 hr) at System.Security.Cryptography.Utils._GenerateKey(SafeProvHandle hProv, Int32 algid, CspProviderFlags flags, Int32 keySize, SafeKeyHandle& hKey) at System.Security.Cryptography.Utils.GetKeyPairHelper(CspAlgorithmType keyType, CspParameters parameters, Boolean randomKeyContainer, Int32 dwKeySize, SafeProvHandle& safeProvHandle, SafeKeyHandle& safeKeyHandle) at System.Security.Cryptography.RSACryptoServiceProvider.GetKeyPair() at System.Security.Cryptography.RSACryptoServiceProvider..ctor(Int32 dwKeySize, CspParameters parameters, Boolean useDefaultKeySize) at System.Security.Cryptography.RSACryptoServiceProvider..ctor(CspParameters parameters) at DBACertManager.CertManager.Main(String[] args)My machine.config has trust =FULL Any ideas

RE: SQL 2000 DBA Toolkit Part 1

uhdleo — Wed, 04 Jun 2008 21:42:56 GMT

hi Mike,I have same problem, do i have to do any correction to make this work,Thanks,Leo[quote][b]cdsingh (3/5/2008)[/b][hr]I have looked at this toolkit yesterday and it is really wonderful.I have instelled it for testing on 2 windows 2000 boxes and it works great.on third box while installing scripts i got this error[b]Step 1. Searching for Master Key Vault. Master Key Vault located in database.Step 2. Generating local key.Msg 1, Level 1, State 1An MS Crypto API cryptographic service handle could not be acquired.Server: Msg 515, Level 16, State 2, Procedure Create_Local_Key, Line 116Cannot insert the value NULL into column 'Key', table 'master.dbo.Local_Key_Vault'; column does not allow nulls. INSERT fails. Local Key Vault located in this database.Step 3. Checking for existence of local key in vault.Step 4. Saving Local Key in Vault.The statement has been terminated.Step 5. Finished.[/b]The only difference I have seen on this sql server is that we r using it as an instancelike name of sql server is dt-geo12\geo12so the physical binn path becomesc:\Program Files\Microsoft SQL Server\MSSQL$geo12\binn\Can anybody suggest anything?Thanks[/quote]

RE: SQL 2000 DBA Toolkit Part 1

anathani — Tue, 27 May 2008 10:28:38 GMT

Hello,Has anybody used this on clustered servers??. Also does the vault have to reside on the master db?Thanks

RE: SQL 2000 DBA Toolkit Part 1

Ed Klichinsky — Sat, 12 Apr 2008 08:54:25 GMT

I've solved the issue of exporting/importing RSA key container SCRYPTO from one machine to another.The issue was revolving around the machine vs. current user key containers.Original C# code provided by Michael Cole was working but it was importing a key container at the current user level. All I had to do is to add one extra line while importing to indicate that we're working at the machine level."cp.Flags = CspProviderFlags.UseMachineKeyStore;"Below is the modified and tested C# code:using System;using System.Collections.Generic;using System.Text;using System.Security.Cryptography;using System.Xml.Serialization;using System.IO;namespace certMgr{ class Program { static void Main(string[] args) { try { Console.WriteLine("This app is used to export or import SCRYPTO keystore used by the DBAToolkit."); Console.Write("Please input E(xport) or I(mport): "); string strResp = Console.ReadLine(); if (strResp == "E") { CspParameters cp = new CspParameters(); cp.KeyContainerName = "SCRYPTO"; RSACryptoServiceProvider rsa = new RSACryptoServiceProvider(cp); RSAParameters p = rsa.ExportParameters(true); XmlSerializer x = new XmlSerializer(typeof(RSAParameters)); MemoryStream ms = new MemoryStream(); x.Serialize(ms, p); ms.Flush(); StreamWriter sw = new StreamWriter(@"c:\scrypto.params", false, Encoding.UTF8); sw.Write(System.Text.Encoding.ASCII.GetString(ms.ToArray())); sw.Close(); ms.Close(); } else { if (strResp == "I") { CspParameters cp = new CspParameters(); cp.KeyContainerName = "SCRYPTO"; cp.Flags = CspProviderFlags.UseMachineKeyStore; RSACryptoServiceProvider rsap = new RSACryptoServiceProvider(cp); RSAParameters p = new RSAParameters(); XmlSerializer x = new XmlSerializer(typeof(RSAParameters)); Stream reader = new FileStream(@"c:\scrypto.params", FileMode.Open); p = (RSAParameters)x.Deserialize(reader); reader.Close(); rsap.ImportParameters(p); } else Console.WriteLine("Error: incorrect parameter!"); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } } }}

RE: SQL 2000 DBA Toolkit Part 1

joberkehr — Thu, 10 Apr 2008 11:19:47 GMT

Im having the same problem. Im trying to figure out how to transfer to a new machine.Please help.

RE: SQL 2000 DBA Toolkit Part 1

Ed Klichinsky — Fri, 14 Mar 2008 09:48:58 GMT

Hi Mike,I've used your original SQL Encryption toolkit and now replacing it with the DBA Toolkit.I appreciate what you have done for the SQL community by releasing this toolkit.I've implemented your toolkit and have created a layer on top of it which consists of views and instead of triggers which auto encrypt/decrypt data being inserted/retrieved. Client application is unaware of the encryption, which is quite useful when encryption is needed but client application should remain unchanged.One question: moving a SCRYPTO keystore to a different machine.I've tried your sample .NET code which runs ok but toolkit does not seem to decrypt same value on 2 different machines. I'm trying to locate some Microsoft tools but not sure which one will do the trick. Can you offer any suggestions?ThanksEd

RE: SQL 2000 DBA Toolkit Part 1

cdsingh — Wed, 05 Mar 2008 16:08:54 GMT

I have looked at this toolkit yesterday and it is really wonderful.I have instelled it for testing on 2 windows 2000 boxes and it works great.on third box while installing scripts i got this error[b]Step 1. Searching for Master Key Vault. Master Key Vault located in database.Step 2. Generating local key.Msg 1, Level 1, State 1An MS Crypto API cryptographic service handle could not be acquired.Server: Msg 515, Level 16, State 2, Procedure Create_Local_Key, Line 116Cannot insert the value NULL into column 'Key', table 'master.dbo.Local_Key_Vault'; column does not allow nulls. INSERT fails. Local Key Vault located in this database.Step 3. Checking for existence of local key in vault.Step 4. Saving Local Key in Vault.The statement has been terminated.Step 5. Finished.[/b]The only difference I have seen on this sql server is that we r using it as an instancelike name of sql server is dt-geo12\geo12so the physical binn path becomesc:\Program Files\Microsoft SQL Server\MSSQL$geo12\binn\Can anybody suggest anything?Thanks

RE: SQL 2000 DBA Toolkit Part 1

bharat_kothari — Fri, 28 Dec 2007 08:35:25 GMT

The source code link is still not working. (http://www.sqlservercentral.com/products/mcoles/default.asp), would it be possible for you to supply a new link?

RE: SQL 2000 DBA Toolkit Part 1

nickblanchard — Thu, 08 Nov 2007 09:38:20 GMT

The link for the source code does not seem to be working now (http://www.sqlservercentral.com/products/mcoles/default.asp), would it be possible for you to supply a new link?Nicklas Blanchard

RE: SQL 2000 DBA Toolkit Part 1

Rick Larkin — Sun, 08 Jul 2007 19:08:00 GMT

Has anyone gotten this to compile in VC++ 8 (Visual Studio 2005) or am I stuck with VC++ 7.1? If you got it compiled in VC++ 8, I'd love to hear how you went about it.

Thanks!

Rick

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Fri, 04 May 2007 09:33:00 GMT

If you haven't yet, download the C++ source code and use it as a guide for the conversion. The code for the extended proc that creates the master key, and the XP that encrypts the local keys with the master keys are the ones you want to look at.

RE: SQL 2000 DBA Toolkit Part 1

nicu paraschiv — Fri, 04 May 2007 08:56:00 GMT

Hi Mike, so far so good.

I never worked with c++, I was trying to reproduce the code in vb using the windows api, I am basically using the same functions to acquire context, CryptDecrypt etc, I have also imported the key container on my machine where I run the code but....it's not working

After I updated the master key in the database, encrypted with the new password, I noticed that the hex representation of the key is longer then the previous one, all other master keys (I have like 4 of them) have the same length except the new one is longer... I know I must be doing something wrong, any suggestions will be appreciated..

Thank you, Nick

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Fri, 04 May 2007 08:36:00 GMT

Yes, you should be able to decrypt and re-encrypt the master key with a new password without having to decrypt/re-encrypt everything else. That's the advantage of layering the keys, ANSI style .

As for the keys, if you change the master key, you'll need to decrypt and re-encrypt all the local keys it encrypts. If you change a local key, you'll have to decrypt and re-encrypt all the data it protects.

RE: SQL 2000 DBA Toolkit Part 1

nicu paraschiv — Fri, 04 May 2007 06:47:00 GMT

Hi Mike, I' m back to changing the password issue. I am thinking, since the password (second password) is used only to encrypt and decrypt the master key, then it should be possible to change the password without having to create a new set of master/localkeys, right?? In other words, you can use the password to decrypt the master key and then use a new password to encrypt the master key and put it back in the table master_key_vault. The local key doesn't have to change, in this scenario, right?

Please let me know what do you think so far.

Thank you, Nick

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Thu, 26 Apr 2007 10:59:00 GMT

The advantage of using the user credentials is that you don't have to pass the plain text password "over-the-wire" to the server for every encryption/decryption. There's really no performance benefit to decrypting and re-encrypting. If you plan on doing this on a regular basis, I would recommend creating a stored procedure to perform the decryption/re-encryption for you so you get the same process every time. If you do it in a stored procedure, you might be able to get some performance benefit by doing the conversion in chunks; e.g. decrypt/re-encrypt 10,000 rows at a time instead of all at once; although I haven't tested that myself to be able to tell you for sure.

RE: SQL 2000 DBA Toolkit Part 1

nicu paraschiv — Thu, 26 Apr 2007 09:59:00 GMT

Hi Mike, I just wanted to make sure there was no other easier way. For updating the data, I can use something like encryt(decrypt(data,password1),password2) in one single update query (of course, after I have created the second master/local key)

Also, as an alternative I could use the user's credentials instead of the password from the beginning.

Considering we might need to change the password from time to time, and there is some large amount of data that needs to be encrypted, which method would you recommend?

Thank you, Nick

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Thu, 26 Apr 2007 09:40:00 GMT

Hi Nick,

That's the method that has to be used. I didn't create an automated method of decrypting/re-encrypting data (like in SQL 2005) for this version; particularly because I didn't want to get into the complexity of trying to keep track of which encryption key was used on which columns. To do something like that would require storing the ID of the encryption key with the data (like in SQL 2005), and I didn't jump into that with this version - so it has to be done manually; although you could create a stored procedure to help automate the process.

RE: SQL 2000 DBA Toolkit Part 1

nicu paraschiv — Thu, 26 Apr 2007 09:12:00 GMT

Mike, if I use a password to create the master key/local key, then I have to use the same password everytime to encrypt/decrypt data. Question is, how do I change the password? I can decrypt the data, create a new master/local key with a new password and then encrypt the data again, but is there any other way for me to change the password?

Thank you, Nick

RE: SQL 2000 DBA Toolkit Part 1

Anukul — Fri, 06 Apr 2007 10:35:00 GMT

Thanks so much Mike !

Cheers,Anukul

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Thu, 05 Apr 2007 20:11:00 GMT

As long as you reference the XP's correctly in the master database, I don't see a problem. If you look through the Stored Procedure and UDF code, you'll be able to see all the references to objects in the master database.

RE: SQL 2000 DBA Toolkit Part 1

Anukul — Thu, 05 Apr 2007 18:02:00 GMT

Mike:I have created 2 of the other functions, in a specific database, in which I have to use the encryption. I modified these functions to lookup the master database for the extended functions and the Vault Tables.

All seem to work fine now. Do you think there may be any kind of problems later?-Anukul

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Thu, 05 Apr 2007 13:59:00 GMT

Extended Stored Procedures, by definition, can only be installed in the master database. The other functions, procedures, and tables can be modified to work from another database, but they must still have access to the extended procedures in the master database.

RE: SQL 2000 DBA Toolkit Part 1

Anukul — Thu, 05 Apr 2007 12:55:00 GMT

Mike:

Thanks for the response!So, can the whole set of procedures, extended procedures along with Key Vault tables be installed in one particular database in which this has to be used, instead of Master database?

Also, if thats possible, then these can be installed in each database where encryption is required (i know that may not be advisable). But still can that too be done?Let me know.Thanks,Anukul

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Wed, 04 Apr 2007 18:42:00 GMT

FYI to Everyone:edtited: Contact the webmaster for the source.Compilation of some partsrequires Boost Library source (in particular the Regular Expression extended procedures require Boost). Boost source is available for free download at http://www.boost.org/.If you do download and compile the source, I highly recommend downloading the latest Platform SDKfrom http://www.microsoft.com/downloads/details.aspx?FamilyId=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5&displaylang=en.I've also been asked several times about the license for this toolkit. Here it is:DBA Toolkit LicenseThe DBA Toolkit is composed of my original source code, and/or other source code that the original authors have placed in the public domain. Credit has been given throughout the source code to those original authors, and their original licensing agreements have been maintained in the source code where appropriate.You are free to usethis source code and binarieshowever you want, modify it however you like, anduse itfor any purpose you like, personal or commercial. All I ask is two things:1. If you redistribute the source code, modified or unmodified, give me a shout out in the comments or something 2. If you do something really cool and make big and/or useful improvements, consider sharing it with the rest of the world (this is not mandatory, but it is the nice thing to do). I'm particularly interested in the improvements people make to the source, and always appreciate the feedback.Obviously the Boost Library is covered by Boost's own licensing agreement which you will need to observe if you decide to use the portions of code that interface with it (the Regular Expression functionality). And Microsoft has their own licensing agreements you might need to review when before distributing programs compiled using the Platform SDK.

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Wed, 04 Apr 2007 18:02:00 GMT

The functions can be modified to run from a different database from master; however, I don't know that you will get much of a performance improvement because the key_vault tables and the extended procedures are in the master database. Because the functions call extended stored procedures, you cannot get away from accessing the master database.

RE: SQL 2000 DBA Toolkit Part 1

Anukul — Wed, 04 Apr 2007 17:23:00 GMT

Hi Mike!

I have been successfull in installing the ToolKit on SQL Server2000. Thanks for your help.

I observed that all the functions are installed in Master database, so all queries have to be executed in master taking the DB.dbo.tablename route. Can these functions also be installed in the respective database in which encryption/decryption has to be done?

That way, sql operations will become a lot easier and faster.

Please suggest.Thanks,Anukul

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Tue, 03 Apr 2007 19:14:00 GMT

Hi Anukul,

This particular issue is noted in the documentation. Usually it means that SQL Server could not load one of the supporting DLL's: MSVCR71.DLL or OPENDS60.DLL. The most likely reason is that one of them is not in the system path. Copy these two DLL files to the MSSQL\BINN directory and it should resolve the issue. There are more suggestions in the documentation.

Thanks

RE: SQL 2000 DBA Toolkit Part 1

Anukul — Tue, 03 Apr 2007 17:58:00 GMT

Hi Mike!

I am getting an error message while installing the DBA ToolKit for SQL 2000. Below is what I receive on executing the Install.sql script. Let me what I can do to correct this.------------------------------------------------------------------------****Starting Installation****----------------------------------------------------------------****Installing Key Management Extended Procedures**** Master Key**** Local Key****Creating Key Management Stored Procedures**** Master Key**** Local Key****Installing Cryptographic Extended Procedures**** ROT-13**** Triple DES (3DES)**** AES/Rijndael**** Twofish**** DES**** Blowfish****Installing Regular Expressions**** Search**** Split**** Match**** Replace****Installing Hash Function**** SHA(2)****Installing Conversion Routines**** Base64****Installing File Routines**** DirScan****Installing String/Phonetic Routines**** ProperCase**** Jaro-Winkler Edit Distance**** Levenshtein Edit Distance**** Double Metaphone**** NYSIIS**** Celko Improved Soundex**** Daitch-Mokotoff Soundex****Installing Calendar Functions**** Modulo**** Day of Week Occurrence**** Installing Easter Calculator**** Holiday Calculator****Installing Master Key VaultServer: Msg 515, Level 16, State 2, Line 1Cannot insert the value NULL into column 'Key', table 'master.dbo.Master_Key_Vault'; column does not allow nulls. INSERT fails.ODBC: Msg 0, Level 16, State 1Cannot load the DLL C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_create_master_key.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).Step 1. Searching for Master Key Vault in database. Master Key Vault already exists in this database. Skipping vault creation step.Step 2. Creating Master Key.The statement has been terminated. Problem adding master key Master Key 1. Stopping now.Step 3. Finished.****Installing Local Key VaultStep 1. Searching for Master Key Vault. Master Key Vault located in database.******* Could not locate Master Key 'Master Key 1'.****----------------------------------------------------------------****Install Complete------------------------------------------------------------------------Thanks!Anukul

RE: SQL 2000 DBA Toolkit Part 1

nicu paraschiv — Mon, 26 Mar 2007 07:40:00 GMT

Hi Mike, thank you so much.

I was able to get the source code from Steve in the meantime.

I will test the import/export code for the key container, I'll keep you posted.

Thanks again,

Nick

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Fri, 23 Mar 2007 20:30:00 GMT

Hi Nick,

I don't have much time to write a key container import/export program right now, but you might be able to use aspnet_regiis to export and import the key containers (see http://msdn2.microsoft.com/en-US/library/2w117ede.aspx). In .NET code you can use the System.Security.Cryptography namespace to import and export the appropriate information. Here's a sample in C# to steer you in the right direction (I did not thoroughly test this - this is just some starter code):

static void Export()

{

CspParameters cp = new CspParameters();

cp.KeyContainerName = "SCRYPTO";

RSACryptoServiceProvider rsa = new RSACryptoServiceProvider(cp);

RSAParameters p = rsa.ExportParameters(true);

XmlSerializer x = new XmlSerializer(typeof(RSAParameters));

MemoryStream ms = new MemoryStream();

x.Serialize(ms, p);

ms.Flush();

StreamWriter sw = new StreamWriter(@"c:\scrypto.params", false, Encoding.UTF8);

sw.Write(System.Text.Encoding.ASCII.GetString(ms.ToArray()));

sw.Close();

ms.Close();

}

static void Import()

{

CspParameters cp = new CspParameters();

cp.KeyContainerName = "SCRYPTO";

RSACryptoServiceProvider rsap = new RSACryptoServiceProvider(cp);

RSAParameters p = new RSAParameters();

XmlSerializer x = new XmlSerializer(typeof(RSAParameters));

Stream reader = new FileStream(@"c:\scrypto.params", FileMode.Open);

p = (RSAParameters)x.Deserialize(reader);

reader.Close();

rsap.ImportParameters(p);

}

To finish up, you'll want to back up the encrypted passwords used to encrypt keys and data in your database. Per the documentation, these are stored in the Local_Key_Vault and Master_Key_Vault tables in the master database.

I pulled out the source code and zipped it up, and I'll send it to you personally if you send me your email address.

Thanks

RE: SQL 2000 DBA Toolkit Part 1

nicu paraschiv — Fri, 23 Mar 2007 14:00:00 GMT

Hi Mike, I am still trying to figure out how to import/export the keys on a different machine; I am not very familiar with the terms and the CryptoAPI thing.

The whole issue comes from the fact that if you loose the machine, even if you re-install and restore the database, the encrypted information will be useless because the decryption is not working anymore, so there has to be a way of exporting the ...key, I guess??

If anybody on this forum has already figured out how to do this, please let me know, I would really appreciate it.

Thank you, Nick

RE: SQL 2000 DBA Toolkit Part 1

Mike C — Tue, 20 Mar 2007 09:38:00 GMT

I've sent the source code to Steve to post when he has an opportunity.