TechNet
Export (0) Print
Expand All

StoredProcedure.Recompile Property

 

Gets or sets the Boolean property value that specifies whether the stored procedure is recompiled before execution.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design)]
public bool Recompile { get; set; }

Property Value

Type: System.Boolean

A Boolean value that specifies whether the stored procedure is recompiled before execution.

If True, the stored procedure is recompiled before every execution.

If False (default), the stored procedure is not recompiled.

Return to top
Show:
© 2016 Microsoft