ISQL call problem

[Marcin Zmyslowski]

Hello everyone!

I have the following problem. I`ve opened a Query Analyser and write the
statement:

-isql -S 'PL6XXXX' -i 'd:\SQL_Server_2000\Raport_WWW.sql'

I got the following erorr message:

Incorrect syntax near -S

How to call the statement which is placed inside the 'Raport_WWW.sql'
file, which is located on folder D:\SQL_Server_2000??? Do I have to do
it in the cmd panel???

Thank you in advance for your help
Marcin from Poland

*** Sent via Developersdex http://www.developersdex.com ***

[Erland Sommarskog]

Marcin Zmyslowski (ma*****@kapy.bydg.pl) writes:

Hello everyone!

I have the following problem. I`ve opened a Query Analyser and write the
statement:

-isql -S 'PL6XXXX' -i 'd:\SQL_Server_2000\Raport_WWW.sql'

I got the following erorr message:

Incorrect syntax near -S

How to call the statement which is placed inside the 'Raport_WWW.sql'
file, which is located on folder D:\SQL_Server_2000??? Do I have to do
it in the cmd panel???

Yes, you must open a command-line window. Query Analyzer is for running
T-SQL commands. ISQL is a Windows program, and not an SQL command.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Kamyk]

Uzytkownik "Erland Sommarskog" <es****@sommarskog.se> napisal w wiadomosci
news:Xn********************@127.0.0.1...

Marcin Zmyslowski (ma*****@kapy.bydg.pl) writes:

Hello everyone!

I have the following problem. I`ve opened a Query Analyser and write the
statement:

-isql -S 'PL6XXXX' -i 'd:\SQL_Server_2000\Raport_WWW.sql'

I got the following erorr message:

Incorrect syntax near -S

How to call the statement which is placed inside the 'Raport_WWW.sql'
file, which is located on folder D:\SQL_Server_2000??? Do I have to do
it in the cmd panel???

Yes, you must open a command-line window. Query Analyzer is for running
T-SQL commands. ISQL is a Windows program, and not an SQL command.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

How would the statement look like if I would like to open run in in Query
Analyser??

Thank you very much for help
Marcin

[Stu]

Hey Marcin,

Let me see if I can clarify Erland's statement a bit: there are 3
client applications that you can use to run SQL commands against a SQL
server:

isql Utility
The isql utility allows you to enter Transact-SQL statements, system
procedures, and script files; and uses DB-Library to communicate with
Microsoft® SQL Server™ 2000.

The osql utility allows you to enter Transact-SQL statements, system
procedures, and script files. This utility uses ODBC to communicate
with the server.

The isqlw utility (SQL Query Analyzer) allows you to enter Transact-SQL
statements, system stored procedures, and script files. You can set up
shortcuts or create batch files to launch a preconfigured SQL Query
Analyzer.

isqlw (Query Analyzer) is most often run like a standard Windows app;
it has a GUI, which you are used to using to type in SQL statements;
the other two are run from a command prompt from windows, and can be
started up with a variety of options (including executing a .sql file).
If the SQL statements you want to run are located in a file
(Report_WWW.sql) that you want to execute using Query Analyzer's GUI,
you need to go to the File... Open... option on the menu and open the
file like you would any windows document. You can then run the file
using CTRL-E.

Does that make sense? Of course, given that you didn't know that
indicates that you probably are just starting out with Query Analyzer.
Be sure that you trust this SQL file that you are opening; you can do a
lot of nasty things with an unprotected SQL Server.

HTH,
Stu

[Erland Sommarskog]

Kamyk (ma**************@poczta.onet.pl) writes:

Uzytkownik "Erland Sommarskog" <es****@sommarskog.se> napisal w wiadomosci

I have the following problem. I`ve opened a Query Analyser and write the
statement:

-isql -S 'PL6XXXX' -i 'd:\SQL_Server_2000\Raport_WWW.sql'

I got the following erorr message:

Incorrect syntax near -S

How to call the statement which is placed inside the 'Raport_WWW.sql'
file, which is located on folder D:\SQL_Server_2000??? Do I have to do
it in the cmd panel???

Yes, you must open a command-line window. Query Analyzer is for running
T-SQL commands. ISQL is a Windows program, and not an SQL command.

How would the statement look like if I would like to open run in in Query
Analyser??

In addition to Stu's reply, you *can* invoke ISQL from SQL Server by running
xp_cmdshell:

EXEC master..xp_cmdshell
'-isql -S "PL6XXXX" -i "d:\SQL_Server_2000\Raport_WWW.sql"'

However, normally you need sysadmin rights to run xp_cmdshell. And,
the file path where would be on the machine on which SQL Server is
running, so if this file is on your workstation, ISQL would not find it.
Unless, that is, the SQL Server you are connecting to is on your on
workstation.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp