---
product: Chilkat
product_version: 11.7.0
language: sqlserver
language_label: SQL Server
class: CertStore
license: free
deprecated: false
reference_html: https://www.chilkatsoft.com/refdoc/sqlserver_CertStoreRef.html
---
# Chilkat CertStore — SQL Server — v11.7.0

> Chilkat 11.7.0 · language=sqlserver · class=CertStore
> Other versions: replace `11.7.0` in this URL. Other languages: `https://www.chilkatsoft.com/ai-docs/v/11.7.0/<lang>/classes/CertStore.md`.
> Language-wide rules (install, unlock, error model, strings/bytes): `https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/guide.md`.

## Purpose

**Open, search, manage, and use certificate collections from many sources.**

`Chilkat.CertStore` is the Chilkat class for working with collections of X.509 certificates. It can open and manage certificates from system stores, Apple Keychain, Windows registry or file stores, memory stores, PEM files, PFX/P12 files, and smart card or USB token devices. It supports loading, searching, iterating, adding, removing, and closing certificate stores, with platform-specific behavior for Windows and Apple Keychain.

**Open certificate stores**

Access certificates from Windows certificate stores, Apple Keychain, files, memory stores, PEM bundles, PFX/P12 files, and hardware tokens.

**Search and retrieve certs**

Find certificates by subject, issuer, serial number, thumbprint, email, private-key availability, or other identifying information.

**Iterate collections**

Enumerate certificates in a store and retrieve each certificate as a `Chilkat.Cert` object for inspection or use.

**Add and remove certificates**

Add certificates to writable stores, remove certificates where supported, and manage store contents from application code.

**Private-key backed certs**

Work with certificates that have associated private keys from PFX/P12, operating-system stores, smart cards, USB tokens, or other providers.

**Use across Chilkat**

Pass retrieved certificates to other Chilkat classes for TLS client authentication, S/MIME, signing, encryption, decryption, and verification.

**Common pattern:** Open the appropriate certificate store, search or iterate to find the needed certificate, retrieve it as a `Chilkat.Cert`, and then pass that certificate to the Chilkat class that needs it. Use certificate stores when the application should select from existing system, file-based, keychain, or hardware-backed certificates.

For an extended overview, see [CertStore Class Overview](https://www.chilkatsoft.com/certstore_class_overview.asp).

## Object creation, unlocking and error handling

**Object Creation**

```sql
DECLARE @hr int
DECLARE @certStore int
EXEC @hr = sp_OACreate 'Chilkat.CertStore', @certStore OUT
IF @hr <> 0
BEGIN
    PRINT 'Failed to create ActiveX component'
    RETURN
END

-- ... use @certStore ...

EXEC @hr = sp_OADestroy @certStore
```

T-SQL uses the Chilkat ActiveX through the OLE Automation stored procedures. They must be enabled once on the server (`EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE;`), and the Chilkat ActiveX registered must match the bitness of the SQL Server instance (64-bit for a 64-bit SQL Server). To bind to a specific major version of Chilkat, append the major version number to the ProgID, such as `sp_OACreate 'Chilkat.CertStore.11'` for Chilkat v11.\*.\*.

`sp_OACreate` returns an object token (an `int`) that is passed as the first argument of every `sp_OAMethod`, `sp_OAGetProperty` and `sp_OASetProperty` call, and released with `sp_OADestroy`. Objects returned by methods (such as an `HttpResponse` or `JsonObject`) are also tokens received through an `int` OUT parameter; they must likewise be destroyed, and the OUT parameter is `NULL` when the method fails to return an object. Objects passed as arguments are passed by their token. When an OLE Automation procedure itself fails (non-zero `@hr`), `sp_OAGetErrorInfo` describes the error.

Data types: strings are `nvarchar(4000)`; integers, booleans (1 or 0) and object tokens are `int`; dates are `datetime`. In the signatures on this page, `@success`, `@iResult`, `@sResult` and the like are the OUT variables receiving a method's return value, `@iValue` / `@sValue` receive or supply a property value, and the remaining `@` variables are the method's arguments in order.

A string returned through an OUT parameter is limited to 4000 characters. For longer values, retrieve the result as a result set into a table variable instead of an OUT parameter, for example `DECLARE @tmp TABLE (outputLine ntext)` followed by `INSERT INTO @tmp EXEC sp_OAGetProperty @certStore, 'LastErrorText'`. See [string length limitations for strings returned by sp_OAMethod calls](https://www.chilkatsoft.com/sql_server_nvarchar_max_limitation.asp).

Methods that pass or return raw byte arrays are not shown on this page, because `varbinary(max)` values cannot be exchanged through `sp_OAMethod` (see [varbinary(max) limitation](https://www.chilkatsoft.com/sql_server_varbinary_max_limitation.asp)). Use the `BinData`-based alternatives (methods ending in *Bd*) or the base64 / hex string-encoded variants instead. Binary *properties* (such as `LastBinaryResult`) can be retrieved as a result set into a table variable, as shown in their signatures. Asynchronous (*\*Async*) methods and event callbacks are not available from SQL Server.

Call `Global.UnlockBundle` once at the start of the program, before using this or any other Chilkat class. Any string unlocks a fully functional 30-day trial; a purchased unlock code is used in production. See `guide.md` for the exact code in SQL Server.

How failure is reported depends on the method's return type and is stated in the note under each method below. In every case the diagnostic text is in the `LastErrorText` property of the object whose method was called.

## Members common to every Chilkat class

Documented once per language in `common-members.md`; listed here so this page is self-contained.

| Property | Signature | Access | Meaning |
|---|---|---|---|
| `DebugLogFilePath` | `EXEC sp_OAGetProperty @certStore, 'DebugLogFilePath', @sValue OUT EXEC sp_OASetProperty @certStore, 'DebugLogFilePath', @sValue` | read/write | If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. |
| `LastBinaryResult` | `INSERT INTO @tmp EXEC sp_OAGetProperty @certStore, 'LastBinaryResult'` | read-only | This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. |
| `LastErrorHtml` | `EXEC sp_OAGetProperty @certStore, 'LastErrorHtml', @sValue OUT` | read-only | Provides HTML-formatted information about the last called method or property. |
| `LastErrorText` | `EXEC sp_OAGetProperty @certStore, 'LastErrorText', @sValue OUT` | read-only | Provides plain text information about the last called method or property. |
| `LastErrorXml` | `EXEC sp_OAGetProperty @certStore, 'LastErrorXml', @sValue OUT` | read-only | Provides XML-formatted information about the last called method or property. |
| `LastMethodSuccess` | `EXEC sp_OAGetProperty @certStore, 'LastMethodSuccess', @iValue OUT EXEC sp_OASetProperty @certStore, 'LastMethodSuccess', @iValue` | read/write | Indicates the success or failure of the most recent method call: `1` means success, `0` means failure. |
| `LastStringResult` | `EXEC sp_OAGetProperty @certStore, 'LastStringResult', @sValue OUT` | read-only | In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. |
| `LastStringResultLen` | `EXEC sp_OAGetProperty @certStore, 'LastStringResultLen', @iValue OUT` | read-only | The length, in characters, of the string contained in the LastStringResult property. |
| `VerboseLogging` | `EXEC sp_OAGetProperty @certStore, 'VerboseLogging', @iValue OUT EXEC sp_OASetProperty @certStore, 'VerboseLogging', @iValue` | read/write | If set to `1`, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. |
| `Version` | `EXEC sp_OAGetProperty @certStore, 'Version', @sValue OUT` | read-only | Version of the component/library, such as "10.1.0" |

## Member index

| Member | Kind | Signature |
|---|---|---|
| `AvoidWindowsPkAccess` | property, read/write | `EXEC sp_OAGetProperty @certStore, 'AvoidWindowsPkAccess', @iValue OUT EXEC sp_OASetProperty @certStore, 'AvoidWindowsPkAccess', @iValue` |
| `NumCertificates` | property, read-only | `EXEC sp_OAGetProperty @certStore, 'NumCertificates', @iValue OUT` |
| `SmartCardPin` | property, read/write | `EXEC sp_OAGetProperty @certStore, 'SmartCardPin', @sValue OUT EXEC sp_OASetProperty @certStore, 'SmartCardPin', @sValue` |
| `UncommonOptions` | property, read/write | `EXEC sp_OAGetProperty @certStore, 'UncommonOptions', @sValue OUT EXEC sp_OASetProperty @certStore, 'UncommonOptions', @sValue` |
| `AddCertificate` | method | `EXEC sp_OAMethod @certStore, 'AddCertificate', @success OUT, @cert` |
| `CloseCertStore` | method | `EXEC sp_OAMethod @certStore, 'CloseCertStore', @success OUT` |
| `CreateFileStore` | method | `EXEC sp_OAMethod @certStore, 'CreateFileStore', @success OUT, @filename` |
| `CreateMemoryStore` | method | `EXEC sp_OAMethod @certStore, 'CreateMemoryStore', @success OUT` |
| `CreateRegistryStore` | method | `EXEC sp_OAMethod @certStore, 'CreateRegistryStore', @success OUT, @regRoot, @regPath` |
| `FindCert` | method | `EXEC sp_OAMethod @certStore, 'FindCert', @success OUT, @json, @cert` |
| `GetCert` | method | `EXEC sp_OAMethod @certStore, 'GetCert', @success OUT, @index, @cert` |
| `LoadPemFile` | method | `EXEC sp_OAMethod @certStore, 'LoadPemFile', @success OUT, @pemPath` |
| `LoadPemStr` | method | `EXEC sp_OAMethod @certStore, 'LoadPemStr', @success OUT, @pemString` |
| `LoadPfxBd` | method | `EXEC sp_OAMethod @certStore, 'LoadPfxBd', @success OUT, @bd, @password` |
| `LoadPfxFile` | method | `EXEC sp_OAMethod @certStore, 'LoadPfxFile', @success OUT, @pfxFilename, @password` |
| `OpenCurrentUserStore` | method | `EXEC sp_OAMethod @certStore, 'OpenCurrentUserStore', @success OUT, @bReadOnly` |
| `OpenFileStore` | method | `EXEC sp_OAMethod @certStore, 'OpenFileStore', @success OUT, @filename, @bReadOnly` |
| `OpenLocalSystemStore` | method | `EXEC sp_OAMethod @certStore, 'OpenLocalSystemStore', @success OUT, @bReadOnly` |
| `OpenOutlookStore` | method | `EXEC sp_OAMethod @certStore, 'OpenOutlookStore', @success OUT, @bReadOnly` |
| `OpenRegistryStore` | method | `EXEC sp_OAMethod @certStore, 'OpenRegistryStore', @success OUT, @regRoot, @regPath, @bReadOnly` |
| `OpenSmartcard` | method | `EXEC sp_OAMethod @certStore, 'OpenSmartcard', @success OUT, @csp` |
| `OpenWindowsStore` | method | `EXEC sp_OAMethod @certStore, 'OpenWindowsStore', @success OUT, @storeLocation, @storeName, @bReadOnly` |
| `RemoveCertificate` | method | `EXEC sp_OAMethod @certStore, 'RemoveCertificate', @success OUT, @cert` |

## Properties

### CertStore.AvoidWindowsPkAccess

`Chilkat 11.7.0 · sqlserver · CertStore · AvoidWindowsPkAccess · property · read/write`

```sql
EXEC sp_OAGetProperty @certStore, 'AvoidWindowsPkAccess', @iValue OUT
EXEC sp_OASetProperty @certStore, 'AvoidWindowsPkAccess', @iValue
```

Applies only when running on a Microsoft Windows operating system. If `1`, then any method that returns a certificate will not try to also access the associated private key, assuming one exists. This is useful if the certificate was installed with high-security such that a private key access would trigger the Windows OS to display a security warning dialog. The default value of this property is `0`.

### CertStore.NumCertificates

`Chilkat 11.7.0 · sqlserver · CertStore · NumCertificates · property · read-only`

```sql
EXEC sp_OAGetProperty @certStore, 'NumCertificates', @iValue OUT
```

The number of certificates held in the certificate store.

### CertStore.SmartCardPin

`Chilkat 11.7.0 · sqlserver · CertStore · SmartCardPin · property · read/write · since 9.5.0.86`

```sql
EXEC sp_OAGetProperty @certStore, 'SmartCardPin', @sValue OUT
EXEC sp_OASetProperty @certStore, 'SmartCardPin', @sValue
```

Can be set to the PIN value for a certificate / private key stored on a smart card.

### CertStore.UncommonOptions

`Chilkat 11.7.0 · sqlserver · CertStore · UncommonOptions · property · read/write · since 9.5.0.87`

```sql
EXEC sp_OAGetProperty @certStore, 'UncommonOptions', @sValue OUT
EXEC sp_OASetProperty @certStore, 'UncommonOptions', @sValue
```

This is a catch-all property to be used for uncommon needs. This property defaults to the empty string, and should typically remain empty.

## Methods

### CertStore.AddCertificate

`Chilkat 11.7.0 · sqlserver · CertStore · AddCertificate · method`

```sql
EXEC sp_OAMethod @certStore, 'AddCertificate', @success OUT, @cert
```

On Windows, this updates or adds `cert` to the open Windows certificate store. Note: This imports the certificate without the private key. The `Chilkat.Pfx.ImportToWindows` method must be called to import a certificate with a private key.

Beginning with Chilkat v10.0.0, on macOS and iOS, this adds the certificate, **including any private keys** and intermediate CA certificates, to the Apple Keychain.

Returns 1 for success, 0 for failure.

### CertStore.CloseCertStore

`Chilkat 11.7.0 · sqlserver · CertStore · CloseCertStore · method · since 9.5.0.94`

```sql
EXEC sp_OAMethod @certStore, 'CloseCertStore', @success OUT
```

This method closes any open certificate stores, removes all certificates from the object, and sets the NumCertificates property back to 0.

Returns 1 for success, 0 for failure.

### CertStore.CreateFileStore

`Chilkat 11.7.0 · sqlserver · CertStore · CreateFileStore · method`

```sql
EXEC sp_OAMethod @certStore, 'CreateFileStore', @success OUT, @filename
```

This method, **available only on Microsoft Windows**, creates a new file-based certificate store. You can save certificates to this store by using the AddCertificate function.

Internally, the Microsoft function CertOpenStore is called with the provider type CERT_STORE_PROV_FILE and the flag CERT_STORE_CREATE_NEW_FLAG, to create a new, empty certificate store that is backed by a file.

Returns 1 for success, 0 for failure.

### CertStore.CreateMemoryStore

`Chilkat 11.7.0 · sqlserver · CertStore · CreateMemoryStore · method`

```sql
EXEC sp_OAMethod @certStore, 'CreateMemoryStore', @success OUT
```

This method, **available only on Microsoft Windows**, creates an in-memory certificate store. Certificates may be added by calling AddCertificate.

Internally, the Microsoft function CertOpenStore is called with the provider type CERT_STORE_PROV_MEMORY to create a new in-memory certificate store. This store acts as a temporary container for managing certificates during runtime. The store exists only in memory and is not backed by a file or persistent storage. Certificates can be added, retrieved, or removed, but the store is lost when the application ends unless explicitly saved elsewhere.

Returns 1 for success, 0 for failure.

### CertStore.CreateRegistryStore

`Chilkat 11.7.0 · sqlserver · CertStore · CreateRegistryStore · method`

```sql
EXEC sp_OAMethod @certStore, 'CreateRegistryStore', @success OUT, @regRoot, @regPath
```

This method, **available only on Microsoft Windows**, creates a new registry-based certificate store. You can save certificates to this store by using the AddCertificate function.

Internally, the Microsoft function CertOpenStore is called with the provider type CERT_STORE_PROV_REG and a registry key to create a new, empty certificate store in the Windows registry.

`regRoot` can be the string `CurrentUser` or `LocalMachine`. `regPath` is a registry key path such as `Software/MyApplication/Certificates`.

Returns 1 for success, 0 for failure.

### CertStore.FindCert

`Chilkat 11.7.0 · sqlserver · CertStore · FindCert · method · since 10.1.2`

```sql
EXEC sp_OAMethod @certStore, 'FindCert', @success OUT, @json, @cert
```

Searches for a certificate using criteria from `json` and stores the result in `cert`. If multiple criteria are provided, it searches each one sequentially and returns the first match.

Preference is given to non-expired certificates, so if both expired and non-expired certificates match, the non-expired one is selected.

See the examples below for details.

Returns 1 for success, 0 for failure.

### CertStore.GetCert

`Chilkat 11.7.0 · sqlserver · CertStore · GetCert · method · since 10.1.2`

```sql
EXEC sp_OAMethod @certStore, 'GetCert', @success OUT, @index, @cert
```

Loads the Nth certificate into `cert`. The first certificate is at index 0.

Returns 1 for success, 0 for failure.

### CertStore.LoadPemFile

`Chilkat 11.7.0 · sqlserver · CertStore · LoadPemFile · method`

```sql
EXEC sp_OAMethod @certStore, 'LoadPemFile', @success OUT, @pemPath
```

Loads the certificates contained within a PEM formatted file.

Returns 1 for success, 0 for failure.

### CertStore.LoadPemStr

`Chilkat 11.7.0 · sqlserver · CertStore · LoadPemStr · method`

```sql
EXEC sp_OAMethod @certStore, 'LoadPemStr', @success OUT, @pemString
```

Loads the certificates contained within an in-memory PEM formatted string.

Returns 1 for success, 0 for failure.

### CertStore.LoadPfxBd

`Chilkat 11.7.0 · sqlserver · CertStore · LoadPfxBd · method · since 10.1.2`

```sql
EXEC sp_OAMethod @certStore, 'LoadPfxBd', @success OUT, @bd, @password
```

Loads the PFX/P12 bytes contained in `bd`. `password` is the password to the PFX.

Returns 1 for success, 0 for failure.

### CertStore.LoadPfxFile

`Chilkat 11.7.0 · sqlserver · CertStore · LoadPfxFile · method`

```sql
EXEC sp_OAMethod @certStore, 'LoadPfxFile', @success OUT, @pfxFilename, @password
```

Loads a PFX file. Once loaded, the certificates within the PFX may be searched via the Find\* methods. It is also possible to iterate from 0 to NumCertficates-1, calling GetCertificate for each index, to retrieve each certificate within the PFX.

**Note:** This method does not import certificates into the Windows certificate stores. The purpose of this method is to load a .pfx/.p12 into this object so that other API methods can be called to explore or search the contents of the PFX. The Chilkat Pfx class also provides similar functionality.

Returns 1 for success, 0 for failure.

### CertStore.OpenCurrentUserStore

`Chilkat 11.7.0 · sqlserver · CertStore · OpenCurrentUserStore · method`

```sql
EXEC sp_OAMethod @certStore, 'OpenCurrentUserStore', @success OUT, @bReadOnly
```

On Windows, this method opens the **Current-User\\Personal** certificate store in the registry. Set `bReadOnly` to `1` to open the store in read-only mode, which allows you to fetch certificates without adding or removing them. This prevents `permission denied` errors that require read-write access.

Starting in version 10.0.0, this method opens the **Apple Keychain** on MacOS and iOS systems. The `bReadOnly` is ignored.

After opening the store, you can search for certificates using the Find\* methods. Alternatively, you can iterate through the certificates by indexing from 0 to NumCertificates-1, using GetCertificate to access each one.

Returns 1 for success, 0 for failure.

### CertStore.OpenFileStore

`Chilkat 11.7.0 · sqlserver · CertStore · OpenFileStore · method`

```sql
EXEC sp_OAMethod @certStore, 'OpenFileStore', @success OUT, @filename, @bReadOnly
```

(This method only available on Microsoft Windows operating systems.)  
Opens a file-based certificate store.

Once loaded, the certificates within the store may be searched via the Find\* methods. An application may also iterate from 0 to NumCertficates-1 and call GetCertificate to access each certificate by index.

Returns 1 for success, 0 for failure.

### CertStore.OpenLocalSystemStore

`Chilkat 11.7.0 · sqlserver · CertStore · OpenLocalSystemStore · method`

```sql
EXEC sp_OAMethod @certStore, 'OpenLocalSystemStore', @success OUT, @bReadOnly
```

(This method is only available on Microsoft Windows operating systems.)  
Opens the registry-based Local-Computer\\Personal certificate store. Set `bReadOnly` = `1` if only fetching certificates and not updating the certificate store (i.e. certificates will not be added or removed). Setting `bReadOnly` = `1` causes the certificate store to be opened read-only, and will prevent `permission denied` errors caused by the need for read-write permission.

Once loaded, the certificates within the store may be searched via the Find\* methods. An application may also iterate from 0 to NumCertficates-1 and call GetCertificate to access each certificate by index.

Returns 1 for success, 0 for failure.

### CertStore.OpenOutlookStore

`Chilkat 11.7.0 · sqlserver · CertStore · OpenOutlookStore · method`

```sql
EXEC sp_OAMethod @certStore, 'OpenOutlookStore', @success OUT, @bReadOnly
```

(This method is only available on Microsoft Windows operating systems.)  
Opens the registry-based Current-User\\Other People certificate store. This is the certificate store use by Microsot Outlook. Set `bReadOnly` = `1` if only fetching certificates and not updating the certificate store (i.e. certificates will not be added or removed). Setting `bReadOnly` = `1` causes the certificate store to be opened read-only, and will prevent `permission denied` errors caused by the need for read-write permission.

Once loaded, the certificates within the store may be searched via the Find\* methods. An application may also iterate from 0 to NumCertficates-1 and call GetCertificate to access each certificate by index.

Returns 1 for success, 0 for failure.

### CertStore.OpenRegistryStore

`Chilkat 11.7.0 · sqlserver · CertStore · OpenRegistryStore · method`

```sql
EXEC sp_OAMethod @certStore, 'OpenRegistryStore', @success OUT, @regRoot, @regPath, @bReadOnly
```

(This method only available on Microsoft Windows operating systems.)  
Opens an arbitrary registry-based certificate store. `regRoot` must be `CurrentUser` or `LocalMachine`. `regPath` is a registry path such as `Software/MyApplication/Certificates`.

Setting `bReadOnly` = `1` causes the certificate store to be opened read-only, and will prevent `permission denied` errors caused by the need for read-write permission.

Once loaded, the certificates within the store may be searched via the Find\* methods. An application may also iterate from 0 to NumCertficates-1 and call GetCertificate to access each certificate by index.

Returns 1 for success, 0 for failure.

### CertStore.OpenSmartcard

`Chilkat 11.7.0 · sqlserver · CertStore · OpenSmartcard · method · since 10.1.2`

```sql
EXEC sp_OAMethod @certStore, 'OpenSmartcard', @success OUT, @csp
```

This function identifies connected HSM devices such as smart cards and USB tokens, and loads the certificates from each device. It has been significantly enhanced in Chilkat v10.1.2 and is compatible with Windows, MacOS, iOS, and Linux. (Android is not yet supported.)

Note: The `csp` is no longer used and is ignored. Applications should pass an empty string.

Note: If multiple HSM devices are connected, avoid setting the SmartCardPin property unless all devices share the same PIN. Otherwise, Chilkat will attempt to use that PIN for each device, which could cause issues.

Returns 1 for success, 0 for failure.

### CertStore.OpenWindowsStore

`Chilkat 11.7.0 · sqlserver · CertStore · OpenWindowsStore · method · since 9.5.0.49`

```sql
EXEC sp_OAMethod @certStore, 'OpenWindowsStore', @success OUT, @storeLocation, @storeName, @bReadOnly
```

(This method only available on Microsoft Windows operating systems.)  
Opens a Microsoft Windows certificate store. `storeLocation` must be `CurrentUser` or `LocalMachine`. `storeName` is the name of the certificate store to open. It may be any of the following:

- AddressBook: Certificate store for other users.
- AuthRoot: Certificate store for third-party certification authorities (CAs).
- CertificationAuthority: Certificate store for intermediate certification authorities (CAs).
- Disallowed: Certificate store for revoked certificates.
- My: Certificate store for personal certificates.
- Root: Certificate store for trusted root certification authorities (CAs).
- TrustedPeople: Certificate store for directly trusted people and resources.
- TrustedPublisher: Certificate store for directly trusted publishers.

Setting `bReadOnly` = `1` causes the certificate store to be opened read-only, and will prevent `permission denied` errors caused by the need for read-write permission.

Once loaded, the certificates within the store may be searched via the Find\* methods. An application may also iterate from 0 to NumCertficates-1 and call GetCertificate to access each certificate by index.

Returns 1 for success, 0 for failure.

### CertStore.RemoveCertificate

`Chilkat 11.7.0 · sqlserver · CertStore · RemoveCertificate · method`

```sql
EXEC sp_OAMethod @certStore, 'RemoveCertificate', @success OUT, @cert
```

(This method only available on Microsoft Windows operating systems.)  
Removes the passed certificate from the store. The certificate object passed as the argument can no longer be used once removed.

Returns 1 for success, 0 for failure.

## Related classes

[`BinData`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/BinData.md), [`Cert`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/Cert.md), [`JsonObject`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/JsonObject.md)

