Default path for ISQL

Posted on 2000-05-10
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?

Question by:Jsan

Expert Comment

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

Author Comment

ID: 2798607
Can I use a shortcut from a different folder?

Accepted Solution

manchula earned 50 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.

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

860 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