Post reply

possible? shell command across network via stored procedure

  • December 17, 2004 at 1:29 pm

    #162870

    I am looking for something along the lines of xp_cmdshell that would execute on a system across a network. Is this available/possible? I need to execute a script (VB)on another machine based on a table trigger. Any help or direction is appreciated.

  • December 19, 2004 at 9:05 pm

    #534419

    You can call xp_cmdshell from SQL Server using t-sql, so you should be ble to do what you want. Look in books on-line for how to do this 

    Permissions I think will be an issue.

  • December 21, 2004 at 7:44 pm

    #534705

    John, if you have the Windows Resource Kit then try using rcmd along with xp_cmdshell. Please note that the machine in which the vbs script resides MUST have Remote Command Service running. As an example:

    exec master..xp_cmdshell "path-to-rcmd\rcmd \\server_name <command>"

    DAB

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

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