Post reply

Command Line

  • February 12, 2008 at 11:18 pm

    #124013

    Hi,

    How to use the following command.. in sql server 2005..

    xp_cmdshell 'start iexplore http://www.google.co.oi'

    when i ren this it takes more time to execute ,but i am unable to get the explorer ,so please let me know is there any other way to achive this in sql server.. please help me out ..

    Thanks in Advance

  • February 12, 2008 at 11:22 pm

    #777693

    It runs on Virtual desktop which you would not be able to see..

    What exactly you want to achieve?

  • February 13, 2008 at 12:30 am

    #777698

    I am not getting your point ,if you could explain me more ,, then i am able to do so..

  • February 13, 2008 at 9:01 am

    #777896

    SQL Server is not interactive in nature means that you can't try to trigger a program from that. You will find that yor query executing without end result or you may get timed out error.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 14, 2008 at 7:39 am

    #778345

    You can find more information in this article: http://support.microsoft.com/kb/323411/en-us

  • February 14, 2008 at 12:41 pm

    #778548

    Sugesh Kumar R. MCDBA

    Theory is when you know something, but it doesn't work.

    Practice is when something works, but you don't know why.

    Programmers combine theory and practice: Nothing works and they don't know why.

    :)I LOVE IT:)

    A Programmer

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

  • February 14, 2008 at 12:46 pm

    #778549

    Hi,

    Where this statement is being invoked from?

    Meaning, are you in query analyzer or this statement is part of a function/sp?

    John Esraelo

    Cheers,
    John Esraelo

  • February 14, 2008 at 12:57 pm

    #778554

    Check your "task manager", sort the processes alpha, look for iExplore and you will see the multiple node of that running in the background.

    So, one of the responses to your question is valid. Those are running in a virutal mode.

    thx

    John Esraelo

    Cheers,
    John Esraelo

  • February 14, 2008 at 9:31 pm

    #778694

    You should be running this through a non-interactive interface. Executing IE in this manner does not work, as previously indicated. For instance, script the access using Perl or Powershell and execute the script.

    K. Brian Kelley
    @kbriankelley

  • February 14, 2008 at 9:42 pm

    #778699

    Thanks, for your reply. i understood the what is happening while execute that statement..

    thanks ,your replies are very informative

  • February 14, 2008 at 9:57 pm

    #778707

    Hi ,

    Please try this :

    exec master.dbo.xp_cmdshell 'mkdir "D:\temp"'

    exec master.dbo.xp_cmdshell 'dir "E:\"'

    Best Regards
    Faheem latif
    Senior Database Architect
    Genie Technologies (Pvt.) Ltd.

  • February 14, 2008 at 10:02 pm

    #778709

    faheemlatif (2/14/2008)

    Hi ,

    Please try this :

    exec master.dbo.xp_cmdshell 'mkdir "D:\temp"'

    exec master.dbo.xp_cmdshell 'dir "E:\"'

    If xp_cmdshell is enabled, these should work. But they don't require an interactive session, like what the poster was originally trying to do.

    K. Brian Kelley
    @kbriankelley

  • February 14, 2008 at 10:19 pm

    #778716

    Hi K. Brian Kelley,

    UR r8 ,one more thing i wanna add u can enable sheel option using.

    EXECUTE sp_configure 'show advanced options', 1

    RECONFIGURE WITH OVERRIDE

    GO

    EXECUTE sp_configure 'xp_cmdshell', '1'

    RECONFIGURE WITH OVERRIDE

    GO

    EXECUTE sp_configure 'show advanced options', 0

    RECONFIGURE WITH OVERRIDE

    GO

    Best Regards
    Faheem latif
    Senior Database Architect
    Genie Technologies (Pvt.) Ltd.

  • March 30, 2008 at 2:09 pm

    #795726

    faheemlatif (2/14/2008)

    Hi K. Brian Kelley,

    UR r8 ,one more thing i wanna add u can enable sheel option using.

    EXECUTE sp_configure 'show advanced options', 1

    RECONFIGURE WITH OVERRIDE

    GO

    EXECUTE sp_configure 'xp_cmdshell', '1'

    RECONFIGURE WITH OVERRIDE

    GO

    EXECUTE sp_configure 'show advanced options', 0

    RECONFIGURE WITH OVERRIDE

    GO

    Why do you want to do this?



    My blog

Viewing 14 posts - 1 through 13 (of 13 total)

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