DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Running a script remotely

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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

  2. #2
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    As long as you can see host2 from your Network, you can do :

    sql>@\\host2\temp\myscript.sql;
    If there is no solution, it is because there is no problem - Shadok -

  3. #3
    Join Date
    Jul 2000
    Posts
    521
    Can you make that as a stored proc ?
    svk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width