DECLARE @DataPath nvarchar( 512 ) , @SQLPath nvarchar( 512 ) ,
        @ToolsPath nvarchar( 512 ) , @CmdStr nvarchar( 4000 );
EXECUTE dbo.sp_MSgettools_path @ToolsPath OUT;
EXECUTE sp_MSget_setup_paths @SQLPath OUT , @DataPath OUT;
PRINT 'SQLPath   : ' + QUOTENAME( @SQLPath , '"');
PRINT 'DataPath  : ' + QUOTENAME( @DataPath , '"');
PRINT 'ToolsPath : ' + QUOTENAME( @ToolsPath , '"');
SET @CmdStr = QUOTENAME( @ToolsPath + '\BINN\OSQL', '"') + ' -L'
PRINT 'CMDStr    : ' + @CmdStr
EXECUTE master..xp_cmdshell @CmdStr
GO

This page was last updated on May 01, 2006 04:28 PM.