Gdtyjr

Animation: customize bounce interpolation

Showing mass murder in a kid's book

SOQL query causes internal Salesforce error

Identifying "long and narrow" polygons in with Postgis

How to leave product feedback on macOS?

What is the meaning of "You've never met a graph you didn't like?"

How would a solely written language work mechanically

Ways of geometrical multiplication

PTIJ: does fasting on Ta'anis Esther give us reward as if we celebrated 2 Purims? (similar to Yom Kippur)

What does the word 'upstream' mean in the context?

Proving a complicated language is not a CFL

How to make money from a browser who sees 5 seconds into the future of any web page?

Cumulative Sum using Java 8 stream API

If Captain Marvel (MCU) were to have a child with a human male, would the child be human or Kree?

Grepping string, but include all non-blank lines following each grep match

Possible Eco thriller, man invents a device to remove rain from glass

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Why is the sun approximated as a black body at ~ 5800 K?

What is the smallest number n> 5 so that 5 ^ n ends with "3125"?

Personal or impersonal in a technical resume

How to preserve electronics (computers, iPads and phones) for hundreds of years

Are Captain Marvel's powers affected by Thanos breaking the Tesseract and claiming the stone?

Check if object is null and return null

Determining multivariate least squares with constraint

How to I force windows to use a specific version of SQLCMD?

SQL Server 2008 upgrade advisor toolWill certain Database Compatibility cause performance degradation?SQL Server 2012 - The application has failed to start because its side-biy-side configuration is incorrectWhere is SQLCMD.EXE in SQL Server 2014 Express?Database backup over sqlcmd call from batch fileSecondary standby server log shipping backup job errorSQL Server Data Tools for VS 2015 - Anyone using for SSIS development to multiple versions?Issue installing SQL Server 2012 SP4 in a cluster - missing ‘vc_red.msi’SQL Server Data Collector Error - Server Activity Set Generates No OutputSQL Server Upgrading Compatibility Level from 2005 to 2012

2

I have several versions of SSMS installed on my machine. We have legacy servers running several versions of sql, 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 FilesMicrosoft SQL Server100ToolsBinn

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 FilesMicrosoft SQL Server110ToolsBinn

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?

sql-server sqlcmd command-line

share|improve this question

edited 21 mins ago

Solomon Rutzky

49.3k582179

asked 5 hours ago

Red_ShadowRed_Shadow

1134

New contributor

Red_Shadow is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

2

I have several versions of SSMS installed on my machine. We have legacy servers running several versions of sql, 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 FilesMicrosoft SQL Server100ToolsBinn

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 FilesMicrosoft SQL Server110ToolsBinn

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?

sql-server sqlcmd command-line

share|improve this question

edited 21 mins ago

Solomon Rutzky

49.3k582179

asked 5 hours ago

Red_ShadowRed_Shadow

1134

New contributor

Red_Shadow is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have several versions of SSMS installed on my machine. We have legacy servers running several versions of sql, 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 FilesMicrosoft SQL Server100ToolsBinn

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 FilesMicrosoft SQL Server110ToolsBinn

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?

sql-server sqlcmd command-line

share|improve this question

edited 21 mins ago

Solomon Rutzky

49.3k582179

asked 5 hours ago

Red_ShadowRed_Shadow

1134

New contributor

Red_Shadow is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 21 mins ago

Solomon Rutzky

49.3k582179

asked 5 hours ago

Red_ShadowRed_Shadow

1134

New contributor

Red_Shadow is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 21 mins ago

Solomon Rutzky

49.3k582179

asked 5 hours ago

Red_ShadowRed_Shadow

1134

New contributor

Red_Shadow is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 21 mins ago

Solomon Rutzky

49.3k582179

edited 21 mins ago

Solomon Rutzky

49.3k582179

asked 5 hours ago

Red_ShadowRed_Shadow

1134

New contributor

Red_Shadow is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 hours ago

Red_ShadowRed_Shadow

1134

1 Answer
1

active

oldest

votes

6

Have you tried updating the PATH variable?

For Windows 10, do the following:

1. In the File Explorer, right-click on This PC.




2. In the context menu, click Properties.




3. In the System window, click the Advanced system settings page on the left-hand side.




4. In the Advanced Tab, click on Environment Variables.




5. In the System Variables window, highlight Path, and click Edit.




6. In the Edit System Variables window, insert the cursor at the end of the Variable value field.




7. If the last character is not a semi-colon (;), add one.



8. 
   

   After the final semi-colon, type the full path to the file you want to find.

   
   
   
   • In your case: C:Program FilesMicrosoft SQL Server110ToolsBinn
   
   



9. Find the path with 100 in it, and then remove it.

Click OK in each open window.

Word of caution: After doing these steps, you will not be able to auto-find any other exe's that the system was able to find earlier in the older path you just removed.

share|improve this answer

answered 4 hours ago

GaganLambaGaganLamba

1124

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

Red_Shadow is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f232639%2fhow-to-i-force-windows-to-use-a-specific-version-of-sqlcmd%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

6

Have you tried updating the PATH variable?

For Windows 10, do the following:

1. In the File Explorer, right-click on This PC.




2. In the context menu, click Properties.




3. In the System window, click the Advanced system settings page on the left-hand side.




4. In the Advanced Tab, click on Environment Variables.




5. In the System Variables window, highlight Path, and click Edit.




6. In the Edit System Variables window, insert the cursor at the end of the Variable value field.




7. If the last character is not a semi-colon (;), add one.



8. 
   

   After the final semi-colon, type the full path to the file you want to find.

   
   
   
   • In your case: C:Program FilesMicrosoft SQL Server110ToolsBinn
   
   



9. Find the path with 100 in it, and then remove it.

Click OK in each open window.

Word of caution: After doing these steps, you will not be able to auto-find any other exe's that the system was able to find earlier in the older path you just removed.

share|improve this answer

answered 4 hours ago

GaganLambaGaganLamba

1124

add a comment | 

6

Have you tried updating the PATH variable?

For Windows 10, do the following:

1. In the File Explorer, right-click on This PC.




2. In the context menu, click Properties.




3. In the System window, click the Advanced system settings page on the left-hand side.




4. In the Advanced Tab, click on Environment Variables.




5. In the System Variables window, highlight Path, and click Edit.




6. In the Edit System Variables window, insert the cursor at the end of the Variable value field.




7. If the last character is not a semi-colon (;), add one.



8. 
   

   After the final semi-colon, type the full path to the file you want to find.

   
   
   
   • In your case: C:Program FilesMicrosoft SQL Server110ToolsBinn
   
   



9. Find the path with 100 in it, and then remove it.

Click OK in each open window.

Word of caution: After doing these steps, you will not be able to auto-find any other exe's that the system was able to find earlier in the older path you just removed.

share|improve this answer

answered 4 hours ago

GaganLambaGaganLamba

1124

add a comment | 

Have you tried updating the PATH variable?

For Windows 10, do the following:

1. In the File Explorer, right-click on This PC.




2. In the context menu, click Properties.




3. In the System window, click the Advanced system settings page on the left-hand side.




4. In the Advanced Tab, click on Environment Variables.




5. In the System Variables window, highlight Path, and click Edit.




6. In the Edit System Variables window, insert the cursor at the end of the Variable value field.




7. If the last character is not a semi-colon (;), add one.



8. 
   

   After the final semi-colon, type the full path to the file you want to find.

   
   
   
   • In your case: C:Program FilesMicrosoft SQL Server110ToolsBinn
   
   



9. Find the path with 100 in it, and then remove it.

Click OK in each open window.

Word of caution: After doing these steps, you will not be able to auto-find any other exe's that the system was able to find earlier in the older path you just removed.

share|improve this answer

answered 4 hours ago

GaganLambaGaganLamba

1124

share|improve this answer

answered 4 hours ago

GaganLambaGaganLamba

1124

answered 4 hours ago

GaganLambaGaganLamba

1124

answered 4 hours ago

GaganLambaGaganLamba

1124