<div>
You can use SQL server management studio, you just have you make sure that your SQL server allows remote connections and connect to that server from your management studio.
</div>


You can use SQL server management studio, you just have you make sure that your SQL server allows remote connections and connect to that server from your management studio.

<div>
I can't really pop open the studio and then paste in the query and then run it manually, it would have to be automatic. Could I schedule this from within Management Studio like you can with backups, etc. and have it run every day if I save the query as a .sql file?
</div>


I can't really pop open the studio and then paste in the query and then run it manually, it would have to be automatic. Could I schedule this from within Management Studio like you can with backups, etc. and have it run every day if I save the query as a .sql file?

<div>
You can create a SQL job to run a script on a schedule.<br />
<br />
Greg<br />
<br />

</div>


You can create a SQL job to run a script on a schedule.

Greg



<div>
that looks like what I'm looking for as far as specifying the file and output file, but how can I schedule that one to run at certain times?
</div>


that looks like what I'm looking for as far as specifying the file and output file, but how can I schedule that one to run at certain times?

<div>
forget I asked... :)<br />
<br />
I just put it in a batch file and then scheduled it and it was fine.<br />
<br />
Thanks.
</div>


forget I asked... :)

I just put it in a batch file and then scheduled it and it was fine.

Thanks.

<div>
<div class="content wysiwyg-content">
I haven't had any experience with this, but I have a SQL script that I need to run remotely on one of my SQL servers. How can I run this on the remote server? Is there a tool or something so I can save the file as an .sql file and then run it from my machine?
</div>
</div>


I haven't had any experience with this, but I have a SQL script that I need to run remotely on one of my SQL servers. How can I run this on the remote server? Is there a tool or something so I can save the file as an .sql file and then run it from my machine?

tool for running SQL script remotely...

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.