xp_cmdshell

  • To anyone that can help...

    We have a problem when trying to execute an .exe file using xp_cmdshell:

    exec master.. xp_cmdshell 'c:\pcplus\refiner.exe'

    Query analyzer seems to run the query with no problems, returning a value NULL but nothing else. It doesnt seem to run the file but doesnt return any errors either..any ideas as to why?????

    Thanks

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • The NULL value, is that the integer code coming back or what's in the temporary table from the execution of xp_cmdshell?

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    K. Brian Kelley
    @kbriankelley

  • Dunno mate,I presume its whats in the temp table...

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

    [/quote]

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

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

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