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...

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...

Here is a stored procedure to ftp files using SQL Server stored procedure:

Create proc up_FTPPushFile

@file_to_push varchar(255),

@ftp_to_server varchar(255),

@ftp_login varchar(255),

@ftp_pwd varchar(255)

as

Set Nocount On

--STEP 0

--Ensure we can find the file...

It is possible to store the connection string into the Windows registry.

To extract the value from the registry using VBScript:

Dim strConn, ShellObject

Set ShellObject = WScript.CreateObject("WScript.Shell")

strConn = ShellObject.RegRead("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup\SQLPath")

Set ShellObject =...