February 13, 2008 at 7:03 am
Hi ,
I want to use the following command to open my internet explorer..
from sql server ,for which i have used the following command.
xp_cmdshell 'start iexplore http://www.google.co.in'
when i run this from sql server is displaying NULL.
from command prompt i am getting the explorer..open with mentioned web page...
please help me to achive this task..
i am not concern about any security and performance issue..
please provide me a solution as soon as possible,realy this is urgent for me,,
Thanks in Advance..
February 13, 2008 at 7:27 am
xp_cmdshell doesn't work for those kinds of things. It's designed to run/process non-interactive commands from the OS. It's not going to spawn windows, open up documents for you to modify, etc... That's not part of what it's permitted to do.
you're going to need something external to do that.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 13, 2008 at 7:32 am
Of course - the SQLCMD utility MIGHT do what you want....
http://msdn2.microsoft.com/en-us/library/ms162773.aspx
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 17, 2008 at 7:31 am
Hi,I'm a new one here.
I need the command the same to you.Did solve it?
there is no response,I've been pullzed for a long time.
Can anyone help me?
Thanks very much.
February 18, 2008 at 2:03 am
I'm sure that there is an easy way of doing what you are trying to do, but I haven't a clue as to what it is. Why not explaiin what the problem is rather than your attempt at a solution. Starting up IE in the server room isn't going to help anyone. It is easy, for example to get Google data into a database- there are a variety of ways of doing it. (CURL.EXE, operated via xp_CMDShell is a wonderful tool)
Best wishes,
Phil Factor
February 18, 2008 at 10:34 pm
"You can execute operating system commands with SQLCMD Mode. Take care not to execute statements that prompt for a response. It is not possible to interact with the connection to respond to the request, and the query will continue to execute until canceled. For more information, see Editing SQLCMD Scripts with Query Editor."
SQL Server 2005 Books Online (September 2007)
SQL Server Management Studio Transact SQL Query
John Esraelo
Cheers,
John Esraelo
February 20, 2008 at 3:11 am
Perhaps, you can use a job in SQL Server Agent.
If you use XP System, another solution is a programmable task.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply