Udostępnij za pośrednictwem


Encrypted Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object
.Encrypted

Parts

  • object
    An 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 knowledge 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 or later and SQL Server version 7.0, except if used with the UserDefinedFunction object.

Applies To:

ReplicationStoredProcedure2 Object

UserDefinedFunction Object

StoredProcedure2 Object

View2 Object

Trigger2 Object