possible? shell command across network via stored procedure

• John_J

  Ten Centuries

  Points: 1190

  More actions

  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.

• Dave-151643

  SSC Veteran

  Points: 215

  More actions

  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.

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  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