Solved

SQL Server to email excel/csv files automatically

Posted on 2007-04-10
5
162 Views
Last Modified: 2010-04-20
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.
0
Comment
Question by:Albertino5175
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 10

Accepted Solution

by:
lahousden earned 250 total points
ID: 18884290
Do you have SQL Reporting Services installed?  That would be the best fit solution for this requirement.
0
 

Author Comment

by:Albertino5175
ID: 18884511
I do have it on SQL Server 2005, can you please tell me how it works?
0
 
LVL 10

Expert Comment

by:lahousden
ID: 19008375
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:
http://www.microsoft.com/sql/technologies/reporting/default.mspx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question