Run File From Query Analyzer?

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  July 11, 2003 at 1:57 pm

  #83798

  Hi,

  Is there a way to open and run a file from within Query Analyzer?

  In Oracle, using SQL*Plus, the command is:

  SQL>run 'c:\myscript.sql' -- to open and run; no display

  or

  SQL>open 'c:\myscript.sql' -- to open; contents are displyed from file

  SQL>/ -- to run what is on screen

  Many thanks. Jeff

  Many thanks. Jeff

• Dale Corey

  SSCrazy Eights

  Points: 9019

  More actions

  July 11, 2003 at 2:38 pm

  #465189

  This topic has already been answered under another thread.

  
  All the best,
  
  Dale

  Author: An Introduction to SQL Server 2005 Management Studio

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  July 11, 2003 at 8:58 pm

  #465207

  See the replies in:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14107&FORUM_ID=5&CAT_ID=1&Topic_Title=Run+File+From+Query+Analyzer%3F&Forum_Title=Administration

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley