-- Name: sp_MSget_setup_paths

-- Descriptions:

-- Parameters: as defined in create statement

-- Returns: 0 - success
--          1 - Otherwise

-- Security:
-- Requires Certificate signature for catalog access

create procedure sys.sp_MSget_setup_paths (
@sql_path    NVARCHAR(260) = NULL OUTPUT,
@data_path    NVARCHAR(260) = NULL OUTPUT )
AS
BEGIN

    DECLARE @retcode INTEGER
    DECLARE @regkey NVARCHAR(260)

    SET NOCOUNT ON

    EXECUTE @retcode = master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE',
        'SOFTWARE\Microsoft\MSSQLServer\Setup',
        'SQLPath',
        @param = @sql_path OUTPUT

    IF ( @retcode <> 0 ) or ( @@ERROR <> 0 )
        RETURN (1)

    EXECUTE @retcode = master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE',
        'SOFTWARE\Microsoft\MSSQLServer\Setup',
        'SQLDataRoot',
        @param = @data_path OUTPUT

    IF ( @retcode <> 0 ) or ( @@ERROR <> 0 )
        RETURN (1)

    RETURN (0)

END