Writing script

• Ernesto_noble

  Newbie

  Points: 3

  More actions

  July 3, 2013 at 9:00 am

  #295293

  I need to add a script so that my system will pull a word document using a program I have. Can I write the script in notepad and save it as "xxx.sql" and then just save it the the fold that houses the doc? I already have the script written out.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734522

  More actions

  July 3, 2013 at 9:19 am

  #1629575

  How will you run it?

  You could schedule it with SQL Agent, but the Agent would need to be able to access the folder.

  It doesn't matter how you write a SQL script. It's just text. It can be written in notepad and saved, and in SSMS, you can open any file that's text.