Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Default path for ISQL

Posted on 2000-05-10
3
Medium Priority
?
1,185 Views
Last Modified: 2012-08-13
I have just started using SQL server a few weeks ago.  How can I set the default path in ISQL for scripts?  Every time I go to open a script it defaults to C:\mssql\binn  I keep my scripts in a different folder, how can I change this default?  A registry setting or something?

Jsan
0
Comment
Question by:Jsan
3 Comments
 
LVL 8

Expert Comment

by:chigrik
ID: 2798551
You can not change this :(
ISQL always uses by default the directory ISQL was run from.
0
 
LVL 1

Author Comment

by:Jsan
ID: 2798607
Can I use a shortcut from a different folder?
0
 
LVL 1

Accepted Solution

by:
manchula earned 150 total points
ID: 2798666
Run isql from the folder, where you have the script files. You need not have to give path for either the isql exe file, or for your script files.

(When you install SQL Server, automatically, its Binn directory will be added to the Path variable.)

Hope this helps you.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question