Generating RSS Feed from Sql Server 2005

Hi every one

I want to generate a RSS Feed from SQL Server 2005.

The scenario is that when a record is entered in the database, the database fire a trigger which generate rss feed for the new record entered in the data base

Thanx in advance

Take care

Bye

I don't quite understand why you want to use trigger to generate the RSS. You can use SQL query to generate RSS like formatted data and show it to the end user. So every time the link on which you are showing the records gets refreshed, the sql query/procedure will get executed, and the RSS format XML data will be generated. All, you'll have to do is to through the result of the query/procedure as response.

For example, visit below link. It is actually a .aspx page where the coder has done exactly what I'm talking about.

http://www.codeproject.com/webservices/articlerss.aspx?cat=3

Hope this will help.

|||

Would your best bet not be to write a page in ASP.net that generates the RSS by pulling the data from the SQL server whenever the page is called? This could then act as your trigger.

|||

Thanx for ur response

|||

Hi

Thanx 4 ur response

I think i did not convey my message rightly.

I have to generate the xml file when the record is updated in the database using trigger. i don't want to query the database directly from the application.

Waiting 4 ur response

Take Care

Bye

|||

Well, I'm still not convinced why you want to go the XML generation way. If you setup your RSS according to my previous post, you are at least worry whether new record is inserted or any record is updated.

Still, if you want to go for the trigger and xml generation way, then I think you'll have to dig down XML generation functions of SQL. Moreover, as you are also going to do IO operations in you SQL trigger, the path of the file and access permissions and so many other things should be taken care of. One way you can use is the CLR Integration. See if below link is useful:

http://www.sqldbatips.com/showarticle.asp?ID=23

Generating a personalised report for every vendor and mailing out the same

I have the following reporting scenario.
I have a table which contains a list of customers/vendors and each
record in this table as the customer/vendor number, name and email
address of the vendor and also the record as the value of the business
done by the vendor/customer for this month, year to date, last
year,etc our business wants us to generate a report for each
customer/vendor from this table and email the resulting output in a
.pdf report to the email address on this record. It is almost like the
account statement for each customer or vendor for that month.
Please clarify how I can implement this solution with DTS. I can see a
stored procedure can go through all the customers but how do I
generate the statement for each customer into a .pdf output and then
email that file to that vendor/customers email address from SQL+DTS
Thanks
KarenKaren
Start with www.sqldts.com
declare @.sql varchar(255)
set @.sql='bcp "select * FROM northwind.dbo.orders WHERE employeeid = 1"
queryout "c:\temp\1.csv" -c -T -SSERVER -Usa -Ppass'
exec master..xp_cmdshell @.sql
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504111747.90b8491@.posting.google.com...
> I have the following reporting scenario.
> I have a table which contains a list of customers/vendors and each
> record in this table as the customer/vendor number, name and email
> address of the vendor and also the record as the value of the business
> done by the vendor/customer for this month, year to date, last
> year,etc our business wants us to generate a report for each
> customer/vendor from this table and email the resulting output in a
> .pdf report to the email address on this record. It is almost like the
> account statement for each customer or vendor for that month.
> Please clarify how I can implement this solution with DTS. I can see a
> stored procedure can go through all the customers but how do I
> generate the statement for each customer into a .pdf output and then
> email that file to that vendor/customers email address from SQL+DTS
> Thanks
> Karen

Generating a personalised report for every vendor and mailing out the same

I have the following reporting scenario.
I have a table which contains a list of customers/vendors and each
record in this table as the customer/vendor number, name and email
address of the vendor and also the record as the value of the business
done by the vendor/customer for this month, year to date, last
year,etc our business wants reporting services to generate a report
for each customer/vendor from this table and email the resulting .pdf
report to the email address on this record.
Please clarify how I can implement this solution can reporting
services do this.
Thanks
KarenPlease look up data-driven query in Books Online. You will need to create a
subscriptions table with a column for each piece of data that is different
among all the report subscribers'; e-mail, vendor number, etc.
Charles Kangai, MCDBA, MCT
"Karen Middleton" wrote:
> I have the following reporting scenario.
> I have a table which contains a list of customers/vendors and each
> record in this table as the customer/vendor number, name and email
> address of the vendor and also the record as the value of the business
> done by the vendor/customer for this month, year to date, last
> year,etc our business wants reporting services to generate a report
> for each customer/vendor from this table and email the resulting .pdf
> report to the email address on this record.
> Please clarify how I can implement this solution can reporting
> services do this.
> Thanks
> Karen
>