USP_DATAFORMTEMPLATE_VIEW_DATABASESETUPCOMPLETED

The load procedure used by the view dataform template "Database Setup Completed View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DATABASESETUPCOMPLETED	bit	INOUT	DATABASESETUPCOMPLETED

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DATABASESETUPCOMPLETED
(
    @DATALOADED bit = 0 output,
    @DATABASESETUPCOMPLETED bit = null output
)
with execute as owner
as
    set nocount on;

    set @DATALOADED = 0;

    if (select value from fn_listextendedproperty(N'Hosting_DatabaseSetupCompleted', default, default, default, default, default, default)) is null
        exec sp_addextendedproperty @name = N'Hosting_DatabaseSetupCompleted', @value = 0

    select 
        @DATALOADED = 1,
        @DATABASESETUPCOMPLETED = convert(bit, VALUE)   
    from 
        fn_listextendedproperty(N'Hosting_DatabaseSetupCompleted', default, default, default, default, default, default);