StoredProcedure.Startup Property

Gets or sets the Boolean property value that specifies whether the stored procedure runs when the instance of Microsoft SQL Server starts up.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property Startup As Boolean 
    Get 
    Set
'Usage
Dim instance As StoredProcedure 
Dim value As Boolean 

value = instance.Startup

instance.Startup = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool Startup { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool Startup {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member Startup : bool with get, set
function get Startup () : boolean 
function set Startup (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the stored procedure runs when the instance of SQL Server starts up.If True, the stored procedure runs at startup time.If False (default), the stored procedure does not run at startup time.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

StoredProcedure Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PROCEDURE (Transact-SQL)