Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

convert query result to excel file and emailing using xp_sendmail

Is there any way I can convert my query result to excel file and email that using xp_sendmail.


0
nakulamin
Asked:
nakulamin
  • 2
1 Solution
 
jogosCommented:
Exporting to excel, sounds like something you do with DTS (SQL 2000) or SSIS (SQL2005/SQL2008).
0
 
nakulaminAuthor Commented:
how can i use DTS with that....
0
 
jogosCommented:
DTS you can find in Enterprise manager.  In DTS you have to make your excel with your query-result.  
http://support.microsoft.com/kb/319951

Wtih the tasks you can do diffrent things, sql, script ..... send mail with attachement (if your server allows mail).
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now