how to run sql script

• Burak-230806

  Valued Member

  Points: 74

  More actions

  October 26, 2005 at 6:04 am

  #166424

  i have an sql script(.sql format) and i want to run it on my remote host which support mssql server..

  sql script includes creating tables and somthng like this..

  how can i do this please show me a way..

  thanks

• Kory Becker

  Hall of Fame

  Points: 3585

  More actions

  October 26, 2005 at 12:23 pm

  #600345

  isql -Uusername -Sservername -iscript.sql -oscript.out

  Query Analyzer

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  October 26, 2005 at 7:58 pm

  #600440

  In addition to those two (and osql), you can also use VBScript which can use SQL-DMO and fire off SQL scripts after getting the input such as instance-name, authentication used (login and password if SQL Server authentication is used), database name etc.

• Mark Hickin

  Say Hey Kid

  Points: 693

  More actions

  October 28, 2005 at 8:07 am

  #600918

  Or just open Query Analyzer, connect to the remote server, open the file, select the correct database, and then hit F5.