RSS Reporter for SQL Server

Ad-Hoc Query Feeds

 

RSS Reporter for SQL Server provides for generating standard RSS feeds containing the output of an ad-hoc TSQL query. You can add an ad-hoc query to the profile by specifying the followings:

• Query Name: A name that identifies the query. The name appears in the bottom part of the screen and is also used as the feed title.
• Query Description: A description of the query in question.
• Database: Identifies the database that the query should run against. Note that you should read permission on the selected database.
• Item Title Field: A field from the query output that should be used as the title of the feed items. If no field is specified, the record count is used as the item title.
• Definition: It is the actual SQL Server select statement the output of which the will be used to generate the feed.
• The maximum number of records to be included in the feed - if left blank all records generated by the query will be included in the feed
• Number of fields that will be displayed in each row of the feed.

Once you have defined the query and saved it, the name of the rss feed appears at the bottom part of screen. You can modify the query settings by clicking on the "Edit" link, or you can delete it by clicking on the "Delete" link. The feed can be generated by clicking on the name of the feed.

Note: RSS Reporter excludes from the feed all the fields of the type binary, varbinary, image, text, ntext, timestamp and xml. If the feed is consumed in Microsoft Internet Explorer 7, it can be sorted by any of the fields that the query produces.