How do I executing a .SQL file from a specific PC
Posted on 2015-01-23
I have a .SQL query that queries a couple of tables and emails the results to an email address. This works fine from within SQL Management Studio 2012.
I have saved this query as a .SQL file and would like to run it from a specific workstation on our domain.
What is the best way to go about this? VBS, BAT, another?
Also what security rights will the end user/Station need in order to run this command and will they also need the Management Tools installed so that they can run SQLCMD.exe?
Many thanks in advance.