Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-28 : 23:52:07
|
Luke writes "Here goes...
SQL Server 7.0 SP3
Windows NT 4.0 SP5
I have configured SQL Mail and it is working
sp_processmail is working fine also
What I am trying to do is this:
1. Use CDONTS to send a SQL query (stored procedure with arguments)
2. Use SQL Mail to execute the stored procedure (body of the email message)
3. Use SQL Mail to send notification that the stored procedure is complete. The message needs to contain a link to an ASP page that will display the results of the previously run stored procedure.
I do not have any problems with #1. When I get to number #2 I can process the stored procedure but the results are always returned via the email message. I tried using the @no_output='true' but I always get the output. The testing I am doing is with a small recordset but he final recordset will be quite large.
I have spent the last day searching the web for answers. I do not know if I am approaching this project with the proper tools. Any help and suggestions would be greatly appreciated." |
|
|
|
|
|
Using SQL Mail