Running a script remotely

Hi,
Is it possible to execute a script which is present on Remote machine.
form the sql prompt.

Say a file called create_table.sql is present on machine HOST2; i want to execute this script from the SQL prompt in a different machine in windows environment.

sql>@
How do i give the path for the same

As long as you can see host2 from your Network, you can do :

sql>@\\host2\temp\myscript.sql;

Can you make that as a stored proc ?