Execute T-SQL file in osql

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  January 24, 2008 at 8:01 am

  #120130

  Hello, is there a way to execute a T-SQL file that is stored on my computer from with in osql? In Oracle once you have logged into the database you just use the @ sign followed by the file name and it will execute. Is there an equivalent to this in SQL Server?

  Thank you.

  David

  Best Regards,

  ~David

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736193

  More actions

  January 24, 2008 at 9:22 am

  #771358

  You need shell access, xp_cmdshell, or use a job and give rights to start the job.

  I'd actually set up a job to check a small table, look for 1 , if it's there, run the script. If not, don't.

  Then let the user insert a 1 if they need the script run.