executing script from file and redirecting to file

• mrsenthil

  SSC-Addicted

  Points: 471

  More actions

  October 10, 2002 at 1:09 pm

  #158206

  I Used

  isql -Sdevserver -Usa -P123YY -IC:\test.sql -OC:\a.out

  the test.sql contant is

  use testdb

  go

  select name from sysobjects where type = 'U'

  go

  Could some one help me PLEASE.

  THANKS IN ADVANCE

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  October 10, 2002 at 1:31 pm

  #438297

  Very close, try lower case -i, and lower case -o like this:

  isql -Sdevserver -Usa -P123YY -iC:\test.sql -oC:\a.out

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• mrsenthil

  SSC-Addicted

  Points: 471

  More actions

  October 10, 2002 at 1:38 pm

  #438298

  Thanks it works.