Hcfyk

Can I equip Skullclamp on a creature I am sacrificing?

My Curious Music Box

How should I support this large drywall patch?

How to make a variable always equal to the result of some calculations?

If the heap is initialized for security, then why is the stack uninitialized?

How to write the block matrix in LaTex?

How do I construct this japanese bowl?

Only print output after finding pattern

Different harmonic changes implied by a simple descending scale

Was a professor correct to chastise me for writing "Prof. X" rather than "Professor X"?

Burial of a convert out of Judaism

How do we know the LHC results are robust?

How long to clear the 'suck zone' of a turbofan after start is initiated?

Can we say or write : "No, it'sn't"?

How do you know when two objects are so called entangled?

Science fiction short story involving a paper written by a schizophrenic

How to subset dataframe based on a "not equal to" criteria applied to a large number of columns?

Is it ever safe to open a suspicious html file (e.g. email attachment)?

Indicator light circuit

WOW air has ceased operation, can I get my tickets refunded?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

"and that skill is always a class skill for you" - does "always" have any meaning in Pathfinder?

Trouble understanding the speech of overseas colleagues

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

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

2

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 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 Mar 21 at 13:19

mustaccio

9,88172238

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

add a comment | 

2

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 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 Mar 21 at 13:19

mustaccio

9,88172238

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

add a comment | 

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 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 Mar 21 at 13:19

mustaccio

9,88172238

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

share|improve this question

edited Mar 21 at 13:19

mustaccio

9,88172238

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

share|improve this question

edited Mar 21 at 13:19

mustaccio

9,88172238

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

edited Mar 21 at 13:19

mustaccio

9,88172238

edited Mar 21 at 13:19

mustaccio

9,88172238

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

asked Mar 20 at 17:37

Red_ShadowRed_Shadow

1134

1 Answer
1

active

oldest

votes

8

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 Mar 20 at 18:07

GaganLambaGaganLamba

1384

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
);



);

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-do-i-force-windows-to-use-a-specific-version-of-sqlcmd%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

8

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 Mar 20 at 18:07

GaganLambaGaganLamba

1384

add a comment | 

8

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 Mar 20 at 18:07

GaganLambaGaganLamba

1384

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 Mar 20 at 18:07

GaganLambaGaganLamba

1384

share|improve this answer

answered Mar 20 at 18:07

GaganLambaGaganLamba

1384

answered Mar 20 at 18:07

GaganLambaGaganLamba

1384

answered Mar 20 at 18:07

GaganLambaGaganLamba

1384