Hi Group,

I'm new to Ms SQL Server 2000 world. I already have the script files having extention as .sql with me.

Can anyone help me telling how to run(execute) a script(.sql) file for creating a database along with tables in Microsoft SQL Server 2000.

The script files were downloaded from wrox.com related to the book of Rob Vieira called "Professional SQL Server 2000 Programming".

Awaiting a quick help by some member of the group.

Prethank to all of you.

Aaarkaycee



skbshd

Hi!

I do not find any specific method to run a .sql file that just double click and you execute it. Although you can use the osql utility to execute a file.

To do this -
[1] Create a File (may be any extension)
[2] I take example of file whose content is like this -
------
Use master
go
Select name from sysdatabases
go
-----
[3] You can run this file as input parameter of osql.exe. If you are new to SQL Server, I must tell you that osql.exe path is already set.

In command line, or any other execution method, you can type -
  osql -Usa -Ppassword -i file1.sql

password is your password and file1.sql is the file which we want to execute.

Reply me if this helps. If I did not understand you, tell me the scenario in detail.

Bye!

- Som Dutt

Hi SomDutt,

thanks a lot for your valuable gauidence on the topic. I tried executing the script using OSQL.EXE without using any parameters. Though it got executed but the database & tables were not created as expected. May be coz it asked me user & password which I don't know & neither I know how to find out them.

At last I could run that script using profiler menu option File -> Open-> SQL Script at last. Though it gave me problems for first 2-3 times & also produced an internal error related to database connection on first line itself. But somehow it created the database & tables.

On excution of above menu command it opens a open file dialog to select the script file. On selection of script file it displays two windows, one shows the contents of the script file in tabular form. The two columns read as EventClass & TextData. And the other window shows the contents of TextData of the first row. When I click ToolBar button Execute one step, it opens a dialog box called Connect to SQL Server which shows a dot in a drop down list box against label reads as sql server & Windows Authentication radio button selected. When I click Ok button of this dialog it shows dialong called Replay SQL Server. When I press Start Button of this dialog then it closes the opened dialog and creates one more window in profiler's screen having a table with same two columns as EventClass & TextData. The first column of row shows Replay Internal Error and the second column shows description as No matching connection to execute this on Will auto-create one. I don't know its meaning & the cause due to which it is created. Then I keep pressing the same toolbar button to execute the entire script step by step.

This is the exact explanation of my problem. Since I'm new to this forum so I face problems to get back to my topic & replies I got from users of this forums. So I request you to post me the solution on my following email-id [email protected]

Tnaks a lot to you once again,

bye

skbshd

Hi Ramakant!

Actually, everything depends upon you installation. If you chose mixed mode installation, you may have sa as User and Password which you provide at the same time. If you have windows authentication mode, you can execute it with -Usa without -P option, but, -i option must be there.

You are using SQL Profiler and SQL Profile is not meant to run queries. SQL Profile is to monitor the server. It traces events and other factors.

If you want to execute SQL commands, you need to follow - Query Analyzer or ISQL/OSQL. Query Analyzer is GUI based that is isqlw.exe. You can use -

 isqlw -Usa -P -i file1.sql


In Query Analyzer, you will find a window with a dot in a combo box (as you wrote). Just press OK button.

In Query Analyzer Menu goto File > Open to open .sql file and then press F5. If you have problems executing query analyzer, ask about that.

I replied you to follow OSQL with -i (input file) switch because, you can use it easily and get to work with your SQL Server database.

I hope you must have got the point. Reply if problem not solved yet.

Bye!

THROUGH QUERY ANALYZER OPEN YOUR SCRIPT IN EDITOR AND CLICK EXECUTE
JUST
HAVE ANICE TIME

you must install microSoft SQL Server 2005 in your system.