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 - 2002-05-30 : 09:45:30
|
| shriniwas writes "TO SQLTeam.com ,i am using sqlserver 7.i have created a profile in microsoft outlook 2002 and tested.it is tested successfully,then i configured that profile in "sql mail" in Enterprise manager under "support services" After that i am trying to send mail using xp_sendmail procedure thru Query analyser using master database.query:- EXEC xp_sendmail @recipients = 'tiwary@y-axis.com', @query = 'SELECT top 1 * FROM INFORMATION_SCHEMA.TABLES', @subject = 'SQL Server Report', @message = 'The contents of INFORMATION_SCHEMA.TABLES:', @attach_results = 'TRUE', @width = 250 But this query keep running for long,it is not stoping at all.can you suggest what could be most likely problem.regards tiwary" |
|
|
|
|
|
How to Setup sqlserver 7.0 mail using microsoft outlook 2002 profile.