Figure 1. Create Encryption-Related Objects With Batches.
The sample project's form creates the X.509 certificates, symmetric keys, asymmetric keys, and user accounts that are required to emulate production-grade SQL Server 2005 native encryption operations. The CreditCards test database contains 10,000 cleartext and ciphertext (encrypted) versions of fictitious 16-digit credit card numbers from four issuers—Visa, MasterCard, American Express, and Discover. The DataGridView displays properties of user, certificate, symmetric key, and asymmetric key objects in the test database. The database master key is a symmetric key.