Re: ISQL call problem

Marcin Zmyslowski (marcinz@xxxxxxxxxxxx) 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, esquel@xxxxxxxxxxxxx

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

.

Relevant Pages

  • Re: User ID and Password in the Query
    ... Pro SQL Server 2000 Database Design - ... > How can I pass the user id and password in a simple SQL statement. ... I am logged into a database. ... Without logging into query analyser with his credentials(I had ...
    (microsoft.public.sqlserver.programming)
  • Re: VS.Net - Opening SQLS2k Stored Procedures in the IDE
    ... Yes I am using SQLS2k. ... I certainly can use Query Analyser, and it is local on this machine. ... > securing SQL Server objects. ... >>The stored procedure is opened in a text editor that you can use to ...
    (microsoft.public.dotnet.general)
  • Re: SQL server rename
    ... Execute a update statistics for all tables ... Execute a DBCC CHECKDB on the database and analyze the log ... > I had to rename the server that I am running sql server 2000 on. ... > If I use query analyser I can connect to the database no problem. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server/Access alternative?
    ... Sql Server CE is deployed in two cab files, ... and the other contains the dev tools - e.g. query analyser - so dont deploy ... > device's memory via ADO.NET recordset, and manipulating them in memory, ...
    (microsoft.public.pocketpc.developer)
  • Re: 2005 Setup Project: Installing SQL Server Express prerequisite with command line parameters
    ... Thanks, all I'm trying to do is get the bootstrap, which my set up ... to run the SQL Server Express setup file with the following ... command-line arguments: ...
    (microsoft.public.dotnet.languages.csharp)