Results 1 to 5 of 5

Thread: Stored Procedure with xp_cmdshell

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Stored Procedure with xp_cmdshell

    I have a simple problem....

    I am writing a stored procedure I want to use xp_cmdshell to execute a executable file...

    Exec master..xp_cmdshell 'C:\snort.exe', NO_OUTPUT

    Nothing happens....how do I write this so it starts that program?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    I think it runs in background.

  3. #3
    Join Date
    Apr 2003
    Posts
    2

    PRocess not active

    I dont see the process running..

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can you run the exe without any problem from the command prompt?. Does it wait for you to hit any key?. The program may be waiting for user intervention.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    try putting that .exe in a batch file in the server and run it.

Posting Permissions

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