Post reply

Run an SQL script file

  • August 16, 2011 at 8:59 am

    #148584

    Hi All

    How to run an SQL script file that is located on the disk, using T-SQL?:-D

    Jimmy
    PHP Programmer

  • August 16, 2011 at 9:49 am

    #1369156

    You'd have to use xp_cmdshell, so far as I know, to do that from an SQL script. Why not just run it more directly, with PowerShell, or whatever your preference is on that kind of thing? Why run a file from a T-SQL script?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply