running external apps from sql server 2000?

  • Is there a way of running external apps from server 2000? Possibly using xp_cmdshell???


    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!

  • This was removed by the editor as SPAM

  • Yes, running xp_cmdshell will run external apps.

    Is there something specific that you are trying to do?

  • I have the following command:

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

    to run an application. when i execute it query analyser crashes. Any ideas why?

    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!

  • Hi Andrew,

    cross post?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • dont think so Frank! Do you have any ideas? Youve been my saviour! 😉

    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!

  • Hi Andrew,

    quote:


    dont think so Frank! Do you have any ideas? Youve been my saviour! 😉


    that was really a quick response!

    I still believe this thread looks VERY similar

    http://qa.sqlservercentral.com/forum/link.asp?TOPIC_ID=13895

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Forgot all about that one actually! anyway, still got the same problem, refiner.exe is installed on the server and no user input is required. Just cant seem to see what the problem is.

    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!

  • any ideas?

    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 9 posts - 1 through 8 (of 8 total)

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