Hi Folks,
I am a SQL Server DBA but I am new to real TSQL programming. I have a question as explained below and any help (soon) will be appreciated.
I want to invoke a web page from within a TSQL code:
1) Is it possible to do this?
2) If yes, how?
3) Can I call a web page from command prompt?
Please help me on this - this is quite urgent for me.
Thanks a lot!
Astha1) I was able to invoke the webpage by typing this at the command prompt
c:\Program Files\Internet Explorer\iexplore.exe" http://www.google.com
however somehow the same not working when i tried it using xp_cmdshell ...
SQL gurus ... any ideas why ??|||Thanks Enigma :)
This really helped and was fine with what I needed. However, when running this from xp_cmdshell - I guess you should use with CMD .
Thanks again.
Astha
Showing posts with label tsql. Show all posts
Showing posts with label tsql. Show all posts
Friday, March 30, 2012
Friday, March 23, 2012
Last TSQL Command Batch
Does anyone know where Enterprise Manager (MSSQL 2000) gets the "Last TSQL Command Batch:" information from that shows when you display the properties for a process listed under current activity/Process Info for a server.
This could be useful for a bespoke system monitoring utility in my system.Google is your friend
http://www.developersdex.com/gurus/code/488.asp
This could be useful for a bespoke system monitoring utility in my system.Google is your friend
http://www.developersdex.com/gurus/code/488.asp
last tsql command
hi, how can i obtain the info of the last tsql command executed?, in the table sysprocess i only have the number of spid
thanks so much...have you tried double-clicking the spid in Enterprise Manager->Management->Current Activity->Process Info?
...might give you what you're looking for...|||hi, yes, but sql save it in someplace? i need to extract it to a table|||Not that I'm aware of, you'd have to run profiler to capture the sql (even then I am not sure you can save it to a table...)|||(even then I am not sure you can save it to a table...)Yes you can though MS recommend you write to a trace file and insert this into a table when you want to analyse. More efficient to write to a file at trace time basically.
HTH|||@.Mvrg76: Why have you opened a new thread?
See http://www.dbforums.com/showthread.php?t=1613810sql
thanks so much...have you tried double-clicking the spid in Enterprise Manager->Management->Current Activity->Process Info?
...might give you what you're looking for...|||hi, yes, but sql save it in someplace? i need to extract it to a table|||Not that I'm aware of, you'd have to run profiler to capture the sql (even then I am not sure you can save it to a table...)|||(even then I am not sure you can save it to a table...)Yes you can though MS recommend you write to a trace file and insert this into a table when you want to analyse. More efficient to write to a file at trace time basically.
HTH|||@.Mvrg76: Why have you opened a new thread?
See http://www.dbforums.com/showthread.php?t=1613810sql
Subscribe to:
Posts (Atom)