|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
March 15th, 2004, 05:35 AM
|
|||
|
|||
|
Dts
Hi
i have a script(SQL select) that runs once every two weeks.  Is there a way i can take the results of that sql query and send them by email to someone?
|
|
#2
March 15th, 2004, 11:59 AM
|
|||
|
|||
|
well you can always put the result into a table(just duplicate the select but with an into), then send a email to look into this newly created table.
I'm not really familiar with Email & Sql..I know for sure that you can send a query to the server and it will return the result set... but the otherway around..dunno
|
|
#4
March 15th, 2004, 02:40 PM
|
||||
|
||||
|
You can have the DTS output to a text file and then send an email with attachment.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Dts |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
