-- 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