Re: Command Line & MS SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 03/10/04 

Date: Tue, 9 Mar 2004 23:21:51 -0500

You can create a script file (a .sql file) and then run it using the isql
command line utility. You can find more info about it in books online. 

-- 
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Noori" <noori@outgun.com> wrote in message
news:20040309193039.789$MQ@news.newsreader.com...
> After installing MS SQL Server, I would like to be able to create the
> database, user accounts and the tables without user interaction.  So, I
> thought of creating a batch file with the SQL commands that will run
> after installation of MS SQL Server but I didn’t find any helpful
> documentations.  I have used MySQL before and I am new to MS SQL server
> so I have few questions and any help will be helpful.  Is this the way
> is it suppose to be done or is there a better way?  Does anyone have
> examples of connecting to the MS SQL Server from command line?
>
> Thanks
>

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Report to display data from sql serv.
    ... IIF (case statements in SQL Server) scenarios etc. ... then you need to create a Stored Procedure in SQL Server and use that as ... at run time supplying the parameters in code by using the Exec command. ...
    (microsoft.public.access.reports)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot open SQL 2000 default database
    ... 1> EXEC sp_default 'mylogin', ... I have to type EXIT or type ctrl-C to get out of the SQL editor. ... error as I did before the error, as though I didn't type the command prompt ... I assume here that you run OSQL on the SQL Server machine itself, ...
    (microsoft.public.sqlserver.connect)