Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Running Script without Interface

Author  Topic 

suchiate
Starting Member

33 Posts

Posted - 2007-04-13 : 03:49:24
Hey guys,

May I know how I can run a SQL Script without Enterprise Manager or Query Analyzer? Or is there any way to install back the GUI without stopping the services? Thanks alot in advance.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-13 : 04:13:37
You need to have client tools installed on your machine to access the SQL Server (if your SQL Server is located on another machine) If you don't want GUI, you can run your scripts through osql utility.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

craig79
Starting Member

33 Posts

Posted - 2007-04-18 : 03:00:00
U can use osql option...

osql -E -Sservername -i Scriptfile path -o outputfile path
Go to Top of Page
   

- Advertisement -