Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rme8494
Yak Posting Veteran
98 Posts |
 Posted - 2007-09-04 : 11:58:30
|
| Is it possible to create an RSS file from directly MS SQL 2005? I'd like to create a task to produce a file daily and place it on a web server.RyanRyan EverhartThe New AT&T |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-04 : 14:37:58
|
| no not really...you can have stored procedure returning xml when called like a web service but that's about it._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-09-04 : 14:51:09
|
| you have it backwards ... the web server, when the RSS feed is requested, should query the database, generate an XML file based on the data, and then return the resulting RSS file to the client. That is how it typically works. Generating RSS feeds is the task of a web application, not database code.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
rme8494
Yak Posting Veteran
98 Posts |
Posted - 2007-09-04 : 15:20:16
|
| Jeff,Thanks for the comment, you are very right. I'm just struggling with ASP.NET right now and was hoping to find an easier way to do it. I am a CF programmer by trade.RyanRyan EverhartThe New AT&T |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Create RSS Feed