SQL Server to email excel/csv files automatically

This might be an easy question to answer, I need SQL Server to automatically email excel files or csv files reports from views or stored procedures that I have designed, what is the easiest way to do that, I have sql server 2000 running, no exchange server installed on my server, only IIS and SQL Server. A real life situation would be to email me stock levels of inventory on a weekly basis.
Who is Participating?
lahousdenConnect With a Mentor Commented:
Do you have SQL Reporting Services installed?  That would be the best fit solution for this requirement.
Albertino5175Author Commented:
I do have it on SQL Server 2005, can you please tell me how it works?
It is too broad a category to address in this forum, given that I do not know your current level of familiarity with the technology.  However, here is the MS starting point:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.