SQL-DMO

Encrypted Property

The Encrypted property indicates whether the referenced stored procedure was created with encryption.

Applies To
ReplicationStoredProcedure2 Object UserDefinedFunction Object
StoredProcedure2 Object View2 Object
Trigger2 Object  

Syntax

object. Encrypted

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetEncrypted(LPBOOL pRetVal);

Remarks

The Encrypted property returns TRUE if a stored procedure was created with encryption. This is useful when determining whether a stored procedure can be replicated, because encrypted stored procedures cannot be replicated.

Note  Encrypted can be used with Microsoft® SQL Server™ 2000 and SQL Server version 7.0, except when used with the UserDefinedFunction object.