SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access

May 9, 2020

Recently I was working with a large organization on Comprehensive Database Performance Health Check and the DBA there asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access. He said he is reading my recent blog post series of oStress and load testing and realized that every single time when he has to access the utility he has to move to the installation folder of RML utility and he was wondering if there is any way there he can use them directly from the command prompt without changing to the directory.

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access addfolder-800x264

Let us learn about it today. It is a very easy trick and once implemented, you do not have to keep on changing the driver folder to access any application under that folder. You can easily do that by following the instructions here.

Press Windows Key >> Start Menu>> Search for ‘View Advanced System Settings’
Open the System Properties window >> Select “Environment Variables”
System Variable >> Select the variable PATH >> Click on Edit
Edit Environment Variables >> New
On the last line add the folder: C:\Program Files\Microsoft Corporation\RMLUtils\
Click On OK on Each Open Window

Now it is important to open a new Command Prompt to use the variable just added in the patch file. If you attempt to use it on the command prompt which is already open, it will not work.

Now let us see the entire tutorial with the help of the graphics over here.

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path1

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path2

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path3

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path4

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path5

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path6

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path7

SQL SERVER - Add Folder Paths to the Windows Path Variable for Easy Access path8

I hope this example helps you to understand how you can Add Folder Paths to the Windows Path Variable for Easy Access.

Here are a few blog posts where I have discussed oStress and Load Testing. If you are going to use oStress here are few blog posts which are related to that topic.

Reference: Pinal Dave (https://blog.sqlauthority.com)