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.