I have several versions of SSMS installed on my machine. We have legacy servers running several versions of SQL Server, mainly 2008, 2012, and 2014. I use SQLCMD all the time, but it seems to default to the Version 10 version of the command.
C:\Program Files\Microsoft SQL Server\100\Tools\Binn
I need to use the one from the newer version for some of the new servers that don't have backwards compatibility enabled.
C:\Program Files\Microsoft SQL Server\110\Tools\Binn
What settings do I need to change so that I don't have to use the full path every time I want to use SQLCMD?