Open URL using t-sql code

Question

Open URL using t-sql code

pxt_ce

SSC Eights!

Points: 830
More actions
May 18, 2010 at 6:55 am

#386954

Hi All,
Urgent Help is required frmo Excellent Group.
I have one task in that i need to open URL every 60 Sec from server it self .. i have no permision to use XP_cmdshell system procedure.
is there any way that i can open URL from SQL Server ? ( NO DOS COMMAND ).
can i do same using SSIS Package?
plz help me...
Pd

Viewing 5 posts - 1 through 4 (of 4 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

What do you mean "open a URL"? When you put a URL in your browser, it gets a stream of HTML that it renders. What do you propose the server do with that stream?

There is a web service task in SSIS (http://msdn.microsoft.com/en-us/library/ms140114.aspx), but that is for a specific type of URL request.

Lowell SSC Guru Points: 323518 More actions · Answer 2

yeah i'm thinking TSQL/SQL Server might be the wrong tool for the task...you can do it, but it sounds like you just want a keep alive hitting your site...maybe your site's .NET and you want to get rid of the first time the code is called delay?

tell us why you want to hit the site every minute, there may be alternatives.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

enzotoc SSC Journeyman Points: 98 More actions · Answer 3

First of all, sorry for my english

but i have a good reason for open a link directly from t-sql query

Here the scenario

I have a query that lists the bugs from my mantis (do you know the bug tracker?), and the next field should be a link of my intranet that open the bug in a browser (eg. 'http://192.168.0.8/mantis/view.php?id=4085')

how can make ?

Thanks in advance

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

enzotoc (4/19/2011)
First of all, sorry for my english
but i have a good reason for open a link directly from t-sql query
Here the scenario
I have a query that lists the bugs from my mantis (do you know the bug tracker?), and the next field should be a link of my intranet that open the bug in a browser (eg. 'http://192.168.0.8/mantis/view.php?id=4085')
how can make ?
Thanks in advance

I still don't understand. sql is not a browser. An html request gets a stream of data and presents it somewhere. Are you just trying to have sql generate the link based on some table values?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/