EXEC my.sql

Question

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

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

Steve Jones - SSC Editor SSC Guru Points: 736188 More actions · Answer 1

what do you mean? run a filesytem .sql file from T-SQL? You can do this with isql and using xp_cmdshell.

Steve Jones

Undebtedly SSCrazy Points: 2938 More actions · Answer 2

Thanks, Steve, that's about what I needed:

EXEC master..xp_cmdshell 'osql -Smy_server -Umy_user -Pmy_password -imypath\myscript.sql -n'

The site where I found that appears to be gone, but it can still be found here:

Steve

Steve Miller