Home Forums Article Discussions Article Discussions by Author Discuss content posted by wfvdijk usp_createsnapshot RE: usp_createsnapshot

  • July 14, 2008 at 6:17 am

    #842316

    Try this key:

    Set@RegPath = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @SQLInstance + '\Setup'

    EXECmaster..xp_regread 'HKEY_LOCAL_MACHINE', @RegPath, 'SQLDataRoot', @value=@DataPath OUTPUT

    Wilfred
    The best things in life are the simple things