Guys and girls,

  I have a daily report that I create retrieving dynamically the data from a SQL database. But now I want to show the non-registered users the same report, and for obviously I don't want them to connect to the DB since too many users connected could affet its performance. So, Is there a way to export my data so I can, I mean, "click" and create the daily report so the non-registered users can see the static report

thank you in advance,
Carlos:D

Carlos Manuel Colina
Web Developer
Multipuerta, CA
http://www.multipuerta.net
[email protected]
phone: +58 212 2066314
SMS/mobile: +58 412 6139001

SQLMail is the solution for you.

You need to have Microsoft exchange installed on server. It must have users also defined in it. Then SQL mail can be configured through enterprise manager of SQL 2000. Here is the stored procedure for you.

xp_sendmail @recipients='[email protected]', @subject='test', @message='test report from SQL mail', @query='select * from tbl_test_table', @dbuse='sa', @width=250

Alternatively, you can go to administer SQL Server option from SQL server.
Select "Publish to the web".
Choose the table / view.
Follow the instructions in the wizard.
You can also schedule publication (once in every week or so).

Hope that helps

Madhu

Hi Carlos,

You can check your SQL Books Online for sp_makewebtask

This generates HTML output file for a given query, which you can run as a scheduled job everyday(once), and that can be provided as link to the non-registered users.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection